Request for new SQLite Extension - spellfix1

[mdsspsd]

Hi,

I've tried opening com.plexapp.plugins.library.db from Plex Media Server which requires spellfix1 ("Error introspecting database Plex, error: no such module: spellfix1")

Is there a manual way to load spellfix1.dll?

Thank you!

[mikeburgh]

Yes, load_extension() is enabled on SQLite connections, so you can point it at your own build of spellfix

Edit the connection, expand Advanced, set Post-Connection SQL Source to Inline Script, and drop this in:

SELECT load_extension('C:\path\to\spellfix1.dll');

That runs before introspection, so the spellfix1 virtual tables will resolve and the tree should load.

If you just want to browse the Plex database and don't need spellfix queries.. edit the connection, and enable the Progressive Loading under Advanced. Schema details then load on demand, so a table whose module is missing won't block introspection.

Details on both: https://dbcode.io/docs/supported-databases/sqlite and https://dbcode.io/docs/connections/schema

[mdsspsd]

load_extension didn't work for me, not sure why.

Progressive Loading did the trick, thanks