Menu
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?
872
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.
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.
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.
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.
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.
78
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
