Tool For Querying Json Files Mac

Posted on  by 

  1. Tool For Query Json Files Mac
  2. Json Editor Mac
  3. How To Change Minecraft Json Files Mac
  4. Json Tools Online

Home > Apps > Apple macOS / Mac OS X
File extension list filtered by software name

  • I know that jSON can be stand alone and there may be +/- for having a querying language but I cannot see the advantage if you are retrieving data from the backend to a browser, as most of the JSON use cases.
  • JSON (JavaScript Object Notation) is an open text format consisting of attribute–value pairs. Although JSON is derived from the JavaScript scripting language, it is a language-independent data format.

Visual JSON for Mac

Found one file extension association related to Visual JSON for Mac and 1 file format developed specifically for use with Visual JSON for Mac.

Platform, operating system:Apple macOS / Mac OS X

Jqui is a OS X user interface for the jq JSON query tool. It provides a query box, JSON input box, and then the output of the query. In order to develop jqui, you'll need XCode 6.4 installed. JSON Query is a free and easy to use application that allows you to query a JSON data structure. Use the simple search syntax. JSON Query is a free and.allows you to query a JSON data structure. Connecting Excel 2016 with JSON data is easy. Using Get & Transform (formerly PowerQuery) allows you to write a query to create a table from your JSON data. Installing Drill on Linux and Mac OS X; Starting Drill on Linux and Mac OS X; Installing Drill on Windows. Querying JSON Files; Querying Parquet Files; Querying Plain Text Files; Querying Directories. ← Querying HBase Querying Complex Data Introduction.

Go to: Visual JSON for Mac description

Developer:YunWon Jeong

Bookmark & share this page with others:

Visual JSON for Mac

Developer / company: YunWon Jeong

Visual JSON is a simple and very easy to use JSON visualization tool for JSON API server/client developers. Using the Visual JSON utility one can access remote or local address to JSON server and refresh its result with a click. Or just paste raw JSON value. You also can test POST method using simple http query expressions.

Visual JSON for Mac icon


Visual JSON for Mac icon
size: 128px x 128px (.png with transparency)

Visual JSON for Mac works with the following file extensions:

Note: You can click on any file extension link from the list below, to view its detailed information. The list of extensions used or otherwise associated with the application may not be complete, because many common file extensions on our website, such as jpg (pictures) or txt (text files), can be opened by a large number of applications, or are too general file format. However most, if not all directly associated file extensions should be listed with its appropriate program. Although its likely, that some file extensions may be missing from the list of associated file extensions with the application, yet they can be opened, be part of, or otherwise be associated with the program.

Visual JSON for Mac default file extension associations

The most common file format used with the specific file extension

.json file extension is used for JavaScript object notation data interchange format

Common file extensions used by Visual JSON for Mac

.json

Comparison table of actions that Visual JSON for Mac can perform with its associated file type beta

This table might not contain all possible associated or supported file types or may contain incorrect data.
If you need more information please contact the developers of Visual JSON for Mac (YunWon Jeong), or check out their product website.

File type Action

Open

Save

Edit

View

Play

Convert

Create

Record

Import

Export

Burn

Extract

Recover

Backup

Print

Settings

Other

YesYesYes---Yes----------
Active2 months ago

Is there a (roughly) SQL or XQuery-like language for querying JSON?

I'm thinking of very small datasets that map nicely to JSON where it would be nice to easily answer queries such as 'what are all the values of X where Y > 3' or to do the usual SUM / COUNT type operations.

As completely made-up example, something like this:

I'm thinking this would work both client-side and server-side with results being converted to the appropriate language-specific data structure (or perhaps kept as JSON)

A quick Googling suggests that people have thought about it and implemented a few things (JAQL), but it doesn't seem like a standard usage or set of libraries has emerged yet. While each function is fairly trivial to implement on its own, if someone has already done it right I don't want to re-invent the wheel.

Any suggestions?

Edit: This may indeed be a bad idea or JSON may be too generic a format for what I'm thinking.. The reason for wanting a query language instead of just doing the summing/etc functions directly as needed is that I hope to build the queries dynamically based on user-input. Kinda like the argument that 'we don't need SQL, we can just write the functions we need'. Eventually that either gets out of hand or you end up writing your own version of SQL as you push it further and further. (Okay, I know that is a bit of a silly argument, but you get the idea..)

serv-inc
18.6k5 gold badges90 silver badges97 bronze badges
allclawsallclaws
2,7596 gold badges26 silver badges27 bronze badges

21 Answers

Sure, how about:

  • JsonPath.

They all seem to be a bit work in progress, but work to some degree. They are also similar to XPath and XQuery conceptually; even though XML and JSON have different conceptual models (hierarchic vs object/struct).

Tool For Querying Json Files Mac

EDIT Sep-2015: Actually there is now JSON Pointer standard that allows very simple and efficient traversal of JSON content. It is not only formally specified, but also supported by many JSON libraries. So I would call it actual real useful standard, although due to its limited expressiveness it may or may not be considered Query Language per se.

StaxManStaxMan
86.9k27 gold badges172 silver badges211 bronze badges

I'd recommend my project I'm working on called jLinq. I'm looking for feedback so I'd be interested in hearing what you think.

If lets you write queries similar to how you would in LINQ...

It's fully extensible too!

The documentation is still in progress, but you can still try it online.

dkretz
33.5k13 gold badges73 silver badges130 bronze badges
HugowareHugoware
21.2k23 gold badges55 silver badges69 bronze badges

Update: XQuery 3.1 can query either XML or JSON - or both together. And XPath 3.1 can too.

The list is growing:

  • JSONiq (based on XQuery)
  • UNQL (like SQL)
  • JaQL (functional)
  • JsonPath (XPath-like)
  • Json Query (sort of XPath-like)
  • GraphQL (template-based, typed)
JonathanJonathan

jmespath works really quite easy and well, http://jmespath.org/It is being used by Amazon in the AWS command line interface, so it´s got to be quite stable.

xorxor

The built-in array.filter() method makes most of these so-called javascript query libraries obsolete

You can put as many conditions inside the delegate as you can imagine: simple comparison, startsWith, etc. I haven't tested but you could probably nest filters too for querying inner collections.

forivall
6,6671 gold badge25 silver badges52 bronze badges
RogerRoger

Tool For Query Json Files Mac

ObjectPath is simple and ligthweigth query language for JSON documents of complex or unknown structure. It's similar to XPath or JSONPath, but much more powerful thanks to embedded arithmetic calculations, comparison mechanisms and built-in functions.

Python version is mature and used in production. JS is still in beta.

Probably in the near future we will provide a full-fledged Javascript version. We also want to develop it further, so that it could serve as a simpler alternative to Mongo queries.

Ela BednarekEla Bednarek

jq is a JSON query language, mainly intended for the command-line but with bindings to a wide range of programming languages (Java, node.js, php, ...) and even available in the browser via jq-web.

Here are some illustrations based on the original question, which gave this JSON as an example:

SUM(X) WHERE Y > 0 (would equate to 7)

LIST(X) WHERE Y > 0 (would equate to [3,4])

jq syntax extends JSON syntax

Every JSON expression is a valid jq expression, and expressions such as [1, (1+1)] and {'a': (1+1)}` illustrate how jq extends JSON syntax.

A more useful example is the jq expression:

which, given the JSON value {'a':1, 'b':2, 'c': 3}, evaluates to {'a':1, 'b':2}.

peakpeak
41.1k10 gold badges54 silver badges69 bronze badges

If you are using .NET then Json.NET supports LINQ queries over the top of JSON. This post has some examples. It supports filtering, mapping, grouping, etc.

James Newton-KingJames Newton-King
32.5k20 gold badges98 silver badges120 bronze badges

Another way to look at this would be to use mongoDB You can store your JSON in mongo and then query it via the mongodb query syntax.

forivall
6,6671 gold badge25 silver badges52 bronze badges
Alexx RocheAlexx Roche
Mac

OK, this post is a little old, but... if you want to do SQL-like query in native JSON (or JS objects) on JS objects, take a look at https://github.com/deitch/searchjs

It is both a jsql language written entirely in JSON, and a reference implementation. You can say, 'I want to find all object in an array that have name'John' && age25 as:

The reference implementation searchjs works in the browser as well as as a node npm package

It can also do things like complex joins and negation (NOT). It natively ignores case.

It doesn't yet do summation or count, but it is probably easier to do those outside.

deitchdeitchTool For Querying Json Files Mac
7,1557 gold badges47 silver badges74 bronze badges

Here's some simple javascript libraries that will also do the trick:

  • Dollar Q is a nice lightweight library. It has a familiar feel to the chaining syntax made popular by jQuery and is only 373 SLOC.
  • SpahQL is a fully featured query language with a syntax similar to XPath (Homepage, Github
  • jFunk is an in progress query language, with a syntax similar to CSS/jQuery selectors. It looked promising, but hasn't had any development beyond its in initial commit.

  • (added 2014): the jq command line tool has a neat syntax, but unfortunately it is a c library. Example usage:

    < package.json jq '.dependencies | to_entries | .[] | select(.value | startswith('git')) | .key'

forivallforivall
6,6671 gold badge25 silver badges52 bronze badges

In MongoDB, this is how it would work (in the mongo shell, there exist drivers for a language of your choice).

The first three commands insert the data into your collection. (Just start the mongod server and connect with the mongo client.)

The next two process the data. $match filters, $group applies the sum and list, respectively.

serv-incserv-inc
18.6k5 gold badges90 silver badges97 bronze badges

SpahQL is the most promising and well thought out of these, as far as I can tell. I highly recommend checking it out.

DavidDavid


I've just finished a releaseable version of a clientside JS-lib (defiant.js) that does what you're looking for. With defiant.js, you can query a JSON structure with the XPath expressions you're familiar with (no new syntax expressions as in JSONPath).

Example of how it works (see it in browser here http://defiantjs.com/defiant.js/demo/sum.avg.htm):

As you can see, DefiantJS extends the global object JSON with a search function and the returned array is delivered with aggregate functions. DefiantJS contains a few other functionalities but those are out of the scope for this subject.Anywho, you can test the lib with a clientside XPath Evaluator. I think people not familiar with XPath will find this evaluator useful.
http://defiantjs.com/#xpath_evaluator

More information about defiant.js
http://defiantjs.com/
https://github.com/hbi99/defiant.js

I hope you find it useful...Regards

Hakan BilginHakan Bilgin
  1. Google has a project called lovefield; just found out about it, and it looks interesting, though it is more involved than just dropping in underscore or lodash.

Lovefield is a relational query engine written in pure JavaScript. It also provides help with persisting data on the browser side, e.g. using IndexedDB to store data locally. It provides SQL-like syntax and works cross-browser (currently supporting Chrome 37+, Firefox 31+, IE 10+, and Safari 5.1+...

  1. Another interesting recent entry in this space called jinqJs.

    Briefly reviewing the examples, it looks promising, and the API document appears to be well written.

jinqJs is a small, simple, lightweight and extensible javaScript library that has no dependencies. jinqJs provides a simple way to perform SQL like queries on javaScript arrays, collections and web services that return a JSON response. jinqJs is similar to Microsoft's Lambda expression for .Net, and it provides similar capabilities to query collections using a SQL like syntax and predicate functionality. jinqJs’s purpose is to provide a SQL like experience to programmers familiar with LINQ queries.

mg1075mg1075
15.5k7 gold badges49 silver badges91 bronze badges

I'll second the notion of just using your own javascript, but for something a bit more sophisticated you might look at dojo data. Haven't used it but it looks like it gives you roughly the kind of query interface you're looking for.

user65663

The current Jaql implementation targets large data processing using a Hadoop cluster, so it might be more than you need. However, it runs easily without a Hadoop cluster (but still requires the Hadoop code and its dependencies to get compiled, which are mostly included). A small implementation of Jaql that could be embedded in Javascript and the a browser would be a great addition to the project.

Your examples above are easily written in jaql:

Of course, there's much more too. For example:

Jaql can be downloaded/discussed at http://code.google.com/p/jaql/

You can also use Underscore.js which is basically a swiss-knife library to manipulate collections. Using _.filter, _.pluck, _.reduce you can do SQL-like queries.

Underscore.js works both client-side and server-side and is a notable library.

You can also use Lo-Dash which is a fork of Underscore.js with better performances.

Michel HuaMichel Hua

Whenever possible I would shift all of the querying to the backend on the server (to the SQL DB or other native database type). Reason being is that it will be quicker and more optimized to do the querying.

I know that jSON can be stand alone and there may be +/- for having a querying language but I cannot see the advantage if you are retrieving data from the backend to a browser, as most of the JSON use cases. Query and filter at the backend to get as small a data that is needed.

If for whatever reason you need to query at the front-end (mostly in a browser) then I would suggest just using array.filter (why invent something else?).

That said what I think would be more useful is a transformation API for json...they are more useful since once you have the data you may want to display it in a number of ways. However, again, you can do much of this on the server (which can be much easier to scale) than on the client - IF you are using server<-->client model.

Just my 2 pence worth!

Json Editor Mac

Colin SaxtonColin Saxton

Check out https://github.com/niclasko/Cypher.js (note: I'm the author)

It's a zero-dependency Javascript implementation of the Cypher graph database query language along with a graph database. It runs in the browser (tested with Firefox, Chrome, IE).

With relevance to the question. It can be used to query JSON endpoints:

Here's an example of querying a complex JSON document and performing analysis on it:

Niclas Kjäll-OhlssonNiclas Kjäll-Ohlsson

You could use linq.js.

How To Change Minecraft Json Files Mac

This allows to use aggregations and selectings from a data set of objects, as other structures data.

Nina ScholzNina Scholz
224k16 gold badges139 silver badges206 bronze badges

Json Tools Online

Not the answer you're looking for? Browse other questions tagged jsonnosqlweb-standardsqueryingdynamic-queries or ask your own question.

Coments are closed