Choosing a RAG backend for local AI — an opinionated map:🗄 sqlite-vss / sqlite-vec: zero infra, great for single-machine...

Choosing a RAG backend for local AI — an opinionated map:🗄 sqlite-vss / sqlite-vec: zero infra, great for single-machine dev📦 Qdrant: best self-hosted HNSW perf, ships as a single binary🐘 pgvector: already on Postgres? just stay there🔍 OpenSearch: when you need hybrid full-text + vector at real scaleRule: start with the simplest store that runs locally. Migrate when you hit actual limits — not imagined ones.#localai #rag #selfhosted #ai #homelab