Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Does IE support indexedDB, WebSQL, or a database similar to SQLite?

For Chrome, I can use IndexedDB and WebSQL, for Firefox, I can use IndexedDB, what about IE? I have developed an app that uses WebSQL and it works fine on desktop Chrome and Safari, iOS Safari and Android browser. Next, I want to port it to Desktop Firefox and IE. I'm considering IndexedDB, but finding out IE doesn't really support it. What alternative do I have?

like image 872
netmobile Avatar asked Jun 11 '12 22:06

netmobile


People also ask

Does IndexedDB use SQLite?

TIL: IE uses the same database format as Exchange and Active Directory for IndexedDB. Firefox is using SQLite so are kind of implementing a NoSQL database in to SQL database. Chrome (and WebKit) are using a Key/ Value store which has heritage in BigTable.

Is IndexedDB supported by all browsers?

IndexedDB on Chrome is fully supported on 23-106, partially supported on 11-22, and not supported on 4-10 Chrome versions. IndexedDB on Safari is fully supported on 10-16, partially supported on 7.1-14.1, and not supported on 3.2-7 Safari versions.

Is WebSQL deprecated?

WebSQL in third-party contexts is now deprecated. Removal is expected in Chrome 97. The Web SQL Database standard was first proposed in April 2009 and abandoned in November 2010. Gecko never implemented this feature and WebKit deprecated this feature in 2019.

What is IndexedDB and WebSQL?

IndexedDB used to have a competing spec called WebSQL Database, but it was deprecated by the W3C. While both IndexedDB and WebSQL are solutions for storage, they do not offer the same functionalities. WebSQL Database is a relational database access system, whereas IndexedDB is an indexed table system.


1 Answers

IE10 supports IndexedDB. You can also use localStorage in IE8+. For older versions, you can use proprietary userData behavior: http://www.javascriptkit.com/javatutors/domstorage2.shtml

Please note that WebSQL database is deprecated and specification is no longer maintained.

like image 78
duri Avatar answered Sep 24 '22 16:09

duri