PostgreSQL
Tool · Text & code
strong
Mature, permissively licensed database; version 19 adds useful replica read-consistency.
PostgreSQL 19 released, about two months later than the usual September schedule
Why we say so
The PostgreSQL project says 19 shipped about two months later than the usual September schedule. Robert Haas, relayed by Simon Willison, attributes the delay mainly to a flurry of AI-reported vulnerabilities. Willison calls the new WAIT FOR LSN command, which gives read-your-writes consistency on standbys, his favorite feature.
Evidence
- Nov 19New WAIT FOR LSN command lets a standby wait for WAL replay to a given LSN, giving read-your-writes consistency
- Nov 19Willison calls WAIT FOR LSN his favorite new feature; store pg_current_wal_insert_lsn() in a cookie, then wait with an optional timeout before reading on a replica