#625 — November 20, 2025 |
|
Postgres Weekly |
|
|
RegreSQL: Regression Testing for Postgres Queries — A look into a Go-powered tool for applying Postgres’s own regression testing methodology to your SQL queries in order to verify that changes, whether to your queries or schema, don’t break how you expect those queries to work (e.g. are the right indexes or scan types still being used?) Radim Marek |
Agentic Postgres: AI-Ready Postgres for Developers — Tiger Data’s Agentic Postgres turns vanilla Postgres into an AI-native database. Fork DBs, give agents memory, and query via REST or CLI. Perfect for Go backends building with Claude, Cursor, or custom agents. Try it free—no card needed. Tiger Data sponsor |
|
Microsoft Unveils a New Postgres Service: Azure HorizonDB — Azure already has Azure Database for PostgreSQL, but HorizonDB offers “new levels of performance and scalability” with support for up to 3072 vCores across nodes and databases of up to 128TB in size for enterprise workloads. It’s currently in “early preview” and I suspect you’ll need deep pockets. Microsoft |
|
IN BRIEF:
|
|
Storing Products, Prices and Orders in Postgres — Tackles the problems that can be caused by over-optimistic normalization when storing product information. Hans-Jürgen Schönig |
|
PostGIS Performance: Intersection Predicates and Overlays — The latest in a series of posts on getting the most out of PostGIS, performance-wise. Paul Ramsey |
|
📄 Updating Passwords Now That MD5 Password Support is Deprecated – It’s boring work, but someone’s gotta do it. Dan Langille 📊 Comparing PlanetScale PostgreSQL with Hetzner Local Postgres – Apples to oranges, of course. Muhammad Azeez 📄 How to Use UUIDv7 in Python, Django and Postgres Paolo Melchiorre |
|
RELEASES AND CODE: |
|
|
PgManage 1.4: Web Tool for Database Management — An open source Web-based interface that’s Postgres-centric but also supports MySQL, SQLite and Oracle. You can work with multiple databases at once, look at tables, views, functions, etc., view query plans, and get SQL autocompletion for building queries. Command Prompt, Inc. |
|
🌐 Martin 1.0: Fast, Lightweight PostGIS, MBtiles & PMtiles Tile Server — A geospatial tile server and set of tools able to generate vector tiles on the fly from large PG databases, and serve tiles from PMTiles and MBTiles files. Reaches v1.0 after eight years of development. You can see a demo on its homepage. MapLibre Contributors |
|
|
pg_flo: Stream, Transform, and Route Postgres Data in Real-time — Offers a set of filters and transformations that can make moving data between, say, production and staging databases simple using one of three modes: copy-and-stream, stream-only, or a one-time copy. Uses NATS and Postgres’s replication. Shayon Mukherjee |
|
Spock: Logical Multi-Master PostgreSQL Replication pgEdge |
|