~postgresweekly | Issue 601 - Bringing Postgres to VS Code (8)

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.

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.

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!

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

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.

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.

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