Instead of sqlite-vec you can take a look at the new sqlite-vector extension: https://substack.com/home/post/p-172465902

Uuuuh, that looks super interesting! I hadn't heard of that. Thank you for sharing!