// TOPIC
#indexing
3 articles
◆◆◆AdvancedElasticAmazon
01Design a Distributed Search Engine (Elasticsearch)
Index billions of documents and answer full-text queries in milliseconds. Inverted indexes, sharding + replication, scatter-gather, and relevance scoring.
#interview#search#indexing
21 min◆◆IntermediatePostgresMySQL
02Database Indexing
B-trees, LSM-trees, hash indexes, covering indexes, partial indexes — what they do, when they hurt, and how to read an EXPLAIN plan with confidence.
#databases#indexing#performance
15 min◆◆IntermediateGoogleYelp
03Design Yelp / Nearby Search (proximity service)
Find restaurants/businesses near a location, fast. Geohash, quadtree, hexagonal cells, and the right index for "within 5 km of me".
#interview#geo#search
16 min