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
SQL
A collection of essays to explore, one idea at a time.
Essays
Newest first
Architecture
Postgres SKIP LOCKED: The Lean Job Queue You Already Have
Build high-throughput background queues in PostgreSQL using FOR UPDATE SKIP LOCKED without adding Redis or RabbitMQ infrastructure.
Database
Stop Lost Updates: Fix Race Conditions with Optimistic Locking
Learn how Optimistic Locking prevents silent data overwrites in concurrent web applications with practical SQL and TypeScript code examples.
Backend
Stop Using OFFSET: Faster Pagination with Cursors
Learn why OFFSET pagination hurts database performance at scale, and how cursor pagination speeds up your queries with practical code examples.