secretGeek.net

JSON Query Languages: 5 special purpose editors

blog, color, editor, google, html, javascript, linguistics, microISV, sql

A few weeks ago I put out a simple editor for SQLike.

Since then I've researched a bunch of other JSON Query Languages, and created similar editors for each of them.

Here's the full set:

What are they?

Plus, Minus, Interesting

Here's a quick PMI comparison of each of them.

"SQLike"

Thomas Frank's SQLike uses SQL-style JSON for Querying JSON. Try it.

PlusMinusInteresting
  • Most complete join syntax.
  • Uses a SQL metaphor rather than Linq metaphor, hence larger audience
  • Keywords like 'sum' need to be embedded in pipe characters.
  • Function syntax is a little ceremonious (compared to sql)
  • Query is structured as JSON rather than fluidic api

"JsLinq"

Chris Pietschmann's Linq to Javascript (JsLinq) uses Fluent javascript for Querying JSON. Try it.

PlusMinusInteresting
  • Most complete implementation of Linq.
  • Join syntax not as thorough as SQLike(?)
  • The fork at gitHub which targets node.js is by Marak Squires who recently got in trouble for stealing code

"JSinq"

Kai Jaeger's JSinq uses Fluent javascript or linq-like strings for Querying JSON. Try it.

PlusMinusInteresting
  • Includes embedded expression language
  • Separate "create query" and "execute query" steps.
  • Can write queries as a single embedded string rather than pure javascript. :-)
  • Can write queries as a single embedded string rather than pure javascript. :-(
  • Can write queries as a single embedded string rather than pure javascript. (c;

"jLinq"

Hugo Bonacci's JLinq uses Fluent javascript for Querying JSON. Try it.

PlusMinusInteresting
  • Includes really thorough/practical set of predicate functions
  • No joins other than intersect and union

"jimmyLinq"

Jimmy Chandra's blogpost that I've dubbed JimmyLinq uses Fluent javascript for Querying JSON. Try it.

PlusMinusInteresting
  • Simple. A good starter if you want to write your own version of such a library.
  • Too simple.
  • Most amateur/"rough and ready" of the lot. Doesn't take itself as seriously as the others.

Some other JSON Query languages I could've looked into if my travel time was significantly longer:

All of which would stop me from getting back to releasing the product I should be releasing, or any of the other technical obsessions I'm trying to develop. So if you're interested in any of those... you're on your own.

 

My book "Choose Your First Product" is available now.

It gives you 4 easy steps to find and validate a humble product idea.

Learn more.

(By the way, I read every comment and often respond.)

Your comment, please?

Your Name
Your Url (optional)
Note: I may edit, reuse or delete your comment. Don't be mean.