|
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.
|