Search systems
Inspired by System Design Interview: Design Ticketmaster w/ a Ex-Meta Staff Engineer
Postgres is fine to begin with for basic search. Select where like term. When would somethint else be more relevant ?
Wildcard search are slow tho, it'll scan the whole db. But Ok to satisfy functional requirements fast
SELECT * FROM documents WHERE document_text LIKE '%search_term%'
In this topic
- ElasticSearchGrowing
It builds an inverted index to make searching documents by terms quickly. Example: taylor: (event1, event2) Tokenization in Elasticsearch is the process of breaking a stream of text characters down into smaller,…
Sources
- System Design Interview: Design Ticketmaster w/ a Ex-Meta Staff Engineer inspired this note