I'm developing an app that needs offline storage SQL.
I try:
if (window.openDatabase) {
window.db = window.openDatabase("app", "", "my app db name", 1024*1024);
}
this works great on Chrome but doesn't work on my Firefox 3.6
What version of firefox will support openDatabase?
Chosen solution There are only 2 currently updated and supported Released versions, Firefox 9.0. 1 and Firefox 3.6. 25.
Firefox is still very much alive and well as Mozilla has no plans to stop development of their web browsers for desktop (Windows, macOS, Linux) and mobile versions for iOS and Android. Firefox has been their main product.
Web SQL Database is a deprecated web browser API specification for storing data in databases that can be queried using SQL variant. The API is supported by Google Chrome, Opera, and the Android Browser.
Firefox desktop has an entire SQLite database, storage. sqlite , that contains no tables. It is used entirely to reference the schema version value and uses that value to create the version number for the Storage directory. The Storage directory contains all of the files and stores used by the app.
Mozilla have said they will never implement it according to this thread:
HTML5 IndexedDB, Web SQL Database and browser wars
I believe FF is working towards implementing IndexedDB instead.
If you're interested to know what browsers support what you can check out Caniuse. In particular about local storage see this
Edit: Oops! I didn't realize this was a year old.
Default location for WebSQL DB in case of Firefox:
C:\Users\username\AppData\Roaming\Mozilla\Firefox\Profiles\mlolddya.default\databases\
For Chrome:
C:\Users\username\AppData\Local\Google\Chrome\User Data\Default\databases\
for safari:
C:\Users\username\AppData\Local\Apple Computer\Safari\Databases\
new version of FF are not using WebSQL they are moved to IndexedDB.which is good no need to give support for two different db if you dont want to give support for Safari
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