Is there a way to cause SQLite to load dynamic extensions via DbVis?
a
anonymous
started a topic
almost 9 years ago
[This topic is migrated from our old forums. The original author name has been removed]
SQLite has the ability to load custom extensions at runtime. One great extension is the Unicode library [Nunicode|https://bitbucket.org/alekseyt/nunicode] which provides unicode collation and case folding features.
There apears to be a SQLite function, [load_extension] https://www.sqlite.org/lang_corefunc.html#load_extension which could be used to load the extension but this is throwing an error in DbVis. The error is "[SQLITE_ERROR] SQL error or missing database (near "load_extension": syntax error)"
If using SQLite from the command line, the extension can be loaded using the syntax ".load ".
Any suggestions for doing this via DbVis would be greatly appreciated.
Thanks
Tom
Edited by: Hans Bergsten on Oct 29, 2015 9:11 PM
1 Comment
Hans Bergsten
said
almost 9 years ago
[This reply is migrated from our old forums.]
Re: Is there a way to cause SQLite to load dynamic extensions via DbVis?
Hi Tom,
This is most likely a driver issue, as it seems like the driver does not recognize the syntax. I don't have this enabled and I do not have an extension readily available to test with, but when I add "select" to the function call, I get a different error message that seems to indicate that the statement is at least passed to the database:
select load_extension('foo')
If this doesn't work, please ask for help in the SQLite driver community:
https://bitbucket.org/xerial/sqlite-jdbc
Best Regards,
Hans
anonymous