tagged: row-locks
PostgreSQL Locks, Part 2: Row-Level Locks
sep 2026The second of three parts on PostgreSQL locking: the four row-level lock modes, why FOR NO KEY UPDATE should be your default, NOWAIT and SKIP LOCKED, deadlocks, and how a blocked transaction actually waits.
Pessimistic vs Optimistic Concurrency in Postgres
aug 2026A seat reservation race solved with PostgreSQL row locks and conditional updates, using TypeScript and Drizzle ORM.