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

[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

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

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

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