Postgres Weekly Issue 600: May 15, 2025

#600 — May 15, 2025

Together with

PostgREST 13: A RESTful API for Postgres Databases — A standalone web server that turns your Postgres database directly into a RESTful HTTP API. v13.0 adds support for spread to-many relationships and automatic tsvector conversion allowing the use of fts on text and json types out of the box.

Joe Nelson and Steve Chavez

Postgres 18 Beta is Out: 7 Features You Should Know About — Last week’s big news was the release of Postgres 18 Beta 1. Neon has put together a quick roundup of seven features to be aware of.

Heikki Linnakangas (Neon)

POSETTE 2025: Save the Date! — POSETTE: An Event for Postgres, a free & virtual developer event, is less than a month away -- June 10-12. Learn from 45 experts from the PostgreSQL ecosystem. Choose from 42 unique talks via 4 livestreams with live chat on Discord. Save the date.

Microsoft sponsor

IN BRIEF:

The Neon serverless Postgres platform has announced it's being acquired by Databricks. Nothing is set to change for users in the near-term, however.
In other Postgres platform news, Xata is 'relaunching' as a new cloud-agnostic scaling-focused Postgres service boasting instant copy-on-write branches, and data anonymization.
🎤 The Postgres FM podcast's latest episode tackles ▶️ the top ten dangerous Postgres related issues.
📱 Schema is a new Postgres and MySQL database client for iOS. I think I'd struggle to work on a database on my phone, but it does look well designed.
🇩🇪 PGConf.DE took place in Berlin last week and there are a couple of trip reports covering what happened there.

📄 Good Enough Ten-Second Sum Types for Postgres Evan Silberman

📄 Implementing Event Triggers Without Superuser Access – This relates to Supabase’s Supautils extension. Steve Chavez

📄 A Tale of Migrating from CockroachDB to Postgres Sean Callahan

📄 Managing Bloat Using pgstattuple on Azure Database for PostgreSQL Flexible Server Gayathri Paderla (Microsoft)

📄 How to Upgrade Postgres 16 to 17 on Ubuntu 25.04 Paolo Melchiorre

📄 How LLMs Are Revolutionizing Database Queries Through Natural Language Joe Harwood (QueryHub)

🛠 Code and Tools

pgModeler 1.2: A Postgres Database Modelling Tool — An easy way to create and edit database models in a more visual way. It’s packaged up as a paid product but is also open source (GPLv3 – repo here) so you can build it yourself. v1.2 is a significant update.

Raphael Araújo e Silva

pgwatch 3.3: A Postgres Monitoring Solution — A self-contained metrics monitoring dashboard tool for Postgres servers. Can be easily deployed with Docker in a non-invasive way (no extensions needed). GitHub repo.

CYBERTEC

Vircadia: A Postgres-Powered Reactivity Layer for Games — It seems to be early days, but the idea is you can use Vircadia to simulate agentic worlds and manage in-game entities through SQL.

Vircadia

FerretDB 2.2 – A database that acts like MongoDB but uses Postgres for storage. (As an aside, the co-founder of FerretDB recently joined Claire Giordano on the Talking Postgres podcast to talk about FerretDB and why they chose Postgres to be its backend.)
River 0.22 – Robust job processing system for Go and Postgres.
pgroll 0.12 – Zero-downtime, reversible, schema migrations.