Public list by ~postgresweekly

Issue 649 - Four features you'll actually feel in Postgres 19

PostgreSQL 18.4, 17.10, 16.14, 15.18, and 14.23 Released!

https://www.postgresql.org/about/news/postgresql-184-1710-1614-1518-and-1423-released-3297/

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.

3 months ago

Paste a Pull Request. Get a Greptile Review.

https://www.greptile.com/review

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.

#github pr review #paste a pr #ai pull request review #greptile review #instant code review demo

3 months ago

PostgreSQL 19 Beta: The Four Features You’ll Actually Feel

https://thebuild.com/blog/2026/05/18/postgresql-19-beta-the-four-features-youll-actually-feel/

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.

3 months ago

Welcome to ORDER BY jungle

https://boringsql.com/posts/order-by-jungle/

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.

3 months ago

plpgsql_wrap v1.0 released

https://www.postgresql.org/about/news/plpgsql_wrap-v10-released-3299/

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.

3 months ago

Supabase Is Now an Official ChatGPT App

https://supabase.com/blog/supabase-is-now-an-official-chatgpt-app

🤖 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.

3 months ago