On 2015-09-11 9:31 AM, Richard Hipp wrote: > On 9/11/15, Petite Abeille <petite.abeille at gmail.com> wrote: >> serialization of the week > > The json.org website has been up since 2002. JSON itself predates > that. It is roughly the same age as SQLite itself and is older than > SQLite3. I'm thinking that maybe JSON is not just a passing fad. > Could be wrong though.....
True, I have known for years that JSON has effectively become the new XML, one that is less verbose but evenly flexible. Referring to the spec itself, storing the JSON as a character string is always a safe bet; having a future binary option is good, but AFAIK the primary benefit to it is faster indexing/processing speed, and not so much space; see also the (BSD-licensed) Postgres 9.4+ and its JSONB data type for prior art with a binary storage of JSON that is backwards-compatible, though its indexability is one of its key features. -- Darren Duncan
