~postgresweekly | Issue 566 - Postgres 17 is just a month away.. (10)

New Releases of Every Maintained Line of Postgres — Namely 16.4, 15.8, 14.13, 13.16, 12.20, and even a third beta of Postgres 17. These are mainly for rolling out bug fixes, but a pg_dump vulnerability has also been resolved. Postgres 17 final is (tentatively) expected to land in September.

🦆🐘  Splicing Duck(DB) and Elephant DNA — DuckDB is a fast, in-process OLAP database system and a fantastic bit of engineering. It’s neat, then, to see an official pg_duckdb extension to bring DuckDB’s powers into the Postgres world, complete with backup from Microsoft, Hydra, and Neon.

PostgreSQL Upgrades, Simplified — Streamline your PostgreSQL upgrade with zero downtime. Our expert DBAs ensure smooth transitions, addressing blockers and performance issues. Plan, test, set up, and upgrade with ease. Fill out the form to start your upgrade today!

How Postgres Stores Data on Disk (This One's a Page Turner) — A great overview of how Postgres stores data on disk, covering segments, pages, and more. More depth than you need to know, until one day, you suddenly do..

Using Postgres as a Search Engine — Folks have used Postgres within search systems for years, not least with its strong full text indexing features. You can, however, go further with vector based semantic search and fuzzy matching. Eric brings together some ideas, complete with queries, here.

Posting Your Patch on pgsql-hackers — Robert continues his efforts to encourage new Postgres contributors by giving some tips on how to best approach submitting patches, particularly if the pgsql-hackers list was all crickets when you’ve tried to do so before.

Running Postgres Inside Node-RED via WASM and PGlite — Node-RED is a popular Node.js-based ‘low code’ programming environment where you build ‘flows’ in the browser to connect code together.

Building a Custom HTTP Client in Amazon Aurora and RDS — Oracle Database users can use the UTL_HTTP package to communicate with HTTP servers from their procedures, but when they migrate to Postgres on Aurora or RDS, a new approach is required.

Pigsty v3.0 Beta 1 Released with a Focus on Extensions — Pigsty is an interesting Postgres distribution that promises ‘batteries included’. It’s basically an RDS-like platform but to deploy as you wish. It now lets you easily install 333 extensions as well as ‘pluggable kernels’ like Babelfish, IvorySQL, and PolarDB.

PostgREST 12.2 Released: Access Postgres RESTfully — Now including Prometheus compatibility and statement timeouts, PostgREST is a Haskell based system for serving up a fully RESTful API from any Postgres database. GitHub repo.