SQLite works shockingly well. The agents know how to write good queries, know ho...

		theahura 4 days ago \| parent \| context \| favorite \| on: Ask HN: How are you doing RAG locally? SQLite works shockingly well. The agents know how to write good queries, know how to chain queries, and can generally manipulate the DB however they need. At nori (https://usenori.ai/watchtower) we use SQLite + vec0 + fts5 for semantic and word search