> 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.
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.
> 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.
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.
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.
> 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!