sqlite

What if the SQLite community takes SQLite in a direction that isn't optimal for web browsers?

It's not likely they'd pick an existing SQL dialect that's compatible with SQLite, or they'd be essentially limited to that version of SQLite.

More succinctly: SQLite version whatever is specified only by its C source code, and C is woefully underspecified.

Similarly, would you use a sqlite file for a plaintext document (like c++) or a binary executable?

Mozilla is rather clear that they don't want to spec on a specific version of SQLite.

SQLite is public domain, any browser vendor can choose to embed it in what they ship.

Great, write up convinced me to use Sqlite instead of Mysql for a simple in-house webpage.

If you don't want to just use Sqlite (understandable), and you don't want to write something that is as good as Sqlite (also understandable), then you're going to have a crap database implementation.

And no, Mozilla probably didn't have the resources to implement SQLite from scratch, but: 1.

About WebSQL Firefox already had (and still has) Sqlite dependency (it is uses for bookmarks, history,...) it is not the issue.

If you need to use SQLite with python, apsw actually converts errors to discrete exceptions.

For example, could you imagine trying to encode a video file in a sqlite database?

The problem is that the Web SQL standard states "User agents must implement the SQL dialect supported by Sqlite 3.6.19." [0] which made agents rely on a outdated dependency and non standard (sqlite is not SQL ansible compatible) SQL.

It's clear in the email thread that the "spec" world just be codifying exactly what that version of SQLite did.

Great part from the docs: "SQLite does not compete with client/server databases.

In particular, the rule about needing two seperate implementations is good, but it could have been fudged here; a bigger problem was the lack of a spec beyond "whatever Sqlite does".

Did Mozilla have the resources to clearly specify how a reference implementation should work, even if the only actual implementation remained Sqlite?