Any plans for supporting SQLite?

[timuckun]

The title says it all. Seems like it would be a popular option.

[andreibondarev]

@timuckun For RAG/vectorsearch capabilities, right? I had given https://github.com/asg017/sqlite-vss a spin a few months ago but had a lot of issues with it. It could be worth giving https://github.com/asg017/sqlite-vec a try!

[timuckun]

I wonder what turso is using. https://turso.tech/vector

Unfortunately there are no native ruby clients for turso.

[visini]

FYI: There is now, see https://github.com/tursodatabase/libsql-ruby

[andreibondarev]

@timuckun Do you have a current need for a Langchain::Vectorsearch::SQLite adapter?

[timuckun]

I could use it in a project I am thinking about. Happy to test it for you while I work on it.

[andreibondarev]

That would be amazing!

[timuckun]

I can start on the project this weekend. I'll have to some other code to write first but I'll start a project with Sqlite in rails. You let me know when you are ready to test anything.