Thread: JSON vs SQLITE
View Single Post
Old 03-17-2026, 04:49 PM   #1
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
JSON vs SQLITE

Moving into the next phase of Reading Tracker plugin, I am exploring backup/import/export utility. For what this plugin does, what would make the most sense, JSON files or SQLITE? Currently some json files are in use, but moving into the next phase I want to ensure the correct choices are made.

As of now the plugin does the following:
Bulk metadata retrieval
Sorting and filtering
Dynamic queries
Yearly aggregation of reading and book statistics
Streak calculation with date parsing and timezone awreness
Tracking progress vs goals; challenge vs goals
Journal logging
Reading challenge management

If a user wants to load in a library of tens of thousands of books would json files be enough for export/import? Sqlite?
Any insight would be appreciated.

Couple of screenshots included for the cat tax.
Attached Thumbnails
Click image for larger version

Name:	Screenshot 2026-03-17 154031.png
Views:	38
Size:	107.9 KB
ID:	221863   Click image for larger version

Name:	Screenshot 2026-03-17 154140.png
Views:	40
Size:	269.4 KB
ID:	221864  
varia is offline   Reply With Quote