Connect-tedious NPM

#connect-tedious

connect session store for SQL Server, using tedious.

Usage

Sample

The simplest sample requires a SQL Server 2008+ database with a table created as follows

CREATE TABLE [dbo].[Sessions](
  [Sid] varchar(255) NOT NULL
    CONSTRAINT [PK_Sessions] PRIMARY KEY CLUSTERED ([Sid] ASC),
  [Expires] datetimeoffset NOT NULL,
  [Sess] nvarchar(MAX) NULL
)

The session store can then be created

var express = require('express');
var session = require('express-session');
var TediousStore = require('connect-tedious')(session);

var app = express.createServer()
    .use(express.cookieParser())
    .use(express.session({
        secret: 'mysecret',
        store: new TediousStore({
            config: {
                userName: 'mydbuser',
                password: 'mydbpassword',
                server: 'localhost',
                options: {
                  instanceName: 'SQLEXPRESS',
                  database: 'mydatabase'
                }
            }
        })
    )
);

Syntax

Class TediousStore:

new TediousStore(options, connectionString)
- options: Object
  - config: Object The same configuration that would be used to create a tedious Connection.
  - tableName: String The table name. Defaults to [dbo].[Sessions].
  - sidColumnName: String The session Id column name. Defaults to [Sid].
  - sessColumnName: String The session content column name. Defaults to [Sess].
  - expiresColumnName: String The session expiration column name. Defaults to [Expires].
  - minConnections: Number The minimum number of connections to keep in the pool. Defaults to 0.
  - maxConnections: Number The maximum number of connections to keep in the pool. Defaults to 100.
  - idleTimeout: Number The number of milliseconds before closing an unused connection. Defaults to 30000.
- connectionString: String A connection string that can be used to specify all database related options.