#Postgres extended #SQL with infix operators for #JSON
on 02026-05-27“Make #JSON greppable! "gron" transforms JSON into discrete assignments to make it easier to grep for what you want and see the absolute ‘path’ to it.”
on 02025-07-21Reformats #JSON automatically, with expand and collapse and translation to CSV, plus a minify option
on 02024-09-05"Visidata" is a spreadsheety GPL3 data visualization #TUI program that looks pretty impressive. #infovis in #Python, supporting #TSV, #JSON, #CSV, #SQLite, #Pandas, and #HDF5
on 02024-09-03#JSON Patch is a format from RFC 6902 for describing changes to JSON structures, using JSON Pointer from RFC 6901
on 02023-06-17#algorithm #performance for #parsing #JSON: 7.4 GB/s to look for tweets by a particular person, for example, 12 GB/s for minification by removing whitespace, or 3.6 GB/s to produce a full in-memory DOM tree. Apparently #AVX-512 actually does improve performance now.
on 02022-05-26lmorchard tells the story of #delicious and its tags and #JSON (an important turning point in JSON #history really)
on 02019-02-05Command-line tools for newline-delimited #JSON: cat, filter, map, reduce, split, join, sort, top.
on 02017-08-27Streaming variants of #JSON, including ndjson.
on 02017-04-29newline-delimited #JSON #format for streaming processing of JSON.
on 02017-04-29The jq command runs queries on #JSON streams; it has its own expression language, for which this is the #tutorial.
on 02016-06-26HN commentary on jq, a #JSON processor on the command line.
on 02015-08-10