JsonSql is a small intresting Javscript Library that allows you to get data from JSON with SQ like queryies with following syntax:
- Only Select statements are supported
- The requested fields may be a "*" or a list of fields. "*" is likely faster in most cases.
- When typing lists "select field1,field2,field3" or "limit 5,10 do not use spaces.
- When using the "where" clause enclose all conditions with one set of parenthesis "where (category=='The Category' || category=='Other Category')".
- The where clause is a javascript condition, not sql. It should use the scope emplied by "from". Javascript functions may be used here as well as javascript operators.
- The from clause should establish the scope you would like returned. It should start with "json" and use the dot notation: "json.channel.items" and should point to an array within the object.
- The order by option can accept a list but will only order by the first field at this time(asc,desc,ascnum,descnum).
Source: JsonSQL
Tags:
These do work.
Here is the
It's interesting to hear about performance of this library.