Show HN: JSON Query: A tool to query JSON data structures(satishmaha.com)

41 pointsby aggregator-ios12년 전14 comments

Show HN: JSON Query: A tool to query JSON data structures

http://satishmaha.com/JSONQuery/

7 comments

For those that prefer a command line tool, jq has been around for a while and works very well. I can't count how many times jq let me hack together a bunch of commands I normally would have had to write a small program for. e.g small script that pushes the latest semver tag from a github repo to a geckoboard text widget: https://gist.github.com/jdc0589/67df901f71d96b7649b4

http://stedolan.github.io/jq/

CyberShadow12년 전

Is this a GUI for jq?

hendry12년 전

The video looks like you are combining keys?

You could just do this with http://jsonunroller.appspot.com/ and grep.

tuananh12년 전

or you could do it with `curl`, output it to sublime and type `json pretty` (json plugin installed) :)

LaSombra12년 전

Why such tools are more common on OS X?

geonik12년 전

XPath for JSON? Who would have thought of that! Now add namespaces and you reinvented XML 10 years later

oneeyedpigeon12년 전

Except that, with certain caveats, XML has a slightly nicer syntax for text-heavy documents, and JSON is slightly nicer for hardcore data representation. For example, I'd much rather have a web page in HTML than JSON, but I'd rather have a config file in the latter.

thechao12년 전

There is a fairly straightforward generalization of the 'axis' concept to allow graph traversal: 'GPath'. (You have to add an annotation for a traversal kind, and an identifier for a property map.) XPath can be straightforwardly desugared to GPath. I implemented this years ago for an EDG IPR[1] back-end, hooked up a number of 'standard queries' over C++ to Todd Veldhuizen's live OpenGL force-directed graph-viewer [2], and watched EDG compile code---pretty wild stuff watching expressions 'bloom', and classes 'become referenced', etc.

[1] https://parasol.tamu.edu/pivot/ [2] http://ubietylab.net

conorgdaly12년 전

Probably most people would have thought of it.

You wouldn't make that same comparison with regular expressions(tool) and a text document(data) would you? As in, the tool is not part and parcel of the data.

XPath(and JSONPath) are powerful tools for programatically pulling data from complex data structures.

eCa12년 전

http://goessner.net/articles/JsonPath/

emmelaich12년 전

How about Xpath for every configuration file?

    http://augeas.net/

jeffehobbs12년 전

Cool tool, nice work!

rnl12년 전

This changes everything. Good job

afandian12년 전

How? jq is already very usable.

https://stedolan.github.io/jq/