Life Altering Postgres Patterns — The author promises the title isn’t just clickbait and delivers twelve different bite-size, hard-learned tips and insights in areas from using UUIDs as primary keys and table naming to the use of schemas and views.

Ethan McCue

A Practical Guide to Taming Postgres Isolation Anomalies — A practical, Ruby-based (though SQL heavy) walkthrough of Postgres’ concurrency control, detailing real-world issues like lost updates, write skew, and other isolation anomalies. Even if you rarely run into conflicts, you’ll come away with valuable insights on managing transactions.

Dan Svetlov

Learn PostgreSQL Best Practices While You Code with AI-Powered Reviews — CodeRabbit spots PostgreSQL performance issues during code reviews. Our AI flags slow queries, missing indexes, and ORM pitfalls—explaining each fix in plain terms. We're free for open source and already helping popular Postgres tools ship better code. Get started!

CodeRabbit sponsor

Why Postgres Needs a Better API for Alternative Table Engines? — Postgres has mechanisms for allowing extensions to provide their own index types and table access methods, but it’s still not as easy to roll out powerful alternative table engines as it could be. Alexander of OrioleDB explains the limitations and some potential ways forward.

Alexander Korotkov

Semantic Search in Postgres: An Overview — Full text search is great, but if you want to query data based on its meaning rather than the literal data, you’ll need to bring in extensions like pgvector. Hans-Jürgen explains how it all works here.

Hans-Jürgen Schönig

🔒 A Postgres Security Checklist — The Center for Internet Security (CIS) releases security benchmarks for a variety of popular tools and services used in Internet infrastructure, and now there’s a set of Postgres guidelines (though it's behind an email wall with commercial-use restrictions, alas).

Elizabeth Christensen

Creating Postgres Roles with Passwords Stored in Gopass — Gopass is a Go-powered CLI-based password manager for teams.

Thomas Klausner

Reducing Cloud Spend: Migrating Logs from CloudWatch to Iceberg with Postgres — Postgres provider Crunchy Data has a lot of logs to store and storing those in AWS CloudWatch costs a lot too. Craig explains how Crunchy Data implemented a new workflow to store the logs in Iceberg tables on S3 instead, while still allowing SQL querying via Crunchy Data Warehouse.

Craig Kerstiens

Teable: Open Source Airtable Alternative atop Postgres — Airtable is a popular data table database SaaS, but here’s an open-source alternative along similar lines that sits atop Postgres and allows direct data querying with SQL. GitHub repo.

Teable Team

⭐ Electric 1.0: A Postgres Sync Engine — “Electric solves sync.” The idea is that if you have data in Postgres you need to sync elsewhere, Electric solves the hard problems of sync for you, including partial replication, fan-out, and data delivery, no matter your data model or Web framework. More info here.

James Arthur (Electric DB)

Rainfrog 0.3: A Database Management TUI for Postgres — Think a little more structured than psql with vim-style navigation of queries, history, schemas, etc.

Carl Liu