⇦2020-08-21| leontrolski.github.io
This article tells you why SELECT FOR UPDATE is almost always the wrong lock and that you should use SELECT FOR NO KEY UPDATE instead.| CYBERTEC PostgreSQL | Services & Support
Deadlocks are a natural hurdle in backend development, but with a bit of digging and careful design they can be identified and resolved.| incident.io
Deploying DB schema changes in heavily loaded systems is challenging. In this article, we explore one of the challenges - how to avoid situations when DDLs get blocked, wait to acquire a lock, and during that, start blocking other sessions.| PostgresAI
Clarifying a few possible ways to implement resumable workflows when working with external APIs.| thoughtbot