I would say that WebSQL is a great option for databases on mobile devices. It supports a "large" amount of data (compared to localStorage) and allows you to work locally.
In fact, I am developing an application that stores data “locally”. It processes data locally through many queries and operations in the database, all that is used in WebSQL.
I do not see the possibility of continuing my application without WebSQL, as it will be discontinued in the middle of this month.
This is due to the fact that I use a local table that checks the user login (using synchronization from the first start / manually with the server). (I can say that the user and password tables are about 500 lines) This application is also able to register and delete people (not related as users), this is a huge amount of data, for example, information about 10 thousand people (address, age, birth and etc.).
There are many routines for checking data updates with the server when connected to the network. It also syncs for service when new people register (when connected).
Now, I see that the end of the line continues to evolve using telephone communications using some database storage. localStorage is not an option due to the amount of data, nor the request method (it takes a lot with a lot of data) indexedDB is missing on iOS and Android, so this is far from my solution.
Can someone give (us) some glare from the database repository in cross-platform development? What can I use to continue my application and not throw it away using WebSQL?
Thanks in advance!
source
share