HN user

reed1

10 karma
Posts0
Comments13
View on HN
No posts found.

Everyone here mentions jq but no one mentions "fx". It's an awesome cli app to browse json. It can modify json too, but I think jq has shorter DSL. If you want to browse or navigate through nested json, this is the best tool I know.

I wouldn't use GUI for this simply because piping data and mouseless env are more convenient to me. These are my other use cases:

- validation & auto fixing: fix-busted-json (python)

- tabular view : visidata (vd) can do this directly on json files. it has tons of other features like histogram, charts, sort, filter, edit, etc

- summarizing and querying: duckdb. Example: select sum(price), count(*) from 'orders.json'

- conversion: json2csv, it works both way

- diff: simply diff, but sometimes jq for ordering keys is required

Htop 3.0 6 years ago

sorry for being ignorant to learn myself, but how do I do this?

Compare that with creating a table right from csv file (using fdw) in postgres without importing data. Very neat