Concurrency
PostgreSQL
Redis
System Design
How Race Conditions Can Still Happen Even After Wrapping in a DB Transaction and Row-Level Locking
Transactions and row locks fix the race everyone learns first — but duplicate orders and double-charges still slip through. Why idempotency keys aren't a complete fix on their own, and how a cache-based cooldown lock closes the gap.
Read the post