connect-monetdb

A straightforward MonetDB session store for Connect/Express. This module has no direct dependencies, but it does require you to pass it two things:

1. A session variable, resulting from require("express-session")
2. A MonetDBConnection, or a MonetDBPool object

Installation

npm install [-g] connect-monetdb

Create a table to store session information

CREATE TABLE session (
    sid              STRING        NOT NULL PRIMARY KEY,
    sess             STRING        NOT NULL,
    expire           INT           NOT NULL
);

Usage

Initializing the store by creating a MonetDBConnection object and passing it to the store constructor

var MonetDBConnection = require('monetdb')();
var session = require("express-session");
var MDBSessStore = require("connect-monetdb")(session);
 
var conn = new MonetDB({ dbname: "demo" });
conn.connect();
 
var store = new MDBSessStore(conn);

Initializing the store by creating a MonetDBPool object and passing it to the store constructor

var MonetDBPool = require('monetdb-pool')();
var session = require("express-session");
var MDBSessStore = require("connect-monetdb")(session);
 
var pool = new MonetDBPool({ nrConnections: 4 }, { dbname: "demo" });
pool.connect();
 
var store = new MDBSessStore(pool);

Set up the express app to use the just created store

var sessOpt = {
    store: store,
    secret: "i2D#0wj38D_kZhW20&qA97hQQd@0/S81h",
    rolling: true,
    resave: false,
    saveUninitialized: true,
    unset: "destroy"
};
 
var app = require("express")();
app.use(session(sessOpt));

Please report any suggestions/bugs to [e-mail]