4 ms·

> SQLite is likely used more than all other database engines combined. Billions and billions of copies of SQLite exist in the wild. SQLite is found in: > Every

> SQLite is likely used more than all other database engines combined. Billions and billions of copies of SQLite exist in the wild. SQLite is found in: > Every Firefox, Chrome, and Safari web browser Where is SQLite in Firefox? It would be wonderful to use SQL in the browser, on the server, in mobile devices (everywhere!), but alas I suspect SQLite can be "found" in Firefox as the underlying storage engine on top of which IndexedDB is built. Dammit Mozilla, set SQLite free!

hnaccy 8y ago
That was Web SQL. https://hacks.mozilla.org/2010/06/beyond-html5-database-apis-and-the-road-to-indexeddb/ https://hacks.mozilla.org/2010/06/beyond-html5-database-apis...
- virtualwhys 8y ago
  > That was Web SQL and very much still is in Chrome and Safari, nearly 10 years after WebSQL was "deprecated". Firefox removed WebSQL, replacing it with IndexedDB, a simple k -> v store. Cross platform SQL everywhere? Not with Firefox still in the mix.
  - nerflad 8y ago
    Considering the Type-flexibility of SQLite, would it necessarily be too difficult to have an object-relational mapping that works across both DB's? I guess it depends on the application. Surely it would be a pain, but perhaps still a possibility.
bch 8y ago
https://support.mozilla.org/en-US/kb/profiles-where-firefox-stores-user-data https://support.mozilla.org/en-US/kb/profiles-where-firefox-... https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager-webext/ https://addons.mozilla.org/en-US/firefox/addon/sqlite-manage...
quietbritishjim 8y ago
I believe that quotation is just saying that Firefox uses SQLite to store some of its internal state, not that it has an API to interact with general SQLite databases.
- virtualwhys 8y ago
  > not that it has an API to interact with general SQLite databases Well, it did, but they removed it, and in fact spearheaded the movement to deprecate WebSQL circa 2010...when Firefox had significant marketshare. Chrome and Safari still, 10 years later, ship with WebSQL support, which makes it pretty clear which side of the fence they're on.

hnaccy 8y ago

That was Web SQL. https://hacks.mozilla.org/2010/06/beyond-html5-database-apis-and-the-road-to-indexeddb/ https://hacks.mozilla.org/2010/06/beyond-html5-database-apis...

virtualwhys 8y ago
> That was Web SQL and very much still is in Chrome and Safari, nearly 10 years after WebSQL was "deprecated". Firefox removed WebSQL, replacing it with IndexedDB, a simple k -> v store. Cross platform SQL everywhere? Not with Firefox still in the mix.
- nerflad 8y ago
  Considering the Type-flexibility of SQLite, would it necessarily be too difficult to have an object-relational mapping that works across both DB's? I guess it depends on the application. Surely it would be a pain, but perhaps still a possibility.

bch 8y ago

https://support.mozilla.org/en-US/kb/profiles-where-firefox-stores-user-data https://support.mozilla.org/en-US/kb/profiles-where-firefox-... https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager-webext/ https://addons.mozilla.org/en-US/firefox/addon/sqlite-manage...

quietbritishjim 8y ago

I believe that quotation is just saying that Firefox uses SQLite to store some of its internal state, not that it has an API to interact with general SQLite databases.

virtualwhys 8y ago
> not that it has an API to interact with general SQLite databases Well, it did, but they removed it, and in fact spearheaded the movement to deprecate WebSQL circa 2010...when Firefox had significant marketshare. Chrome and Safari still, 10 years later, ship with WebSQL support, which makes it pretty clear which side of the fence they're on.