SQLite plugin and offline database use

So, here is my use case for my app.

I am writing an application for a company in British Columbia Canada that contracts with the electrical utility. I created a web application that takes in the contract given to my client, and parses it out into individual tasks. They will have the tasks accesible by the Android device. Some of the work they do takes them into very remote areas of British Columbia and so I need to be able to download records to take offline.

I have already written a web api in C# and I am retrieving records into AB fine.

One contract will have about 500 related tasks and between 5,000 and 9,000 task detail rows.

I have seen some people here using Pouch DB and I am curious of anyones experience in offline data.

Ryan

Hello Ryan,

I have not experience using PouchDB (maybe other customers can post here something about) even when here in this forum it's possible to find some posts related with PouchDB. The main problem with offline data is that the browsers vendors (probably with good reasons) don't allow us to use the file system, so, we can't store database files, etc. We can use the app's local storage, but, maybe it's not enough (even when it's quite powerful).

Talking about Android and other platforms the above problem do not exists, that is, in this case we can access the file system using some Apache Cordova plugins, in fact, we have actions ready to use like "FileRead" and "FileWrite". Just this can be a possible way to store not only text files, but also JSON files, for example, so we can load it and use it in our apps in an "offline" way.

We can't forget the server's databases, since they can offer us all their power, and we can just use certain scripts in the server side in order to communicate with that databases and work with them. I don't have experience using some Apache Cordova SQLite plugin, but I am sure that must works as expected, so, if our targers are Cordova platform's and not the browsers (even when we can provide another approach in this last case) we can think to use an Apache Cordova plugin to deal with SQLite... or maybe another kind of client databases too.