Postgres SQLAlchemy Textbook Ch. 5 — Locking, Advisory Locks, and SKIP LOCKED
Postgres locking patterns: SELECT FOR UPDATE, NOWAIT, SKIP LOCKED, advisory locks, application locks, deadlock retry.
Locking
SQLAlchemy + Postgres Cheatsheet 07 — Locking, SKIP LOCKED, Advisory Locks
Cheatsheet: row locking, NOWAIT, SKIP LOCKED queue, advisory locks (session and tx scoped).
Postgres Locking in 2026 — Row Locks, Advisory Locks, and Avoiding Deadlocks
Practical Postgres locking: SELECT FOR UPDATE, NOWAIT, SKIP LOCKED, advisory locks, isolation levels, and how to debug locking problems.