SQLite + sqlite-vec (per-tenant search index)

A lightning-fast vector search extension for SQLite that enables cost-effective, per-tenant indexing within standard database files.

SQLite combined with the sqlite-vec extension transforms a standard relational database into a high-performance vector store. By storing embeddings in per-tenant SQLite files (or separate tables), developers can achieve strict data isolation and sub-millisecond query times without the overhead of a centralized vector database. This setup supports float32 and int8 vectors, utilizes SIMD-accelerated distance calculations (L2, cosine, dot product), and runs anywhere SQLite does: from edge devices to cloud servers. It is the ideal stack for multi-tenant SaaS applications requiring 100k+ vector searches with zero infrastructure bloat.

https://github.com/asg017/sqlite-vec