Funnily enough, I just started working on a vector search extension for SQLite today: https://github.com/Ronsor/VecDex

That is great! I'll keep an eye.

I've been playing with this extension: https://github.com/asg017/sqlite-vss