#Search

Overcoming the limitations of pure vector database search in RAG pipelines. An honest guide to implementing keyword-based BM25, combining results with Reciprocal Rank Fusion (RRF), and applying Cohere Rerank to boost context quality.

You don't always need Elasticsearch. PostgreSQL's built-in Full-Text Search handles most search needs without extra infrastructure.

Started with SQL LIKE, hit its limits, moved to Elasticsearch, and got shocked by operational costs. The real trade-offs of search systems.

Why 'SELECT * FROM words WHERE word LIKE "app%"' is too slow. How Tries solve prefix search in O(L) time. Implementation guide and Radix Tree optimization.

Learn BST via Up & Down game. Why DBs use B-Trees over Hash Tables. Deep dive into AVL, Red-Black Trees, Splay Trees, and Treaps.

Two ways to escape a maze. Spread out wide (BFS) or dig deep (DFS)? Who finds the shortest path?