Hi electron coders!
I am in need of some guidance - I have created a desktop app that loads tables that are 100Mb with the help of
AngularGrid(loads my large Json data fast!)
But now I want to go beyond loading static tables and I would like to be able to query a JSON or use a relational DB to process tables that are a few hundred megs in size about ~2-5mill rows(All data needs to be offline). I don’t want to load all that data at once but instead query it without the user waiting for it to load.
I don’t really care what DB to use as long as I can do the above.
I couldn’t get SQLite3 to work with electron, json query languages fail since they need to load the whole file…any suggestions on how to approach it?
Edit: Grammer, Clarity