Airline booking: holding seats correctly when many people book at once
Airline case study, part 2: why check-then-act oversells, conditional updates for a counter and the throughput ceiling of a hot row, SKIP LOCKED for auto-assignment and its false sold-out trap, deadlocks when customers pick seats and how to lock in a fixed order, hold expiry, Spring Boot 3 code and MySQL 8 differences.