Nervously Practice Multithreading

    mssql-session-store

    1.0.0 • Public • Published

    mssql-session-store

    Implementation of an express-session store using SQL Server. Uses mssql to connect to the database.

    Installation

    $ npm install mssql-session-store
    

    Important:

    The store is expecting this table to exist in your database.

    create table Session
    (
      sessionId nvarchar(450) not null primary key,
      sessionData nvarchar(max) null,
      lastTouchedUtc datetime not null  
    )
    

    Example

    var session = require('express-session')
    var MssqlStore = require('mssql-session-store')(session);
    
    app.use(session({
      secret: 'keyboard cat',
      resave: false,
      saveUninitialized: false,
      store: new MssqlStore(options) // see options below
    }));
    

    Options

    var options = {
        connection: existingConnection,
        ttl: 3600,
        reapInterval: 3600,
        reapCallback: function() { console.log('expired sessions were removed); }
    };
    

    connection

    Default value: undefined

    Optional instance of a Connection from mssql. If undefined then the global connection will be used.

    ttl

    Default value: 3600

    Optional time to live in seconds. Sessions that have not been "touched" in this amount of time will be destroyed. If reapInterval is set to -1 then this setting has no effect.

    reapInterval

    Default value: 3600

    Optional interval to destroy expired sessions in seconds or -1 to never remove expired sessions. Fires once on construction of the MssqlStore object (unless reapInterval is set to -1).

    reapCallback

    Default value: undefined

    Optional callback that is fired after each reaping.

    License

    http://jwathen.mit-license.org

    Install

    npm i mssql-session-store

    DownloadsWeekly Downloads

    134

    Version

    1.0.0

    License

    none

    Last publish

    Collaborators

    • jwathen