brianleroux

// create a new store
var store = new Lawnchair({adaptor:'dom', table:'people'});

// saving documents
store.save({name:'brian'});

// optionally pass a key
store.save({key:'config', settings:{color:'blue'}});

// updating a document in place is the same syntax

brianleroux

// Get that document
people.get(me.key, function(r){
    console.log(r);
});
		

// Returns all documents as an array to a callback
people.all(function(r){
    console.log(r);
});

IcyMidnight

DELIMITER |

CREATE FUNCTION uuid_from_bin(b BINARY(16))
RETURNS CHAR(36) DETERMINISTIC
BEGIN
  DECLARE hex CHAR(32);
  SET hex = HEX(b);
  RETURN CONCAT(LEFT(hex, 8), '-', MID(hex, 9,4), '-', MID(hex, 13,4), '-', MID(hex, 17,4), '-', RIGHT(hex, 12));
END
|