2 ms·
And WebSQL: We have the fabulous SQLite as API in HTML 5, yet Mozilla and Microsoft refuse to support it! http://en.wikipedia.org/wiki/WebSQL http://en.wikipe
by frik 12y ago
And WebSQL:
We have the fabulous SQLite as API in HTML 5, yet Mozilla and Microsoft refuse to support it!
http://en.wikipedia.org/wiki/WebSQL http://en.wikipedia.org/wiki/WebSQL (supported by Google Chrome, Opera, Safari and the Android Browser; Firefox ships with SQLite but doesn't expose the API)
WebSQL is not deprecated, the W3C Working Group Note says:
'This specification is no longer in active maintenance
and the Web Applications Working Group does not intend to
maintain it further'.
Recently, we had a discussion about that: https://news.ycombinator.com/item?id=7645726 https://news.ycombinator.com/item?id=7645726
- TazeTSchnitzel 12y agoIt's not deprecated, no, it's something worse. It is abandoned! If you want SQLite use sql.js
- frik 12y agosql.js is 2 MB big (https://github.com/kripken/sql.js/blob/master/js/sql.js https://github.com/kripken/sql.js/blob/master/js/sql.js ) And it's an in-memory database, not like WebSQL. So one has to store the data (array) to localStorage or rather IndexedDB (HTML 5 NoSQL storage). https://github.com/kripken/sql.js/wiki/Persisting-a-Modified-Database https://github.com/kripken/sql.js/wiki/Persisting-a-Modified... So imagine a Firefox user: He has to download an extra 2MB JS file, the huge file has to be run through asm.js JIT and the data is (for example) stored (offline mode) using IndexedDB. Firefox implements IndexedDB on top of SQLite. A SQLite instance runs on top of an NoSQL engine on top of another SQLite instance - wtf!?