JSON Query Languages: 5 special purpose editors

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.

 

I'm currently writing a book about how to build your first product. If building a product is something you'd like to do, then sign up to be notified when the book is available.

Your comment, please?

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