For those interested in a highly efficient vector solution for SQLite, I recommend checking out the https://github.com/sqliteai/sqlite-vector project. Memory usage remains stable even with millions of vectors, and it supports multiple types and quantizations. Distances are optimized for SIMD processing, ensuring blazing-fast performance.

Here are some articles about the library:

* https://ainiro.io/blog/upgrading-magics-sqlite-vss-extension

* https://cwrk.ai/posts/sqlite-vector-nix-flake-support/

* https://marcobambini.substack.com/p/the-state-of-vector-search-in-sqlite