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 dboSessions Sid NOT NULL CONSTRAINT PK_Sessions PRIMARY KEY Expires datetimeoffset NOT NULL Sess NULL
The session store can then be created
var express = ;var session = ;var TediousStore = session; var app = express
Syntax
Class TediousStore
:
-
new TediousStore(options, connectionString)
options
: Objectconfig
: 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 to0
.maxConnections
: Number The maximum number of connections to keep in the pool. Defaults to100
.idleTimeout
: Number The number of milliseconds before closing an unused connection. Defaults to30000
.
connectionString
: String A connection string that can be used to specify all database related options.
License
View the LICENSE file