Thread: JSON vs SQLITE
View Single Post
Old 03-17-2026, 08:25 PM   #7
varia
Connoisseur
varia can spell AND pronounce 'liseuse.'varia can spell AND pronounce 'liseuse.'varia can spell AND pronounce 'liseuse.'varia can spell AND pronounce 'liseuse.'varia can spell AND pronounce 'liseuse.'varia can spell AND pronounce 'liseuse.'varia can spell AND pronounce 'liseuse.'varia can spell AND pronounce 'liseuse.'varia can spell AND pronounce 'liseuse.'varia can spell AND pronounce 'liseuse.'varia can spell AND pronounce 'liseuse.'
 
varia's Avatar
 
Posts: 57
Karma: 39844
Join Date: Jan 2026
Device: Samsung Galaxy Tab S10 Lite
Quote:
Originally Posted by BetterRed View Post
As I read this from Comfy.n, and the attached popop from his RSS Reader plugin, a SQLite database should not be located in the calibre configuration directory.

Yet, calibre stores its server-users.sqlite database in its configuration directory. Other apps also have sqlite databases stored in their equivalent to calibre's configuration directory - e.g. my %appdata%\Mozilla\Firefox directory has hundreds of them.
BR
I'm no expert but that seems to make sense, storing a plugin database out of the calibre confic directory, just to be on the safe side.

Quote:
One advantage to .json files is that they can be accessed, and edited with a text editor, whereas a sqlite database requires a tool such as DB Browser or SQL Studio to do the same.
This did cross my mind so it's good to see that validation.


Quote:
In my ideal world each plugin would have a subdirectory in which the plugin zip and all of its data, settings, help files etc were located.
Do you mean packaged in such a way so as to install the plugin with all user data/settings etc already in place? Like a personal single-file backup being installed to a new computer?
Or just for the zip and all data/settings to be located in a single folder?
varia is offline   Reply With Quote