Backend

How to build a PostgreSQL job queue with FOR UPDATE SKIP LOCKED, including schema design, atomic claiming, indexes, retries, stuck-job recovery, cleanup, and production trade-offs.

How to prevent race conditions in backend systems by naming the invariant, moving correctness to durable boundaries, and testing overlapping requests, retries, and jobs.

How to choose between optimistic locking, guarded updates, and SELECT FOR UPDATE in SQL when concurrent requests can overwrite data, oversell inventory, or serialize hot rows.

A practical guide to SQL isolation levels, including Read Committed, Repeatable Read, Serializable, database-specific behavior, locking trade-offs, and production examples.

How to implement the transactional outbox pattern for reliable event publishing, including schema design, relay claiming, retries, duplicate handling, ordering, CDC, monitoring, and cleanup.