We'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
How does it compare to https://github.com/asg017/sqlite-vec ? Already using this in a big project.
Our implementation is much faster and does not require to store vectors into a virtual table (which forces the user to write complex join statements)
Have you benchmarked against the usearch extension?