~postgresweekly | Issue 537 - Postgres - the database of the year in 2023 (10)

🏆  PostgreSQL: The DBMS of the Year 2023 — DB-Engines is a long-established site that collects information about (480 and counting) database systems, tracks their relative popularity, and shares which database gained the most relative popularity over the prior year. This time, it’s Postgres!

Thoughts on Postgres in 2024 — Postgres is in a good place, says Jonathan, who touches on a vast array of topics that relate to Postgres’s short term future, including feature gaps in replication, non-blocking schema changes, the ability to replay changes in parallel, as well as community building efforts.

Change Data Capture on Neon Serverless Postgres — Standard Postgres CDC via logical replication is now available on Neon. Sync changes to OLAP databases, stream updates to Kafka, the possibilities are, like the WAL, endless!

Postgres 17 Adds Support for Incremental Backup — Postgres 17 is still several months away, but it’s great to see features like this being committed. Robert Haas shares some thoughts on use cases.

My Postgres Wishlist — We love Postgres, but it could always be better [citation needed] 😏. Ryan wants to start a conversation around some ideas for improvements he’s had – there’s not much that'll be controversial here, it’s a solid and interesting list.

How to 'Copy-and-Paste' a New Postgres Dev Env in 5 Minutes — Mostly aimed at folks who want to check out the Postgres source and get it up and running fast, particularly on EC2.

pg_rman: Backup and Restore Management Tool — There are numerous Postgres backup and restore tools, but pg_rman’s features include support for point-in-time recovery (PITR) and the way it can manage and catalog multiple backup versions. Full documentation.

pg_savior: Extension to Prevent Dangerous DELETEs — Prevents accidental data loss caused by DELETE queries without a WHERE clause limiting the scope. The implementation is very simple (if a little naive in how it works) but it’s a cute idea and could be inspirational for your own similar extensions.

🤖 gptsql: LLM Chat with Your Postgres Database — An experimental tool that brings together OpenAI’s GPT models and your Postgres database in order to ask questions about/'to' it in real time (well, real time-ish). There’s a demo video in the README that shows off the idea.

Introducing prometheus_fdw: Seamless Monitoring in Postgres — "What you have: all your monitoring data and analytics stored over there in Prometheus. What you’d like to have: all of that data over here in your Postgres database…"