UUIDv7 Comes to PostgreSQL 18

PostgreSQL 18 adds native support for UUIDv7. A timestamp-based UUID variant that plays nicely with btree indexes. Here's what that means for you.

Introducing pg_karnak: Transactional schema migration across tenant databases

Dive deep into the architecture of pg_karnak, PostgreSQL extension, metadata store and transaction coordinator designed for reliable and scalable schema migrations across many tenants and Postgres instances. This post explores PostgreSQL internals, including extension hooks, transaction lifecycle, and locking mechanisms, offering insights into building scalable, reliable systems for distributed applications.

It is time for Postgres to care about customers!

I am excited to announce that Nile is live today!