I see that Postgres also has a binary JSON format, and also is called JSONB (<a href="https://www.postgresql.org/docs/current/datatype-json.html" rel="nofollow noreferrer">https://www.postgresql.org/docs/current/datatype-json.html</a>), although I don't see any specification for the details. I supposed these are unrelated. Too bad people couldn't agree on a standard.<p>I realize in these cases, it's mainly for internal DB use, it would seem useful to have a widely use standard. (I'm aware there are many other attempts like BSON, etc).
This is very exciting! The pace of sqlite development is suprisingly fast for a project that mature.<p>The only real type that I miss from SQLite is a native datetime. Currently each library uses a different parsing strategy and it's a mess. I fixed the diesel (rust) implementation recently and boy was that not fun.
This is actually very nice! It exposes all of the awkward areas of JSON without trying to paper over any of them, while still achieving its goals. In particular it doesn't try to define any kind of an equivalence over JSON objects outside trivial syntactic equivalence.