lmorchard - Pebbling Club 🐧🪨

Hybrid full-text search and vector search with SQLite | Alex Garcia's Blog

alexgarcia.xyz
2024-10-02T18:41:37.270Z
sqlite ml ai emberring search

Notes

You can use SQLite's builtin full-text search (FTS5) extension and semantic search with sqlite-vec to create "hybrid search" in your applications. You can combine results using different methods like keyword-first, re-ranking by "semantics", and reciprocal rank fusion. Best of all, since it's all in SQLite, experiments and prototypes are cheap and easy, no 3rd party services required!

Unfurl

{ "description": "Combine SQLite’s builtin FTS5 full-text search extension with the sqlite-vec vector search extension for hybrid search!", "image": "https://blog-static.alxg.xyz/Screenshot%202024-10-02%20at%208.43.30%E2%80%AFAM.png", "publisher": "Alex Garcia's Blog", "title": "Hybrid full-text search and vector search with SQLite", "url": "https://alexgarcia.xyz/blog/2024/sqlite-vec-hybrid-search/index.html", "lang": "en", "failed": true, "failedAt": 1728192764807, "failedError": "TimeoutError: Promise timed out after 10000 milliseconds", "cached": true, "cachedAt": 1728192764834, "expires": 1728363545731, "status": 200, "bodyLength": 96280, "duration": 4870 }

0 - 50 of 1 items

10 25 50 100 250