Skip to content Skip to sidebar Skip to footer
Home / Android / Cordova / Iphone / Web Sql / Windows Phone 8

Phonegap - Sqlite Or Indexed Db?

Post a Comment
I am web developer starting with phonegap. I need to create one app for iPhone, android and Windows Phone 8. I need to store some data (too big for localStorage) locally. I don't

Solution 1:

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

Example

Solution 2:

Latest Update (May 05, 2014): New Cross Platform Cordova WebSQL plugin by MS Open Tech

Microsoft Open Technologies is publishing the new open sourceWebSQL pluginfor 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.

Solution 3:

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

Storage of SQLite database using Android and Phonegap

Solution 4:

LocalForage seems to be the best and newest solution: https://github.com/localForage/localForage (1000 commits, 83 contributors)

It has fallbacks for none supported navigators. I haven't tried it yet (over phonegap) but as soon I do i'll give you feedback ;)

Solution 5:

How about using my open source library, ydn-db? It has very nice abstraction layer on top of those.

Edit:

Post a Comment for "Phonegap - Sqlite Or Indexed Db?"