SQLite + sqlite-vec Persistence
- Unified Storage: Vector embeddings and metadata live in the same SQLite database.
- ANN Indexing:
vec0 virtual table provides approximate nearest neighbor search with O(log N) query time.
- ACID Compliance: Built-in transaction support ensures atomic writes and data integrity.
- Go Fallback: If vec0 extension is unavailable, brute-force cosine similarity fallback.
Source document