Javascript libraries that allow for SQL-like queries on JSON data? [closed]
Check out jslinq:
var myList = [ {FirstName:"Chris",LastName:"Pearson"}, {FirstName:"Kate",LastName:"Johnson"}, {FirstName:"Josh",LastName:"Sutherland"}, {FirstName:"John",LastName:"Ronald"}, {FirstName:"Steve",LastName:"Pinkerton"} ];var exampleArray = JSLINQ(myList) .Where(function(item){ return item.FirstName == "Chris"; }) .OrderBy(function(item) { return item.FirstName; }) .Select(function(item){ return item.FirstName; });
You can try alasql.js. It is pure JavaScript client-side SQL-server, where you can do queries over JSON objects.
// Fill table with data var data = [ { name: 'bill' , sex:'M', income:50000 }, { name: 'sara' , sex:'F', income:100000 }]; // Do the query console.log(alasql("SELECT * FROM ? WHERE sex='F' AND income > 60000",[data]));
Try this in Fiddle
I use Taffydb. TaffyDB is an opensouce library that brings database features into your JavaScript applications.http://taffydb.com/