On: JSONB has landed

[Animats]

Is this just a data type, or did SQLite put in a JSON interpreter?

[lifthrasiir → Animats]

What do you mean by a JSON interpreter? I think SQLite already has a full implementation of JSON including tree walkers, and this internal format (that is externally just another BLOB) makes them more efficient.

[Animats → lifthrasiir]

Oh, sorry, I was thinking that someone had put a Javascript interpreter in the database itself. Fortunately, no.

[mariusor → Animats]

Despite the name, the JSON format doesn't really have much to do with JavaScript.

[sureglymop → Animats]

Pretty sure SQLite comes with a JSON parser. JSON is a very simple format for which it is easy to write a parser for...

[HDThoreaun → Animats]

You mean a JSON parser? I don't think you can execute anything with json.

[justinclift → Animats]

SQLite has had pretty decent support for JSON for a while now:

https://sqlite.org/json1.html

[cryptonector → Animats]

It's a BLOB with a binary representation of JSON.