About JSON
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 = "[email protected]";
json[0].commit.author.name = "Tom Hudson";
fastgron transforms JSON into discrete assignments to make it easier to grep for what you want and see the absolute ‘path’ to it. It eases the exploration of APIs that return large blobs of JSON but have terrible documentation.
fastgron is a high-performance JSON to GRON converter, developed in C++20, utilizing simdjson library. It’s 50x faster than gron on big files (400MB/s input / 1.8GB/s output on M1 Macbook Pro), so it makes big JSON files greppable.
antonmedv/fx: Command-line tool and terminal JSON viewer 🔥
glomRestructuring data, the Python way.
from glom import glom
target = {'a': {'b': {'c': 'd'}}}
glom(target, 'a.b.c') # returns 'd'Charting tools
JSON Templating
- Jsonnet - The Data Templating Language
- The Dhall configuration language. Dhall = JSON + functions + types + imports
- Starlark Language - Bazel
JSON Schema
JSON-LD
Being on The Semantic Web is easy, and, frankly, well worth the bother JSON-LD = (JSON “for Linked Data”) is the leading format for encoding Sematic Web metadata. It’s just JSON, really. There are schemas that lay out the “types” you can use to describe the stuff on your page.
JSON Databases
Softmotions/ejdb: EJDB2 — Embeddable JSON Database engine C library. Simple XPath like query language (JQL). Websockets / Android / iOS / React Native / Flutter / Java / Dart / Node.js bindings.
EJDB query language (JQL) syntax inspired by ideas behind XPath and Unix shell pipes. It designed for easy querying and updating sets of JSON documents. See ejdb.
See also: BBEdit JSON format