

Haystack
634 posts

@Haystack_AI
Open-source AI orchestration framework by @deepset_ai. Build context-engineered agents & RAG systems in Python. Discord for support → https://t.co/19wuHcilYP




























We assumed users would search for movie titles. We were wrong. The gap between how we store data and how users search for it is often where products fail. Our database was structured for exact title matches, but our FilmFlux users searched with intent. They typed "Mercy Johnson movies" or "2024 romantic comedy." Our SQL pattern matching returned zero results. The content existed, but the logic couldn't find it. To fix this, we architected a hybrid search system using Supabase Edge Functions. We found that pure semantic search fails on specific keywords, while pure keyword search fails on context. We needed both. The implementation combines four layers: - Semantic Understanding: OpenAI embeddings to match "vibe" and plot. - Intent Detection: Logic to parse natural language filters (years, genres). - Fuzzy Matching: pg_trgm to handle user typos. - Recency Weighting: Custom ranking to surface new hits, not obscure back-catalog titles. The result is a search bar that handles typos, understands context, and respects popularity. Don't force users to speak the database's language. Build the infrastructure to understand theirs. #SoftwareEngineering #SystemDesign #Supabase #SearchArchitecture

