Web SQL Database explained

Web SQL Database is a deprecated web browser API specification for storing data in databases that can be queried using SQL variant.[1] [2] The technology was only ever implemented in Blink-based browsers like Google Chrome and the new Microsoft Edge, and WebKit-based browsers like Safari., WebSQL is being phased out in favor of WebStorage and IndexedDB and OPFS, but still available in some contexts under restrictive conditions.

Support

The API is supported by Google Chrome,[3] Opera,[4] Microsoft Edge,[5] and the Android Browser, albeit support is slowly being phased out.[6] 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.[7] The API will be entirely removed from Chrome 124.[8]

Timeline

In January 2010, Google announced availability of WebSQL Database API in Google Chrome.[9]

Mozilla Corporation developers publicly opposed the technology and at the same were the main proponents behind an 'alternative storage' standard, IndexedDB.[10] [11] Mozilla argued that ratification of WebSQL as a standard would codify the quirks of SQLite implementation.[12] [13]

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.[14]

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.[15]

In April 2024, Chromium-based browsers, including Chrome 124 and Edge 124 have removed support WebSQL completely.[16]

See also

External links

Notes and References

  1. Web site: Web SQL Database (W3C Working Group Note). W3.org . 25 October 2011.
  2. Nelson, Anne Fulcher, and Nelson, William Harris Morehead. (2001). Building Electronic Commerce with Web Database Constructions. Boston, MA: Addison Wesley.
  3. Web site: Fette . Ian . Chromium Blog: More Resources for Developers . Blog.chromium.org . 25 January 2010 . 7 September 2013.
  4. Web site: Can I use Web SQL Database . Caniuse.com . 7 September 2013.
  5. Web site: View Web SQL Data. learn.microsoft.com . 17 September 2022.
  6. Web site: Deprecating and removing Web SQL. 31 August 2022 . Chrome Developers.
  7. Web site: 2023-10-10 . What's New in DevTools (Chrome 119) . 2023-10-11 . Chrome for Developers . en.
  8. Web site: Ishii . Ayu . 2024-02-28 . Intent to Deprecate and Remove Web SQL . 2024-02-28 . groups.google.com.
  9. Web site: Fette . Ian . More Resources for Developers . 2023-09-30 . Chromium Blog . en.
  10. Web site: Why is WebSQL database deprecated?. Programmers Exchange.
  11. Web site: Beyond HTML5: Database APIs and the Road to IndexedDB. Mozilla Corporation.
  12. Web site: O'Callahan . Robert . 2010-06-04 . Well, I'm Back: Not Implementing Features Is Hard . https://web.archive.org/web/20201109032423/http://robert.ocallahan.org/2010/06/not-implementing-features-is-hard_03.html . 2020-11-09 . 2011-02-18 . Weblogs.mozillazine.org.
  13. Web site: Ranganathan . Arun . 2010-06-01 . Beyond HTML5: Database APIs and the Road to IndexedDB – Mozilla Hacks - the Web developer blog . 2021-05-21 . Mozilla Hacks – the Web developer blog.
  14. Web site: Chrome Platform Status . 2023-09-30 . chromestatus.com.
  15. Web site: Jara . Adriana . 2023-11-01 . New in Chrome 119 . 2023-11-10 . Chrome for Developers . en . WebSQL is fully removed as of Chrome 119. A reverse origin trial allows developers to continue to use WebSQL until Chrome 123..
  16. Web site: Release notes for Microsoft Edge Stable Channel . Microsoft Learn . 2024-04-22 . 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. .

This article is licensed under the GNU Free Documentation License. It uses material from the Wikipedia article "Web SQL Database".

Except where otherwise indicated, Everything.Explained.Today is © Copyright 2009-2024, A B Cryer, All Rights Reserved. Cookie policy.