#566 — August 21, 2024 |
🏖️ Phew, it's been a while! Vacation over, and back to all things Postgres every week – for a few months at least ;-) |
|
Postgres Weekly |
|
|
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 PostgreSQL Global Development Group |
|
🦆🐘 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. Tigani and Griffin (MotherDuck) |
💡 The Register has a news piece with a little more background on the effort. |
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! Percona sponsor |
|
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.. Drew Silcock |
|
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. Eric Zakariasson |
|
QUICK BITS:
|
|
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. Robert Haas |
💡 If you're not sure what to even create a patch about, Tomas Vonda has written about how to pick your first patch. |
|
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. Conor O'Neill |
|
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. Gudivada, Jammula, et al. |
|
|
📄 Will Postgres Development Rely on Mailing Lists Forever? Tomas Vondra 📄 Dispelling Myths About Postgres' Default Privileges Sagar Jadhav 📄 The Best Postgres Feature You're Not Using: CTEs aka. WITH Clauses – A golden oldie. Craig Kerstiens 📄 Hash vs B-tree Indexes in Postgres Evgeniy Demin |
🛠 Code and Tools |
|
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. Ruohang Feng |
|
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. Steve Chavez and Joe Nelson |
|