Web SQL Database
{{Short description|Deprecated Web browser API}}
{{Use dmy dates|date=August 2021}}
Web SQL Database was a web browser API specification for storing data in databases that can be queried using SQL variant.{{cite web|url=http://www.w3.org/TR/webdatabase/ |title=Web SQL Database (W3C Working Group Note)|publisher=W3.org |access-date=25 October 2011}}Nelson, Anne Fulcher, and Nelson, William Harris Morehead. (2001). Building Electronic Commerce with Web Database Constructions. Boston, MA: Addison Wesley. Introduced in 2011 and quickly deprecated in favor of Web Storage API and IndexedDB, WebSQL was removed from browsers by April 2024. The technology was only ever implemented in Blink-based browsers like Google Chrome and the new Microsoft Edge, and WebKit-based browsers like Safari.
Support
The API is supported by Google Chrome,{{cite web|last=Fette |first=Ian |url=https://blog.chromium.org/2010/01/more-resources-for-developers.html |title=Chromium Blog: More Resources for Developers |publisher=Blog.chromium.org |date=25 January 2010 |access-date=7 September 2013}} Opera,{{cite web|url=http://caniuse.com/sql-storage |title=Can I use Web SQL Database |publisher=Caniuse.com |access-date=7 September 2013}} Microsoft Edge,{{cite web|url=https://learn.microsoft.com/en-us/microsoft-edge/devtools-guide-chromium/storage/websql |title=View Web SQL Data|publisher=learn.microsoft.com |access-date=17 September 2022}} and the Android Browser, albeit support is slowly being phased out.{{cite web|title=Deprecating and removing Web SQL|date=31 August 2022 |url=https://developer.chrome.com/blog/deprecating-web-sql/|publisher=Chrome Developers}} Web SQL was deprecated and removed for third-party contexts in Chromium 97. Web SQL access in insecure contexts is deprecated as of Chrome/Chromium 105 at which time a warning message was shown in the Chrome DevTools Issue panel.{{Cite web |date=2023-10-10 |title=What's New in DevTools (Chrome 119) |url=https://developer.chrome.com/blog/new-in-devtools-119/#web-sql |access-date=2023-10-11 |website=Chrome for Developers |language=en}} The API will be entirely removed from Chrome 124.{{Cite web |last=Ishii |first=Ayu |date=2024-02-28 |title=Intent to Deprecate and Remove Web SQL |url=https://groups.google.com/a/chromium.org/g/blink-dev/c/fWYb6evVA-w/m/_WhKh5v5AQAJ |access-date=2024-02-28 |website=groups.google.com}}
Timeline
In January 2010, Google announced availability of WebSQL Database API in Google Chrome.{{Cite web |last=Fette |first=Ian |title=More Resources for Developers |url=https://blog.chromium.org/2010/01/more-resources-for-developers.html |access-date=2023-09-30 |website=Chromium Blog |language=en}}
Mozilla Corporation developers publicly opposed the technology and at the same were the main proponents behind an 'alternative storage' standard, IndexedDB.{{cite web|title=Why is WebSQL database deprecated?|url=http://programmers.stackexchange.com/questions/220254/why-is-web-sql-database-deprecated|website=Programmers Exchange}}{{cite web|title=Beyond HTML5: Database APIs and the Road to IndexedDB|url=https://hacks.mozilla.org/2010/06/beyond-html5-database-apis-and-the-road-to-indexeddb/|publisher=Mozilla Corporation}} Mozilla argued that ratification of WebSQL as a standard would codify the quirks of SQLite implementation.{{cite web |author-last=O'Callahan |author-first=Robert |date=2010-06-04 |title=Well, I'm Back: Not Implementing Features Is Hard |url=https://robert.ocallahan.org/2010/06/not-implementing-features-is-hard_03.html |archive-url=https://web.archive.org/web/20201109032423/http://robert.ocallahan.org/2010/06/not-implementing-features-is-hard_03.html |archive-date=2020-11-09 |access-date=2011-02-18 |publisher=Weblogs.mozillazine.org}}{{Cite web |author-last=Ranganathan |author-first=Arun |date=2010-06-01 |title=Beyond HTML5: Database APIs and the Road to IndexedDB – Mozilla Hacks - the Web developer blog |url=https://hacks.mozilla.org/2010/06/beyond-html5-database-apis-and-the-road-to-indexeddb |access-date=2021-05-21 |website=Mozilla Hacks – the Web developer blog}}
In November 2010, the W3C Web Applications Working Group ceased working on the specification, citing a lack of independent implementations (i.e. using database system other than SQLite as the backend) as the reason the specification could not move forward to become a W3C Recommendation.
In September 2019, Apple released Safari 13 which removed WebSQL entirely.
In November 2021, Chrome 97 removed WebSQL support in third-party contexts.{{Cite web |title=Chrome Platform Status |url=https://chromestatus.com/feature/5684870116278272 |access-date=2023-09-30 |website=chromestatus.com}}
In February 2023, Chrome 110 removed WebSQL support in insecure contexts but allowed exceptions set with an enterprise policy.
In October 2023, Chrome 119 was shipped with WebSQL disabled in all contexts by default, with an ability to re-enable it until Chrome 123 via a deprecation trial in some contexts.{{Cite web |last=Jara |first=Adriana |date=2023-11-01 |title=New in Chrome 119 |url=https://developer.chrome.com/blog/new-in-chrome-119/ |access-date=2023-11-10 |website=Chrome for Developers |language=en |quote=WebSQL is fully removed as of Chrome 119. A reverse origin trial allows developers to continue to use WebSQL until Chrome 123.}}
In April 2024, Chromium-based browsers, including Chrome 124 and Edge 124 have removed support WebSQL completely.{{Cite web |title=Release notes for Microsoft Edge Stable Channel |url=https://learn.microsoft.com/en-us/deployedge/microsoft-edge-relnote-stable-channel#version-1240247851-april-18-2024 |website=Microsoft Learn |access-date=2024-04-22 |quote=Removal of Web SQL. Web SQL support is completely removed. In prior releases, Web SQL support was disabled by default but could be re-enabled via the WebSQLAccess policy. After this change, there is no longer any mechanism to enable Web SQL support. This change is happening in the Chromium project, on which Microsoft Edge is based. }}
See also
References
{{Reflist}}
External links
- [http://www.w3.org/TR/webdatabase/ W3C Web SQL Database Working Draft]
- [http://www.infoq.com/news/2010/02/Web-SQL-Database Web SQL database] at Info-Q
- [http://caniuse.com/sql-storage SQL storage] at Can-I-Use
{{Web interfaces}}
Category:World Wide Web Consortium standards
{{Web-stub}}