How Airbnb Prevents Double-Booking with Database Constraints

Airbnb avoids double-booking by modeling availability as date ranges and using Postgres exclusion constraints to reject overlapping reservations atomically. Search runs on a separate, eventually consistent index while booking transactions commit against a strongly consistent store. Short-lived holds with expiry prevent phantom bookings during payment processing.