PostgreSQL
41 articles in the last 30 days.
-
How I Got Postgres into a Single Binary
miniPG is a single executable that embeds a full Postgres server and client and works like the sqlite3 CLI. You point it at a directory and query it, with no server or Docker needed.
-
Relevance Is Not Permission: Filter-First Vector Search in PostgreSQL
Shows how to enforce access control for RAG retrieval inside PostgreSQL using Row Level Security on a pgvector chunk table, so agents cannot bypass permission checks in application code.
-
PostgreSQL 19 vs 18: Native REPACK, pg_plan_advice, Graph Myth & Production Upgrade Guide
Compares PostgreSQL 19 with 18, covering native REPACK CONCURRENTLY, pg_plan_advice, ON CONFLICT DO SELECT and parallel index autovacuum. It also warns of default changes such as JIT now being off and a startup failure from the old io_workers setting.
-
pgjumbo: A PostgreSQL Client for macOS, Windows, and Linux
pgjumbo is a free new PostgreSQL client that shows which rows, triggers and cascades a write will touch, and lets you rehearse it before committing.
-
What's left in Postgres 19
PostgreSQL 19 is out after several delays and reverts. The author highlights the interesting features that remain and notes that the list of lost features is long.