> 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

▲

marcobambini 7 months ago | parent [-]

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

▲

mholt 7 months ago | parent | next [-]

How does it compare to https://github.com/asg017/sqlite-vec ? Already using this in a big project.

	▲	marcobambini 7 months ago \| parent [-]
		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)

▲

intalentive 7 months ago | parent | prev [-]

Have you benchmarked against the usearch extension?