Ask HN: Local Tools for Viewing JSON

https://news.ycombinator.com/item?id=30745508

by slickrick216 • 4 years ago

4 10 4 years ago

news.ycombinator.com

Looking for tools to view large varying JSONs. I know I could beautify or flatten them etc but wondering if anyone else has created a tool for this.

arkitaip2• 4 years ago

VS Code has lots of plugins for working with JSON. The only problem is that you have to use VS Code.

ss1082• 4 years ago

What's wrong with VS Code?

arkitaip2• 4 years ago

The UX is mediocre due to their refusal to add GUI elements we've had since the 80s because the product can't be allowed to compete against Visual Studio.

JCWasmx86• 4 years ago

Looks out of place, does not follow the GNOME HIG as opposed to better text editors/IDEs. Furthermore the text rendering looks weird and feels laggy, at least for me another factor is the use of electron and how opaque VSCode is as opposed to e.g. GNOME Builder.

For GNOME-Builder, if I want to debug LSP-issues, I add "--env=JSONRPC_DEBUG=1" to the commandline and I get nice output. For VSCode? - No idea. In the end I redirected strace for writes to a file and then grepped for "Content-Length", because I was frustrated that there was no straightforward way to do this otherwise.

Another issue I have with VSCode is, that it adds some folders to the project, that's something I absolutely can't stand.

slickrick216• 4 years ago

Thanks, Yeah I’ve tried VSCode and Sublime. Like you said they aren’t bad. Might need to check out more plugins.

armchairhacker• 4 years ago

jq (command-line app)

or you could write a small javascript and run it via node

Honestly it’s hard to beat text formats for viewing JSON unless you have particular queries. There’s just a lot of data no matter which way you try to represent it

luckman212• 4 years ago

In addition to jq (already mentioned) here are some other useful CLI tools for dealing with JSON data. Descriptions are directly from GitHub. Note: dsq also has a companion GUI app called DataStation[0] if you're looking for that.

fx: Command-line JSON processing tool - https://github.com/antonmedv/fx

dasel: JSON, YAML, TOML, XML, and CSV query and modification tool - https://github.com/TomWright/dasel

dsq: CLI tool for running SQL queries against JSON, CSV, Excel, Parquet, and more - https://github.com/multiprocessio/dsq

gron: Make JSON greppable - https://github.com/tomnomnom/gron

jello: Filter JSON and JSON Lines data with Python syntax - https://github.com/kellyjonbrazil/jello

jless: Command-line pager for JSON data - https://github.com/PaulJuliusMartinez/jless

jid: Json incremental digger - https://github.com/simeji/jid

jql: JSON query language CLI tool - https://github.com/yamafaktory/jql

qp: Command-line (ND)JSON querying - https://github.com/paybase/qp

[0] https://github.com/multiprocessio/datastation

leonim• 4 years ago

I would add VisiData to that list. It is more suited for tabular data, but it can be used to explore large nested data. I find it is a good starting place to explore json data I'm not familiar with. I will also sometimes flatten the data with some general jq scripts or gron.

If I'm trying to understand some new json data, I start with visidata, and then I poke around to find the data I want. If it is data I want to extract again, I use jq to get the interesting bits. Sometimes I use that in combination with sqlite-utils to store that data so I can query it. (I haven't tried some of the other tools that will create a sqlite database for you.)

- https://github.com/saulpw/visidata - https://github.com/simonw/sqlite-utils

Ask HN: Local Tools for Viewing JSON

Related Stories