ql.io and Node.js Sample Code from Live Coding Session at UtahJS

ql.io_node_application.js

var Engine = require('ql.io-engine');
var engine = new Engine({
                           connection: 'close'
                       });


var script = "create table geocoder " +
             "  on select get from 'http://maps.googleapis.com/maps/api/geocode/json?address={address}&sensor=true' " +
             "     resultset 'results.geometry.location'" +
             "select lat as lattitude, lng as longitude from geocoder where address='Mt. Everest'";

engine.execute(script, function(emitter) {
    emitter.on('end', function(err, res) {
        console.log(res.body[0]);
    });
});

ql.io_social_tables.js

create table slideshare on select get from "http://www.slideshare.net/rss/user/{user}" resultset "rss.channel";
create table github.users on select get from "http://github.com/api/v2/json/user/show/{user}";

user = "jcleblanc";
slides = select * from slideshare where user="{user}";
twitter = select * from github.users where user="{user}";
 
return {
  "slides": "{slides}",
  "twitter": "{twitter}"
}