Postgres 18.4, 17.10, 16.14, 15.18, and 14.23 Released — All supported versions get an update to fix 11 security vulnerabilities and over 60 bugs. The vulnerabilities include serious memory corruption and trust-boundary bugs, not just in the server but also in clients that connect to malicious servers.

PostgreSQL Global Development Group

Would Greptile Have Caught That Postgres Bug? — Paste the GitHub PR that introduced it without signing up. Greptile reviews the old PR like a new one and shows the comments it would have left.

Greptile sponsor

Four Features You'll Actually Feel in Postgres 19 Beta — The final release isn’t till September, but the beta is due soon. Rather than look at headline features, Christophe focuses on things that change “how the database feels in production”, like JIT being turned off by default and parallel autovacuum index workers.

Christophe Pettus

The ORDER BY Jungle: Why ORDER BY Aliases Behave Strangely — ORDER BY a and ORDER BY -a look almost identical but hit two different parsers: the SQL-92 name path and the SQL-99 expression path. Radim traces the seam through aliases, GROUP BY, window functions, quoted identifiers, COLLATE, and UNION, down to the responsible function.

Radim Marek

plpgsql_wrap 1.0: A Way to Obfuscate PL/pgSQL Code — HexaCluster has open sourced its extension for distributing and running encrypted PL/pgSQL procedures that can be dumped and reloaded without end users being able to read them. Inspired by Oracle’s ‘wrap’ approach.

Gilles Darold (HexaCluster)

🤖 Supabase is Now an Official ChatGPT App — Supabase can now integrate with the ChatGPT app so you can manage your database, projects, and branches directly from it.

Greg Richardson (Supabase)

pgsqlite: A Postgres Protocol Adapter for SQLite Databases — A wire-protocol adapter that makes an SQLite database pretend to be Postgres, so the usual psql/pgAdmin/driver stack just works against it.

Eran Sandler