Local Business Reviews (Yelp)
Difficulty: Easy
What It Tests
Geo search, read-heavy systems, search indexing.
Topics Covered
- Proximity / Geo Search
- API Design
- Database Design: SQL vs NoSQL
- Caching
- Search & Elasticsearch
- Database Indexing
Hello Interview Breakdown
Read the full Hello Interview breakdown →
Approach Hints
- Store businesses with geohash-indexed location in PostgreSQL
- Use Elasticsearch for full-text search + geo_distance query
- Cache top-rated businesses per city in Redis
- Paginate results with cursor-based pagination