Postgres SKIP LOCKED Queue: Build a Job Queue with Row-Level Locking
Build a Postgres job queue with FOR UPDATE SKIP LOCKED step by step: schema, dequeue query, worker models, retries, idempotency, vacuum and trade-offs.
14 min read
Archive
320 published
Build a Postgres job queue with FOR UPDATE SKIP LOCKED step by step: schema, dequeue query, worker models, retries, idempotency, vacuum and trade-offs.
14 min read
Learn how to design a modular monolith: drawing module boundaries, enforcing data ownership and dependency rules in CI, testing, and when to extract services.
13 min read
Use env vars as the delivery contract and a versioned source of truth to manage shared configuration, validate at startup, and detect config drift.
18 min read
Learn what counts as a breaking change, how to evolve microservice APIs compatibly, and when URI, header or media-type versioning is worth its cost.
18 min read
Compare Docker Compose and Kubernetes by how each handles failure, scaling and deploys, what each costs to run, and the signs that it's time to migrate.
13 min read
Model engineering cost as rework and waiting hours, then cut it with faster CI, smaller PRs, targeted design docs and platform work, without lowering quality.
12 min read
Compare Nx vs Turborepo by task model, build caching, affected runs, boundaries, and CI cost, with a decision framework for backend and platform engineers.
12 min read
Learn when to use microservices vs a monolith, the forces behind the architecture decision, real costs of distributed systems, and a safe extraction path.
11 min read