Treasure I found below the waterline
What broke, what I hauled back up, and what I'd dive for again.
2026
The double booking problem, and how Postgres solves it
Two people click "book" on the same room at the same second. Here is why the obvious code lets both through, and how one constraint in Postgres stops it for good.