3 ms·
> A bit off topic, but would be great to use SQLite in the browser instead of IndexedDB That almost happened. There was a thing called WebSQL [1] that was W3C
by tzs 8y ago
> A bit off topic, but would be great to use SQLite in the browser instead of IndexedDB
That almost happened. There was a thing called WebSQL [1] that was W3C was working on to add SQL to the browser. Everyone who implemented it used SQLite.
Apparently, that disqualified it from standardization. To move ahead, they wanted to see independent implementations of the standard.
No browser makers stepped up to reduce the quality of their implementation by replacing some of the best designed, best written, best tested code on the planet with some other SQL back end to satisfy the committee, and so Mozilla was able to push IndexedDB as the standard browser DB interface.
[1] https://en.wikipedia.org/wiki/Web_SQL_Database https://en.wikipedia.org/wiki/Web_SQL_Database
- dragonwriter 8y ago> Everyone who implemented it used SQLite They had to, since what was standardized was specifically the SQL dialect of SQLite v3.6.19. > No browser makers stepped up to reduce the quality of their implementation by replacing some of the best designed, best written, best tested code on the planet with some other SQL back end to satisfy the committee There were only two implementations at all: WebKit and Opera. Mozilla and Microsoft weren't going to implement it without a spec decoupled from particular backend.