JSON Query Languages: 5 special purpose editors
secretGeek .:dot Nuts about dot Net:.
home .: about .: sign up .: sitemap .: secretGeek RSS

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.






name


website (optional)


enter the word:
 

comment (HTML not allowed)


All viewpoints welcome. Incivility is not tolerated, such comments are deleted.

 

I'm the co-author of TimeSnapper, a life analysis system that stores and plays-back your computer use. It makes timesheet recording a breeze, helps you recover lost work and shows you how to sharpen your act.

 

NimbleText - FREE text manipulation and data extraction

NimbleText is a Powerful FREE Tool

I wrote this, and use it every day for:

  • extracting data from text
  • manipulating text
  • generating code

It makes you look awesome. You should use NimbleText, you handsome devil!

 

Articles

A Computer Simulation of Creative Work, or 'How To Get Nothing Done' A Computer Simulation of Creative Work, or 'How To Get Nothing Done'
NimbleText 1.9 -- BoomTown! NimbleText 1.9 -- BoomTown!
Line Endings. Line Endings.
**This** is how you pivot **This** is how you pivot
Art of the command-line helper Art of the command-line helper
Go and read a book. Go and read a book.
Slurp up mega-traffic by writing scalable, timeless search-bait Slurp up mega-traffic by writing scalable, timeless search-bait
Do *NOT* try this Hacking Script at home Do *NOT* try this Hacking Script at home
The 'Should I automate it?' Calculator The 'Should I automate it?' Calculator
aaron swartz: the early works aaron swartz: the early works
Finding (and removing) duplicate files on your hard drive Finding (and removing) duplicate files on your hard drive
Harvey, a .net chat server built with RabbitMQ Harvey, a .net chat server built with RabbitMQ
LeonBambrick.com LeonBambrick.com
So your domain has been stolen. What now? So your domain has been stolen. What now?
kv can remember it for you, wholesale kv can remember it for you, wholesale
Hello IT Department Hello IT Department
Dialog Between a Man and His Vista Laptop Dialog Between a Man and His Vista Laptop
NimbleText 1.6, Codename Jetboat NimbleText 1.6, Codename Jetboat
On Task Hoarding and Todo Bankruptcy On Task Hoarding and Todo Bankruptcy
Developer UI Done Right: Mercurial Commandline! Developer UI Done Right: Mercurial Commandline!
Rediscovering the Amstrad CPC 6128 Rediscovering the Amstrad CPC 6128
Just Wally Just Wally
The Correct Order for a First Time Viewing of The Lord Of The Rings The Correct Order for a First Time Viewing of The Lord Of The Rings
A new era for Android. A new era for Android.
Mind-boggling Demo of New Gaming Genre, aka Folder-Based Hangman, aka Fun with Recursion Mind-boggling Demo of New Gaming Genre, aka Folder-Based Hangman, aka Fun with Recursion
Got CSV in your javascript? Use agnes. Got CSV in your javascript? Use agnes.

Archives Complete secretGeek Archives

TimeSnapper -- Automated Screenshot Journal TimeSnapper: automatic screenshot journal

25 steps for building a Micro-ISV 25 steps for building a Micro-ISV
3 minute guides -- babysteps in new technologies: powershell, JSON, watir, F# 3 Minute Guide Series
Universal Troubleshooting checklist Universal Troubleshooting Checklist
Top 10 SecretGeek articles Top 10 SecretGeek articles
ShinyPower (help with Powershell) ShinyPower
Now at CodePlex

Realtime CSS Editor, in a browser RealTime Online CSS Editor
Gradient Maker -- a tool for making background images that blend from one colour to another. Forget photoshop, this is the bomb. Gradient Maker


[powered by Google] 


How to be depressed How to be depressed
You are not inadequate.



Recommended Reading


the little schemer


The Best Software Writing I
The Business Of Software (Eric Sink)

Recommended blogs

Jeff Atwood
Joseph Cooney
Phil Haack
Scott Hanselman
Julia Lerman
Rhys Parry
Joel Pobar
OJ Reeves
Eric Sink

Aggregated Links

proggit
dzone
hacker news
dot net kicks

Human Link Machines

interesting finds
a continuous learner's weblog
arjan's world
weekly link post

LinkedIn profile
LogEnvy - event logs made sexy
Computer, Unlocked. A rapid computer customization resource
Aussie Bushwalking
BrisParks :: best parks for kids in brisbane
PhysioTec, Brisbane Specialist Physiotherapy & Pilates
 
home .: about .: sign up .: sitemap .: secretGeek RSS .: © Leon Bambrick 2006 .: privacy

home .: about .: sign up .: sitemap .: RSS .: © Leon Bambrick 2006 .: privacy