First of all, the one that has been deprecated by W3C is WebSQL not SQLite
IndexedDB –
- It is incompatible with many types of mobile OS and is only compatible with certain types of versions of mobile OS
- Developers cannot use SQL with IndexedDB. They can with SQLite and WebSQL
- Most developers actively avoid using IndexedDB as much as they can
WebSQL –
- It has been deprecated by W3C which means it is no longer maintained or developed
- It requires another plugin called Polyfill to enable mobile applications to work with popular mobile OS such as Google Android and Apple iOS
SQLite –
- It received an award from Google
- SQLite has its official website. IndexedDB and WebSQL do not
- On Google, SQLite returns 4.3 million results. WebSQL returns a bit less than 700K results and IndexedDB returns 282K results.
If you want a quick tutorial on SQLite,
Storage of SQLite database using Android and Phonegap