Design Yelp or Nearby Friends
0%
Editorial Solution
System requirements
Functional
Capacity estimation
Traffic
API design
Business Search
Database design
PostgreSQL: Primary Data Store
High-level design
Search Path
Request flows
Business Search Flow
Detailed component design
Geospatial Indexing with Geohash
Trade-offs/Tech choices
Elasticsearch vs. PostgreSQL PostGIS
Failure scenarios/Bottlenecks
Elasticsearch Cluster Failure
Future improvements
Table of Contents
Premium content
UnlockPremium content
UnlockPremium content
UnlockPremium content
UnlockPremium content
UnlockPremium content
UnlockPremium content
UnlockPremium content
UnlockPremium content
UnlockPremium content
UnlockTry this problem yourself
Reading a solution is not the same as producing one under interview pressure. Design it on the whiteboard and get scored feedback.
Asked in these interview guides
Company guides that list this problem among their sample questions.
0%
Editorial Solution
System requirements
Functional
Capacity estimation
Traffic
API design
Business Search
Database design
PostgreSQL: Primary Data Store
High-level design
Search Path
Request flows
Business Search Flow
Detailed component design
Geospatial Indexing with Geohash
Trade-offs/Tech choices
Elasticsearch vs. PostgreSQL PostGIS
Failure scenarios/Bottlenecks
Elasticsearch Cluster Failure
Future improvements