A web site of no official standing features two JSON formats which might interest readers of this list.
The first is for describing a table of data: <http://dataprotocols.org/json-table-schema/> It does something close to what a CREATE TABLE statement does: define fields, their types, and their constraints. The second is for expressing database changes in a way useful for synchronisation of multiple copies of a table of data across HTTP: <http://dataprotocols.org/sleep/> With a cursory glance I do see important incompatibilities with SQLite. The first of those two pages defines an empty string (a zero-length string) as equivalent to a missing value, whereas SQLite makes a distinction between that and NULL. It then goes on to declare a field type called 'null' for reasons that make no sense to me. Simon.
