JSON

About JSON

• The Devil is in the JSON Details · The Factotum
• seriot.ch - Parsing JSON is a Minefield 💣

Fast JSON parsers

• Mison: A Fast JSON Parser for Data Analytics - Microsoft Research – not open source as far as I can tell… :(

• lemire/simdjson: Parsing gigabytes of JSON per second ; “single header file” library. Feb 2019.

Query Tools

First see jq.

• ObjectPath - The agile query language

In weather readings find cities where temperature is higher than 25°C and the sky is clear.

$..*[@..temp > 25 and @.clouds.all is 0].name

• Gron – “Make JSON greppable”

▶ gron "https://api.github.com/repos/tomnomnom/gron/commits?per_page=1" | fgrep "commit.author"
json[0].commit.author = {};
json[0].commit.author.date = "2016-07-02T10:51:21Z";
json[0].commit.author.email = "mail@tomnomnom.com";
json[0].commit.author.name = "Tom Hudson";

antonmedv/fx: Command-line tool and terminal JSON viewer 🔥

2020-06-01: glomRestructuring data, the Python way.

from glom import glom

target = {'a': {'b': {'c': 'd'}}}
glom(target, 'a.b.c')  # returns 'd'

Charting tools

• sgreben/jp: dead simple terminal plots from JSON data. single binary, no dependencies. linux, osx, windows.

JSON Templating

• Jsonnet - The Data Templating Language
• The Dhall configuration language. Dhall = JSON + functions + types + imports
• Starlark Language - Bazel
  • google/starlark-go: Starlark in Go: the Starlark configuration language, implemented in Go
  • bazelbuild/starlark: Starlark Language

JSON Schema

• JSON Resume

See also: BBEdit JSON format