The use case is to have an application store data on the client side when offline. Is it advisable to use the Web SQL Database (which Chrome and Safari support, not FF though), or wait for the browsers to implement the Indexed Database API?
views:
512answers:
2
A:
It looks like WebSQL is on it's way out, to be replaced by IndexedDB support. Firefox and Internet Explorer have no plans to support WebSQL, they want to implement IndexedDB for Firefox 4 and IE9. Chrome is busy implementing it to, I'm sure Opera and Safari will follow suit.
Currently all HTML5 capable browsers (and some IE versions) support LocalStorage which is a simple key/value database that can only store strings, so if you need more structured storage capabilities, you'll have to wait until the end of this year (approx) for broad IndexedDB support.
Sunday Ironfoot
2010-06-09 11:36:10
I am looking for a structured storage, may be CouchDB is probably the choice for now.
rnella01
2010-06-10 13:44:40
CouchDB won't run in the browser (AFAIK), it's a database technology that runs on the server, so it won't work with HTML5 Offline Storage.
Sunday Ironfoot
2010-06-11 14:44:11
"It looks like WebSQL is on it's way out, to be replaced by IndexedDB support"Is this really the case? I've seen some discussion of the subject...http://sites.google.com/a/chromium.org/dev/developers/design-documents/indexeddbhttps://lists.webkit.org/pipermail/webkit-dev/2010-January/011409.html...but Google only announced Chrome Web SQL support on 25 January: http://blog.chromium.org/2010/01/more-resources-for-developers.html...and Safari has continued to support Web SQL since Safari 3.1 and iPhone OS 2.0:http://bit.ly/c7z1Pe
Sam Dutton
2010-08-11 13:27:35
Webkit browsers (Chrome and Safari) have had WebSQL support for a while, and will continue to include it for quite some time (once you add something, it takes a very long time to remove it because of backwards compatibility concerns). Look at this way, both IE and Firefox won't be implementing WebSql and those are the two largest browsers in the world in market share, so that kinda rules out WebSql. An interim solution might be to have both Sql and IndexedDB code on your web apps, but that's a very temporary solution, both the Webkit browsers (and Opera) will implement IndexedDB eventually.
Sunday Ironfoot
2010-08-11 16:33:49