Hacker News Reader

> 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

View on HN

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?

Reply on news.ycombinator.com