Is it possible to use the sqlite as a vector database with this ?

[RocketRene]

I am new to go and sqlite, and I want to build a small project that uses LLMs, embeddings and so on. I would be very happy if I would not have to run a real vector db because that's an overkill for my use case. Can I use https://github.com/asg017/sqlite-vss and this library in combination ?
And is it possible to generate type safe code with https://github.com/sqlc-dev/sqlc ?

[zombiezen]

I am new to go and sqlite, and I want to build a small project that uses LLMs, embeddings and so on. I would be very happy if I would not have to run a real vector db because that's an overkill for my use case. Can I use https://github.com/asg017/sqlite-vss and this library in combination ?

Not directly, sadly, since this library does not support dynamic loading C extensions. You might be able to use modernc.org/ccgo/v4 to translate the extension into Go and then hook it up with the virtual table API.

And is it possible to generate type safe code with https://github.com/sqlc-dev/sqlc ?

Again, I'm not aware of an ability to do that directly right now. According to the sqlc docs, the codegen only supports database/sql. I'm not sure how hard it would be for them to add support for this package's API, but I imagine it could be done as a different backend.

[RocketRene]

Thank you very much for taking the time to write this answer 😄 🙏
Then I will probably not use this library for now .. :( It would just make everything more difficult for me to understand.