Will WebSQL really be discontinued?
I am having a lot of problems when trying to run in production a program developed in HTML 5, Javascript, Ajax, JSON, IndexedDB, MySQL, PHP, along with the Intel XDK IDE.
The program is very simple it captures MySQL information and persists in IndexedDB, this only works in the emulation of Intel XDK, when I install it on mobile with Android 4.1.2 (API 16), it does not work, I use the plugins and even then it will not.
The question is, this project it has only one screen a button to perform synchronization and a ListView, and how simple is it at the moment if you use WebSQL that works perfectly and tomorrow or later WebSQL will even be discontinued ?
2 answers
Currently this technology is considered deprecated and should not be used.
No one can state when and if a technology currently supported by any platform will be supported in the future. History indicates that even certain things ceased to be certain at some point. It is part of the risk of developing a technology that may become obsolete and unsupported in future versions.
Specifically this technology is riskier. She is not considered standard, it is supported only on some web development platforms, it is almost certain that it will not be supported by others. And yes, one day it may no longer be supported on current platforms.
The lack of support in a certain way already occurs. I don't see this being worked on where it's officially supported. It seems to me to be a legacy. But I also don't see it being taken away from the platforms that support it any time soon.
The option is by IndexedDB. If you are having problems with him, try to heal them. Giving up does not seem to be the best option.
If you are absolutely sure that there is no solution then you can use alternatives. Ideally it would be interesting to support both technologies, the standard when it gives, and the alternative when it is the only possibility.
I see that you make a little confusion between IndexedDB and WebSQL, your question suggests that you are using IndexedDB.
But unfortunately his problem is with the WebView, only in the version 4.4 the WebView became based on Chromium, to be exact, it uses the same version of Chorme See 30 for Android... you can read more about it at the following link: WebView or Can I Use IndexedDB
So you have two options, continue with IndexedDB and Upgrade Android to 4.4+ or buy a more updated equipment.
Your second option is to use the SQLite, since I believe that IntelXDK is based on Cordova, you can use the following plugin: cordova-plugin-sqlite