Trent Richardson

I’ve had several users ask about using Impromptu with ajax to pull in content. I myself far more pull in json to build my content for Impromptu. So I figured I’d kill two birds with one stone by creating an example of using Ajax to pull in JSON content, then build a select [...]

Almost on a daily basis I come across using regular expressions rather convenient. I first toyed with regular expressions in my Compiler Design classes during my undergrad studies, and little did I know they can be used for everyday things like submitting forms. I’ve even toyed with them to create my own json [...]

Thanks to Harry over at Code Bus we now have a PHP version of JsonSQL. For those not familiar with JsonSQL, it allows you to use basic SQL syntax to parse json. Supported syntax includes selects, order by, where, and limit and allows you to apply conditions on objects of any depth within [...]

After a bit of work it is now possible to use sql to parse json using javascript!. I introduce to you version 0.1 of JsonSQL. Given a javascript object you can write a simple select statement to filter, order and limit the object:
jsonsql.query(“select title,url from json.channel.items
where (category==’javascript’ || category==’vista’)
order by title,category asc [...]