4 ms·
Except they made the right choice with WebSQL. Exposing and securing the entire api surface of sqlite -- from sql syntax to binary compatibility to behavior-alt
by infogulch 4y ago
Except they made the right choice with WebSQL. Exposing and securing the entire api surface of sqlite -- from sql syntax to binary compatibility to behavior-altering pragmas -- would have been a compatibility and security nightmare that would make xkcd 1172 look tame by comparison. Exposing a block device instead [1] and layering user-provided sqlite on top of it via WASM [2] is infinitely better than rushing to lock ourselves into a roller coaster that runs straight through the worst compatibility minefield the web has ever seen.
[1]: https://news.ycombinator.com/item?id=35165640 https://news.ycombinator.com/item?id=35165640 "Firefox 111.0 enabled Origin private file system access"
[2]: https://news.ycombinator.com/item?id=33374402 https://news.ycombinator.com/item?id=33374402 "SQLite in the browser with WASM/JS"