Load extension at run time?

[p3v9d5ui]

Sqlite includes the function load_extension() to load an extension at run-time, but that does not seem to have been implemented with this plugin. Is there a way to load an extension?

Thanks!

[brodycj]

That should be possible but it would need some deeper investigation.

I am hoping to support this kind of thing in a redesign as discussed in #862.

[p3v9d5ui]

The reason I ask for this is because I would like to use an extension that sorts Full-text results by relevance. An alternative would be to support FTS5 full-text indexes, which comes with a relevance function natively. Any possibility to add support for FTS5?

[brodycj]

FTS5 is already supported by brodybits/cordova-sqlite-ext.

[p3v9d5ui]

Is that a drop-in replacement?

[brodycj]

yes

[brodycj]

Please be sure to completely remove cordova-sqlite-storage before adding cordova-sqlite-ext. Please report if it works for you or not. Thanks!

[p3v9d5ui]

Hi @brodybits , I've replaced cordova-sqlite-storage with cordova-sqlite-ex and have experienced no issues. It was a drop-in replacement requiring no code changes, and the performance appears to be identical. I was able to switch the FTS indexes over to FTS5 and they're working fine.

[brodycj]

👍Thanks for the confirmation