medium10 pts · first answer countstransactionsconcurrencyatomic-updates
Flash sale stock without overselling
During a flash sale, many requests run this statement. How does the app know the item is sold out?
UPDATE items SET stock = stock - 1 WHERE id = 42 AND stock > 0;
Discussion 0
Join free to post in the discussion.
Related questions
- Durability in ACIDDatabase Administrator
- Why a write-ahead log existsDatabase Administrator
- What ROLLBACK undoesDatabase Administrator
- What C in ACID meansDatabase Administrator
- What I in ACID meansDatabase Administrator
- Statements without BEGINDatabase Administrator
- What a phantom read isDatabase Administrator
- PostgreSQL default isolationDatabase Administrator