sqlite-vec is an incredibly small and fast vector search SQLite extension that is suitable for various platforms. It allows users to store and query float, int8, and binary vectors in virtual tables, with the ability to pre-filter vectors using subqueries. The extension, written in pure C, is compatible with Linux, MacOS, Windows, browsers with WASM, and even Raspberry Pis. Despite being a pre-v1 version, users should anticipate breaking changes. Notably, sqlite-vec is a Mozilla Builders project with support from Fly.io, Turso, and SQLite Cloud. Installation instructions are provided for various languages such as Python, Node.js, Ruby, Go, and Rust. The extension’s unique functionality includes the ability to create virtual tables and perform KNN style queries on vector samples. It is also supported by various generous sponsors, including Mozilla and other companies. Controversially, sqlite-vec is a pre-v1 version with potential breaking changes, so users should proceed with caution.
https://github.com/asg017/sqlite-vec