Dave Allie: ULIDs and Primary Keys
A curated list of awesome PostgreSQL software, libraries, tools and resources
BonesMoses.org: PG Phriday: Why Postgres is the Best Database Engine
Richard Yen: When Less is More: Database Connection Scaling (2021)
Modern SQL: The ANY_VALUE(…) Aggregate Function
Aiven: SQL query optimization: a comprehensive developer's guide
Emil Privér:
Grant Fritchey: Functions and Procedures
Michael is joined by Markus Winand, creator of use-the-index-luke.com and modern-sql.com, and author of SQL Performance Explained, to discuss Modern SQL — what Markus means by it, why it's important, some benefits, some examples, and at least one phrase that should be on a t-shirt.
Tembo: How we built our customer data warehouse all on Postgres
Airbyte: A Guide to Logical Replication and CDC in PostgreSQL
DB-Engines: PostgreSQL is the DBMS of the Year 2023
For determining the DBMS of the year, we subtracted the popularity scores of January 2023 from the latest scores of January 2024. We use the difference of these numbers, rather than a percentage, because that would favor systems with a tiny popularity at the beginning of the year. The result is a list of DBMSs sorted by how much they managed to increase their popularity in 2023, or in other words, how many additional people started to communicate about it in one of the ways we measure in our methodology, for example job offers, professional profile entries and citations on the web.
Phil Booth: Nine ways to shoot yourself in the foot with PostgreSQL
Jonathan Katz: Thoughts on PostgreSQL in 2024
Stormatics: The pgvector Revolution in Text Search