SQLite3 session store for connect and express.
JavaScript CSS HTML
Switch branches/tags
Nothing to show
Clone or download
Pull request Compare This branch is 55 commits ahead of tnantoka:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
lib Merge pull request #17 from wmertens/patch-1 Apr 27, 2018
test Handle shared cache stores Jan 24, 2016
.gitignore release 0.1.0 Sep 24, 2011
Readme.md readme WAL mode link Apr 27, 2018
package.json package: bump sqlite3 to ^4.0.0 Apr 27, 2018

Readme.md

Connect SQLite3

connect-sqlite3 is a SQLite3 session store modeled after the TJ's connect-redis store.

Installation

	  $ npm install connect-sqlite3

Options

  • table='sessions' Database table name
  • db='sessionsDB' Database file name (defaults to table name)
  • dir='.' Directory to save '.db' file
  • concurrentDB='false' Enables WAL mode (defaults to false)

Usage

    var connect = require('connect'),
        SQLiteStore = require('connect-sqlite3')(connect);

    connect.createServer(
      connect.cookieParser(),
      connect.session({ store: new SQLiteStore, secret: 'your secret' })
    );

with express

    3.x:
    var SQLiteStore = require('connect-sqlite3')(express);

    4.x:
    var session = require('express-session');
    var SQLiteStore = require('connect-sqlite3')(session);

    app.configure(function() {
      app.set('views', __dirname + '/views');
      app.set('view engine', 'ejs');
      app.use(express.bodyParser());
      app.use(express.methodOverride());
      app.use(express.cookieParser());
      app.use(express.session({
        store: new SQLiteStore,
        secret: 'your secret',
        cookie: { maxAge: 7 * 24 * 60 * 60 * 1000 } // 1 week
      }));
      app.use(app.router);
      app.use(express.static(__dirname + '/public'));
    });

Test

    $ npm test