Tag

PostgreSQL

2 diagram-led guides on PostgreSQL by Abhishek Goyal.

Deep diveNewMembers

Choosing a Search Engine: Elasticsearch vs Postgres vs Redis vs OpenSearch, Solr and Typesense

How to choose a search engine in system design: what a separate search cluster really costs, real full-text search in Postgres with tsvector, GIN and pg_trgm, Redis Search and MongoDB Search, the Lucene family (Elasticsearch, OpenSearch, Solr), Typesense, Meilisearch and Vespa, and a decision flow you can defend in an interview.

~14 min read · Beginner → Senior · 3 diagrams
Deep diveNewMembers

Search System Design Case Studies: Discord, GitHub, LinkedIn, Uber, Pinterest and More

Real-world search system design case studies for HLD interviews: how Discord, GitHub, LinkedIn, Uber, DoorDash, Yelp, Instacart, Pinterest, Twitter, Slack, eBay and others scaled Elasticsearch, built their own Lucene engines, added vector and hybrid search, and ranked results, with the patterns that repeat.

~18 min read · Beginner → Senior · 7 diagrams