3 ms·
I'm a big fan of sqlite and would have loved to see WebSQL succeed, but I think HTML adopting the de-facto behaviour of sqlite is "bananas" - it would be the eq
by tannhaeuser 10y ago
I'm a big fan of sqlite and would have loved to see WebSQL succeed, but I think HTML adopting the de-facto behaviour of sqlite is "bananas" - it would be the equivalent of "formatLikeWord95" of the OOXML spec. They should have defined a proper ISO SQL subset/profile instead.
What remains of WebSQL is the commonly implemented SQL client driver API for Node.js which isn't so good a fit IMHO.
- mschuster91 10y ago> They should have defined a proper ISO SQL subset/profile instead. That wouldn't have helped. Google Chrome (and, by extension, Safari and Opera) and Firefox would just use the already present SQLite library in the engine... and I think MS would also have chosen SQLite instead of risking to develop a full SQL database (and opening a rich source of bugs and security issues, in contrast with using battle-tested SQLite). Again, just one implementation of the standard.
- tannhaeuser 10y agoOr, MS would have blessed us with their Access/JET DB.
- mschuster91 10y agoWell if MS could build a safe interface to Access (also managing translation from ISO SQL to Access SQL!), I'd be perfectly fine with it! I've seen people building really nice stuff based on it, a pity it's only available on "higher end" Office variants and even there only on Windows :(
- dragonwriter 10y agoMicrosoft has several embedded DB engines of their own (not Free, but they already own them), so I don't know that they would have used SQLite.