https://github.com/asg017/sqlite-vss is one of the most widely used sqlite extensions that give a vector search capabilities to a sqlite data base. It is open vide range of ai empowered and locatfirst mobile applications.

You made a good job to include a json and cr-sql as a out of the box extensions.

We need a vector search for our use case at mykin.ai

I see a few solutions