#629 — December 18, 2025 |
🗓️ This is the final issue of 2025, but we need to note that in 2026, Postgres Weekly will be moving to Wednesdays, as part of a reshuffle for most of our newsletters. |
|
Postgres Weekly |
|
|
pg_textsearch is Now Open Source — A fantastic Christmas present! Two months ago, Tiger Data unveiled pg_textsearch as a Postgres extension for bringing BM25 ranking to full text search, but it was limited to their cloud. Now, though, you can bring it to your own Postgres server too, if you can install extensions (I found it easy to compile and install on Postgres.app for testing). Tiger Data |
💡 VectorChord and ParadeDB offer similar functionality in Postgres but with different tradeoffs and licensing. |
Submit Your POSETTE 2026 Proposal – The CFP is Open! — Spread the cheer: share your Postgres story at POSETTE: An Event for Postgres, a free & virtual developer event organized by the PostgreSQL team at Microsoft—happening June 16-18, 2026. Make a gift to the community—submit by Feb 1. Details inside. Microsoft sponsor |
|
Which Indexes Could Be Corrupted After an OS Upgrade? — Underlying operating system upgrades can update dependencies that change the definitions of collations used by Postgres. Laurenz explains the problem and how to tackle it. Laurenz Albe |
|
IN BRIEF:
|
|
On Postgres 18's New Default for Data Checksums — Postgres 18 enables data checksums by default as a mechanism for protecting against silent data corruption. Greg Sabino Mullane |
|
🎤 What You Can Expect From PGConf.dev — Melanie Plageman joins Claire Giordano to discuss what you can expect of next May’s PGConf.dev 2026 event in Vancouver, Canada. Talking Postgres Podcast |
💡 PGConf.dev's CFP is open till January 16, 2026 if you'd like to speak. |
|
xsql: Convert SQL Schema DDL Between SQL Dialects — A Rust-powered command line tool for converting DDL between SQL dialects, including MySQL, Postgres and SQLite. Dawit Worku |
|
📄 14x Faster Faceted Search in Postgres with ParadeDB – Or, teaching Postgres to facet like Elasticsearch. James Blackwood-Sewell 📄 The Pitfalls of Partitioning Postgres Yourself Alexander Belanger |
|
|
THE TOP CODE ITEMS OF 2025: We're going to do a retrospective of the best items from 2025 in the next issue, but for now we're going to focus on the libraries, tools, and releases that got the most engagement this year: |
|
1. Microsoft Unveiled its VS Code 'IDE for Postgres' — Back in May, Microsoft unveiled a preview of its new Postgres extension for the VS Code editor that lets you manage database objects, use IntelliSense to build queries and integrate with Copilot. Microsoft |
|
2. Multigres: Vitess for Postgres — Vitess is a popular clustering system for scaling and sharding MySQL and this year Supabase hired Sugu Sougoumarane, one of its creators, to build a Vitess for Postgres. It's still in the early stages, but development is taking place here. Paul Copplestone (Supabase) |
|
3. DocumentDB: Microsoft Brings More NoSQL to Postgres — Not to be confused with Amazon's proprietary DocumentDB, this DocumentDB is an MIT-licensed document-based NoSQL engine built on top of Postgres that Microsoft was originally using internally for Azure Cosmos DB for MongoDB. Microsoft |
|
4. pgcalendar: 'Infinite' Calendar Functionality for Recurring Schedules — If you need to store schedules for events, potentially with exceptions (like holidays or cancellations), this extension provides a way to model that. Examples. Huseyin Akbas |
|
5. PostgREST 14: A RESTful API for Postgres Databases — 2025 was a busy year for the standalone web server that turns your Postgres database directly into a RESTful HTTP API with both v13 and v14 being released. Joe Nelson and Steve Chavez |
|
🎄 This is the final issue of Postgres Weekly for 2025 – thanks for reading, submitting links, and supporting us! We're going to return on Wednesday, January 7, 2026. See you then! |