#601 — May 22, 2025 |
|
Postgres Weekly |
![]() |
Microsoft Unveils an IDE for Postgres in VS Code — Microsoft has unveiled a public preview of a new Postgres extension for its VS Code editor that lets you manage database objects, use IntelliSense to build queries, and integrate with Copilot too. Microsoft |
pgconf.dev 2025 Wraps Up with Great Success in Montreal — I’ve heard from numerous sources that last week’s PGConf.dev event was a raging success, and this is one of the most thorough writeups (complete with photos) I’ve ever seen of a Postgres event. Hopefully we’ll get to see some of the videos too in coming weeks. Cary Huang |
💡 If you want to get ahead of 2026's event, it's back in Vancouver on May 19–22. |
![]() [New from O’Reilly] The 2nd Edition of CockroachDB: The Definitive Guide — Learn how to build resilient, scalable apps with a Postgres-compatible distributed SQL database. Same Postgres feel—familiar tools, schema, and queries—built to scale globally, on premise or in any cloud, with native geo-data placement and low TCO. Cockroach Labs sponsor |
IN BRIEF:
|
Creating Short Alphanumeric Pseudorandom Identifiers — Suppose you need to create a readable and unique multi-character identifier to represent an ID, but without being as long as a UUID (think something like a YouTube video ID). PL/PgSQL to the rescue! Andrew Atkinson |
▶ Scaling Postgres: A Weekly Show about Postgres — For several years now, Creston has been producing a video a week where he digs into the latest Postgres news, articles, and so forth – much like us, but he gets to riff a little more and share his experiences and insights. Creston Jamison |
Data Archiving and Retention in Postgres — Daria presents her slides, along with explanations, from her talk at PGConf Germany where she covered best practices when working with large datasets. Lots of good tips in here. Daria Nikolaenko |
📄 How to Safely Perform Backfill Operations in TimescaleDB Semab Tariq 📄 Rendering the Mandelbrot Set with SQL – Still a favorite query of ours. PostgreSQL Wiki |
🛠 Code and Tools |
dblab: An Interactive Client for Postgres, MySQL, and More — A Go-powered cross-platform (yes, including Windows) TUI-style app for working with various database systems. Certainly looks different to the standard CLI clients. Daniel Omar Vergara Pérez |
A Handy PostgreSQL Command Line Options Cheatsheet Diego Kartones |
|