Offline access - SQLite or Indexed DB?

html sqlite local-storage indexeddb
Taha picture Taha · Sep 3, 2012 · Viewed 35.5k times · Source

I am in the R&D phase of developing an application, with the following key requirements:

  • HTML5 web application - which will also have a hybrid version
  • Forms data will be stored locally, when no Internet connection

I cannot use web storage due to quota limitations - I am comparing SQLite and Indexed DB.

  • SQLite seems to be best fit, but it is deprecated
  • Indexed DB is a good alternative, but there's no Safari support - A hybrid application is supposed to be run on the iPad and on an Android device in the future.

I am confused in the selection of API. Is there some other alternative to SQLite or support of Indexed DB expected on Safari?

Answer

Robin Winslow picture Robin Winslow · Sep 3, 2012

I think abandoning IndexedDB would be a bad idea, because it's probably the format of the future, so Safari might stop supporting WebSQL.

It appears there are various JavaScript solutions to bridge the gap between the two - saving in whichever is available on the user's browser: JavaScript Library to Bridge IndexedDB and WebSQL I think this is probably your best solution.

Related questions

Is it possible to access an SQLite database from JavaScript?

I have a set of HTML files and a SQLite database, which I would like to access from the browser, using the file:// scheme. Is it possible to access the database and create queries (and tables) using JavaScript?

Read More
Intel XDK: Connecting your mobile app to a database

I am currently developing an application which if I don't have a database, the application after building will be heavy. How do I connect the application to a database, either local or remote? Thanks in advance.

Read More
HTML/JS as interface to local SQLite database

I'm writing a pretty simple database application, which I want to be locally stored (as opposed to looking up a remote database). I like HTML/Javascript for designing interfaces, and they're cross-platform (everybody has a browser!), so I'd really like …

Read More