3 ms·
> Every SQLite Cloud database comes with the sqlite-vec extension pre-installed. sqlite-vec is currently built and optimized for brute-force vector search. This
by hbcondo714 1y ago
> Every SQLite Cloud database comes with the sqlite-vec extension pre-installed. sqlite-vec is currently built and optimized for brute-force vector search. This means there is no approximate nearest neighbor search available at this time[1]
Darn, ANN would be awesome to have on the edge.
[1]: https://docs.sqlitecloud.io/docs/vector https://docs.sqlitecloud.io/docs/vector
- marcobambini 1y agoWe'll soon announce a new extension: sqlite-vector. It is blazing fast, highly optimized, and even performs well on memory-constrained devices. Already tested with 5M 1500-dimensional vectors. The repo is currently private, and we'll make it public soon: https://github.com/sqliteai/sqlite-vector https://github.com/sqliteai/sqlite-vector
- mholt 1y agoHow does it compare to https://github.com/asg017/sqlite-vec https://github.com/asg017/sqlite-vec ? Already using this in a big project.
- marcobambini 1y agoOur implementation is much faster and does not require to store vectors into a virtual table (which forces the user to write complex join statements)
- intalentive 1y agoHave you benchmarked against the usearch extension?