search

frectonz / sql-studio

SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB, DuckDB]
https://sql-studio.frectonz.io/
MIT License
1.47k stars 26 forks source link

no such module: spellfix1 #6

Open yowmamasita opened 1 week ago

yowmamasita commented 1 week ago

Opening Plex sqlite database:

./sqlite-studio /var/lib/plexmediaserver/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db --address 0.0.0.0:3030
2024-06-17T07:55:25.304260Z  INFO sqlite_studio: found 82 tables in /var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db
2024-06-17T07:55:25.304454Z  INFO Server::run{addr=0.0.0.0:3030}: warp::server: listening on http://0.0.0.0:3030
2024-06-17T07:55:35.726239Z ERROR sqlite_studio::handlers: error while getting database overview: Rusqlite("no such module: spellfix1")
frectonz commented 1 week ago

Seems like the Plex SQLite database uses the spellfix1 SQLite extension. I will look into this. We might need to support the most common SQLite extensions.