- Like UDP/TCP, this a very interesting API for privileged Web Apps like:
- installed public Web Apps which requested such permissions
- Business Web Apps running on an Intranet (potentially accessed via a VPN)
- installed hybrid apps built via NW.js, Electron, Cordova, NativeScript?, ReactNative?
- Server-Side / End-to-end JavaScript usages (Wakanda, meteor, ...)
- Official argument to have put the recommendation on hold was that "all implementations used SQLite" and "too few implementations", but...
- As long as Web SQL could be used in privileged Web App mode, it would be really more usefull if able to connect to local network available databases
- the fact it started to be deprecated disengaged potential implementors
- The Web SQL API was removed from Web Worker contexts in Blink because "measured usage was very low", but...
- Web Workers were the ideal place to use the Web SQL synchronous API (as SQL connections are occasionally implemented in Wakanda Web Workers)
- a lot of usage is not measurable ("incognito detection" as you said for the Filesystem API) because using Opera Embedded, or "cef" (Chrome Embedded Framework) versions (such as in packaged apps, in set-top-box, ...)
It's not just an opinion but a shared experience both my previous (Wakanda) and my current (Wiztivi) companies
I've been a NoSQL advocate for few years in my previous work but we also still had a lot of use cases in business Web apps for SQL APIs
By the way, Wakanda Server implements the Filesystem API (as well as Web Storage, Dedicates & Shared Workers) natively on the server
And the team was considering to implement:
- the UDP TCP Socket API* (from the System API ex-W3C WG).
- the Web SQL for its default SQL API for network connected databases (adding some connection method)