express-session-sequelize

Express session store using Sequelize to persist session data.

Usage

The session store must first be initialized by passing in expressSession.Store

const expressSession = require('express-session');
const SessionStore = require('express-session-sequelize')(expressSession.Store);

Then the session store instance can be created by using new SessionStore(options)

const express = require('express');
const cookieParser = require('cookie-parser');
const expressSession = require('express-session');
const SessionStore = require('express-session-sequelize')(expressSession.Store);
 
const Sequelize = require('sequelize');
const myDatabase = new Sequelize('database', 'username', 'password', {
    host: 'localhost',
    dialect: 'mysql',
});
 
const sequelizeSessionStore = new SessionStore({
    db: myDatabase,
});
 
const app = express();
 
app.use(cookieParser());
app.use(expressSession({
    secret: 'keep it secret, keep it safe.',
    store: sequelizeSessionStore,
    resave: false,
    saveUninitialized: false,
}));

Options

Full list of options that can be passed in while instanciating the session store.

const options = {
    db, // Valid Sequelize instance **required
    checkExpirationInterval, // How often expired sessions are purged in milliseconds.  (Default: 15 minutes)
    expiration, // How long until inactive sessions expire in milliseconds. (Default: 24 hours)
};