Backend Engineering
Why Postgres SKIP LOCKED Eliminates the Message Broker Tax
Learn how PostgreSQL's FOR UPDATE SKIP LOCKED builds transaction-safe background queues without Redis, RabbitMQ, or dual-write headaches.
Topic
Database Architecture
A collection of essays to explore, one idea at a time.
Essays
Newest first
Backend Development
Preventing Overlapping Bookings with PostgreSQL Exclusion Constraints
Stop race conditions and double bookings permanently by leveraging PostgreSQL range types and GiST exclusion constraints at the database level.
B-Tree
Why UUIDv7 Is Replacing UUIDv4 for Database Keys
Learn how UUIDv7 solves B-tree index fragmentation and buffer pool churn caused by UUIDv4, delivering sequential write performance with distributed uniqueness.