I am currently in the process of selecting a suitable local database for my offline ElectronJS application. The Desktop App will need to perform operations such as adding, updating, deleting, and retrieving data from JSON files locally. Here is an overview of the database structure:
{
'data':[
{
'day':1344546000,
'transactions':[
{'time':'blabla', 'value1':'100',...},
{'time':'blabla', 'value1':'100',...},
{'time':'blabla', 'value1':'100',...},
]
},
{
'day':1344546000,
'transactions':[
{'time':'blabla', 'value1':'100',...},
{'time':'blabla', 'value1':'100',...},
{'time':'blabla', 'value1':'100',...},
]
},
....
]
}
The requirement is that this data needs to be stored locally in json file/files, so that if the user closes the app and opens it again, the data can be retrieved seamlessly.
Each day object will contain less than 500 transactions per day