sqlite extensions
Zoxive opened this issue · 6 comments
Curious if theres any one else interested in having the ability to load sqlite extensions?
https://www.sqlite.org/loadext.html
(Personally im looking to experiment with https://github.com/vlcn-io/cr-sqlite)
Upvote & Fund
- We're using Polar.sh so you can upvote and help fund this issue.
- We receive the funding once the issue is completed & confirmed by you.
- Thank you in advance for helping prioritize & fund our backlog.
No idea how to load external extensions, I guess if you manage to compile it and load it as a dylib you can try to enable it on runtime. You will have to try it yourself and maybe I will get to it one day
I've been looking into this since react-native-quick-sqlite, and I was wondering whether it'd be possible to simply expose sqlite3_load_extension()?
sqlite-android appears to support it by using just that.
In case you didn't know @Zoxive, Expo has been working with Matt on getting proper bindings and integration between cr-sqlite and expo-sqlite!
I'm personally looking to extend FTS5 with custom tokenizers, but I don't know nearly enough C++ to figure it out 😅
exposing sqlite3_load_extension should be easy, the compilation step not so much, but that will be left as an exercise to the reader I guess. Each to his own.
sounds good! lots of great plugins to choose from. For instance their vector search plugin would be great to do local vector search for ai apps - and no good way to use this plugin in a react native project yet (in a convenient way).
I think exposing sqlite3_load_extension would be a great option, as there are awesome extensions for sqlite, hope to see it soon.
I've created a funding goal for this issue, once it is reached I will take care of it