What are Extensions đź”—PostgreSQL added support for extensions in version 9.1. These extensions can be loaded into a database to add new functionalities without modifying the core engine.
Before extensions, we had contrib modules for similar purposes, but extensions provided a cleaner way to track dependencies and standardized the process.
Many extensions come with the standard installation of PostgreSQL. Here are some extensions that come with PostgreSQL 18:
postgres=# SELECT * FROM pg_available_extensions LIMIT 5; name | default_version | installed_version | comment -----------------+-----------------+-------------------+------------------------------------------------------------- refint | 1.
I sometimes end up in programming/AI rabbit holes on Reddit. This weekend I browsed for many, many posts where the point of discussion was AI skill issues. “You don’t prompt well,” “add a Agent.md,” “Ask LLM to re-eval their work,” “Ask to create a feedback loop to optimize initial prompts,” and many more. So many pre-implementation steps. So many guardrails. It’s like baby-proofing a house or, likely, asking the baby to baby-proof the house.
Breaking Free from Social Media Addiction 🔗I’ll be honest - the best thing you can do for your own growth, mental health and better mood is get off social media. It’s very difficult though, not because you are addicted but because in lot of careers and personal relationships social media have become very relevant.
The second best thing I can do is minimize your usage. Let’s discuss strategies I personally use.