I never understand why WebSQL was replaced by IndexedDB, it was so much faster! Sure different implementations and all, Sqlite vulnerability and what not arguments! And still I see exploits every year on IndexedDB every year, the only thing that changed is it's slower!
* No two SQL implementations have the same dialect
* There is no publicly available specification
* The people in charge of the non-free specification have demonstrated no desire to:
* Make the spec public and freely available
* Remove (or make mandatory) any optional features
* Update the spec to match the real world, unify discrepancies, and require conformance to that spec
* Following the above, existing commercial vendors have no desire to create a unified specification that covers, presumably as that would ease transition between DBs?
The core problem was that existing websql implementations were just shipping wrappers around sqlite. That meant no one could create an implementation without first doing a blackbox rewrite of sqlite, and would just have to hope they hadn't messed up anywhere.