I haven't done much with browser client-side data storage, so I didn't know if browsers were looking to unify the data backends they used for web database/storage and for application data. But the Working Group ultimately gave up, citing an "impasse" in which "all interested implementors have used the same SQL backend (Sqlite), but we need multiple independent implementations to proceed along a standardisation path." ![]() The W3C attempted to define a specification for a Web SQL Database API, which included the requirement that the "the SQL dialect supported by Sqlite 3.6.19.". SQLite is also used by browsers as the backend for client-side data storage API. Google Chrome, Firefox, Safari, iOS Safari, the Android Browser, and Opera use SQLite to store a variety of user data and configuration, including bookmarks, cookies, and web history. So what you're saying is that I could go in and edit the Wikipedia entry to say this: There is a third-party add-on that uses the code supporting this functionality to provide a user interface for managing arbitrary SQLite databases. Mozilla Firefox and Mozilla Thunderbird store a variety of configuration data (bookmarks, cookies, contacts etc.) in internally managed SQLite databases. And to reiterate what I quoted before, this is what it has under the Web browsers heading (I didn't previously include both bullet points): Yes I agree the things I posted were kind of random, but I was posting what was on the SQLite Wikipedia page, because it's the first thing that comes up (understandably) when searching for browser support of SQLite. I see someone saying that "the interface to sqlite engine.has been removed in Firefox 57".Īnyone have info on SQLite3 and future browser compatibility? ![]() Looking it up, I don't see an explicit mention that SQLite3 is gone or deprecated. I had heard the popular SQLite Manager for Firefox plugin recently stopped working after the release of Firefox Quantum. But nothing about the future of SQLite3 in existing browsers. Its Wikipedia entry mentions that it has support in Firefox, Chrome, IE 10, Safari 8+, and also mentions an apparently dead W3C spec for the "Web SQL Database". I don't know anything about IndexedDB, though it seems to be a browser standard for a database API, not a database itself. ![]() The browsers Google Chrome, Opera, Safari and the Android Browser all allow for storing information in, and retrieving it from, a SQLite database within the browser, using the Web SQL Database technology, although this is rapidly becoming deprecated (namely superseded by IndexedDB). I'm updating the guide so I did a quick looksee to see the status of SQLite adoption, and I found this in SQLite's Wikipedia entry: I've written a guide about learning SQLite by using it to explore your own web history, because of SQLite's near ubiquity among popular browsers - Chrome, Safari, Firefox, though not IE/Edge.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |