gistfile1.js

// スキーマ定義
var JSRel = require("jsrel");
var db = JSRel.create("dbname", {schema: 
  { user: { name : true, is_activated: "on", $uniques: "name"},
    book: { title: true, price: 1, author: "user", $indexes: "title" },
}});

// データの挿入
if (!db.loaded) { // if loaded from saved data, omits this section
  var u1 = db.ins('user', {name: 'shinout'});
  var u2 = db.ins('user', {name: 'xxxxx', is_activated: false});
  var b1 = db.ins('book', {title: 'how to jsrel', price: 10, author: u1});
  var b2 = db.ins('book', {title: 'JSRel API doc', price: 20, author_id: u1.id});
}

// データの取得
var users = db.find('user', {is_activated: true});