phonegap - sqlite or Indexed DB?
Cordova WP8 supports IndexedDB only. iOS and Android WebSql only. Since WebSql is deprecated (I know how many people love/use it and agree that in many situations WebSql is very cool) I would recommend to proceed with IndexedDb and use the following polyfill for Android/iOS.
PhoneGap polyfill for IndexedDB that makes the IndexedDB API to work with WebSQL
Latest Update (May 05, 2014): New Cross Platform Cordova WebSQL plugin by MS Open Tech
Microsoft Open Technologies is publishing the new open source WebSQL plugin for Apache Cordova and PhoneGap. This plugin allows developers to integrate a persistent SQL-based local storage solution in their Cordova apps using the exact same JavaScript code across Android, iOS, Windows Phone and Windows Store.
IndexedDB -
- It is incompatible with many types of popular mobile OS and versions
- It is only compatible with very specific versions of mobile OS
- Developers cannot use SQL with IndexedDB. SQL statements can be used on 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 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 1.8 million results. WebSQL returns a bit less than 700K results and IndexedDB returns 282K results.
- Developer can use common SQL statements with SQLite
- It is compatible with most versions of all popoular mobile OS such as iOS and Android
If you want a quick tutorial on SQLite