Tag
#database
3 articles tagged database.
HLDintermediate
OYO / Airbnb HLD: Find Places Near Me, Free for My Dates
An Airbnb / OYO system design: geospatial search with geohash prefixes, date-range availability, booking without double-booking, the data model, and scaling location search.
9 min read
HLDintermediate
Google Calendar DB Design: Store the Recurrence Rule, Not a Million Rows
A database deep dive on modelling Google Calendar: storing a recurrence rule instead of infinite instances, expanding on read, cancellations and overrides, timezones/DST, and time-range queries.
10 min read
HLDintermediate
Reddit Comments DB Design: Modelling a Threaded Tree That Scales
A database deep dive on modelling Reddit-style threaded comments in SQL: adjacency list vs materialized path vs closure table, fetching a subtree in one query, plus scores and sharding by post.
9 min read