A developer iterates through three rounds of building hybrid search (semantic + lexical) for their personal site. Pure vector search failed to surface exact-match results like library names and API identifiers. The solution combines Cloudflare Vectorize for semantic search with SQLite FTS5/D1 for lexical BM25 search, fused via
Table of contents
The Problem With Pure Vector SearchRound 1: Building Hybrid SearchRound 2: The Production FailureWhy That Still Bothered MeRound 3: One Search WorkerHow It Works NowWhat I LearnedSort: