Messing around with Web SQL API

web-sql.js

(function($, undefined){
  var ns = {}, db = openDatabase('learning_js', 
                      '1.0', 
                      'Database to create on tinkerbin',
                      2 * 1024 * 1024);
  ns.createDB = function(){
    db.transaction(function(tx) {
    tx.executeSql("CREATE TABLE IF NOT EXISTS 'primary' (id unique, text)");
    });
  };
  ns.insertValues = function(id, text){
      db.transaction(function(tx){
        tx.executeSql("INSERT INTO 'primary' (id, text) VALUES (?, ?)", [id, text]);
      });
  };
  ns.readValues = function(el){
  el.empty();
    db.transaction(function(tx){
      tx.executeSql("SELECT * FROM 'primary'", [], function (tx, results) {
        var len = results.rows.length, i;
        for (i = 0; i < len; i++) {
          el.append(results.rows.item(i).id + '&nbsp;&nbsp;&nbsp;' + results.rows.item(i).text + '\n\r');
        }
      });      
    });
  };
  $(function(){
    $('div.button').bind({
      'click.newDB' : function(){
        ns.createDB();
        ns.insertValues(Math.random(), 'Test' + Math.random());
        ns.readValues($('#source'));
      }
    });
  });
}(jQuery));