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

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

Premium content

Unlock

Premium content

Unlock

Premium content

Unlock

Premium content

Unlock

Premium content

Unlock

Premium content

Unlock

Premium content

Unlock

Premium content

Unlock

Premium content

Unlock

Premium content

Unlock
Try 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.


Markdown supported

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

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