#1 question is whether these have momentum and/or a future. Maybe that’s just my ignorance, but I can’t find any operators for diving into the document structure other than basically walking the JSON document tree manually. MongoDB‘s JSON query language is surprisingly limited for a system that’s all about searching JSON documents. I don’t think I’d load data into Postgres just for JSON queries, but if you have JSON there already it’s pretty powerful. And the JSONB type has a few extra query options. It also has functions for converting JSON to Postgres’ array and recordset types, which you can then further query. It has native support for JSON types and a pretty decent set of functions for working with it.
The author is someone I trust to think a tool like this through. It looks good and simple for doing simple things. Jsonfilter is a very simple grep-like tool that works with hierarchical input. It’s a streaming JSON parser but also has an XPath-like language for pulling out chunks of a document. There’s also been some work on a usable libjq so you can use it inside other languages, like these Python bindings. But it’s definitely the tool to compare everything else to.
I also find it really terse and confusing but maybe that’s because I don’t use it enough.
It’s the most popular JSON query language, and quite powerful. A key thing here is being able to do stuff like “find me the parts of this JSON document that have a property foo with value bar”. Also dealing with arrays intelligently. Kind of like regular expressions or XPath or CSS Selectors. I’m looking for small data extraction languages that make it very easy to extract bits of data from a bunch of JSON blobs. Following up on an earlier post, a roundup of some systems for querying JSON documents.
0 kommentar(er)
