Questions about integrating and using the sqlite-vec extension

[supperman009]

Is your feature request related to a problem? Please describe.
I want to conveniently use some extensions of SQLite, such as the vector extension sqlite-vec, when using the JDBC driver. However, I don't know how to easily integrate the sqlite-vec extension with the JDBC driver. How can I make it convenient for Java to use the vector extension features when calling the SQLite database?

Describe the solution you'd like
I don't want to perform any compilation operations. I would like to simply specify the sqlite-vec .so or .dll file, so that I can smoothly use the SQLite features with the extension loaded in JDBC.

[glaforge]

I'm also curious if we can somehow use the sqlite-vec extension.
Can the extension be loaded somehow, without having to modify sqlite-jdbc in any way?
Or does it require some special support on the sqlite-jdbc side to work?

[gotson]

You need to enable the pragma, then you can SELECT load_extension("extension-functions");