Hacker News new | ask | show | jobs
by reed1 636 days ago
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

3 comments

+1 for fx, it's absolutely awesome. https://fx.wtf/
A great tool that fills the gap of lacking a preview feature in the terminal with jq. However, for data processing, I think jq's DSL is more concise and user-friendly.
fx looks a lot like jless: https://jless.io/