Awesome

koa-generic-session-sequelize

Store Koa sessions in a database using Sequelize.

Compatibility

Sequelize 4.12.0 or higher is supported.

Usage

Notice: This is an older module that works best with koa-generic-session. However, most Koa apps today use the more modern koa-session library. Unfortunately, this module is not designed to work with that.

This session storage provider works with koa-generic-session (session middleware for Koa). It also works with koa-session-minimal, but koa-generic-session is recommended.

It stores session data in a database defined by you, using the Sequelize ORM.

It has been tested with SQLite, MySQL, PostgreSQL, and Microsoft SQL Server.

Installation

npm install --save koa-generic-session-sequelize

Example

Full example in examples/basic_sqlite.js.

const SequelizeStore = require('koa-generic-session-sequelize');

// set up Sequelize in the usual manner
// for a quick example using the sqlite3 module:
const sequelize = new Sequelize({
  logging: false,
  dialect: 'sqlite',
  storage: __dirname + '/example.db'
});

app.use(session({
  store: new SequelizeStore(
    sequelize,            // pass your sequelize object as the first arg
    {}                    // pass any config options for sequelizeStore as the second arg (see below)
  )
}));

Options

• tableName - Name of the session table in the db (default: Sessions)
• modelName - Name of the session model to be registered with Sequelize (default: Session)
• sync - Create the sessions table if it doesn’t exist (default: true)
• syncTimeout - If sync is true, how long to wait, in ms, for the sync to complete (default: 3000)
• gcFrequency - Do garbage collection after approximately this many requests. This deletes expired session data from the table. Set to 0 to never do garbage collection. (default: 10000, or approximately every 10,000 requests)
• timestamps - If true, the table will have updatedAt and createdAt columns. (default: false)
• browserSessionLifetime - How long, in ms, to remember sessions without a TTL: sessions that only last until the browser is closed. Some session managers, including koa-session-minimal, will ignore this and use a reasonable default. (default: 86400000)

Replication

Sequelize supports replication (configured as options.replication). This lets you use one server for writes and another server, or a group of servers, for reads.

However, if there is any lag between the time a write is committed and when it becomes visible on your read servers, you should not use that configuration for session data. Create a separate Sequelize instance for the session data that does not use replication.

Unit tests

To run the test suite, clone this repository and run npm install in the checkout directory. Then run npm test. This will exercise the library against SQLite.

To test against MySQL, PostgreSQL, or SQL Server, edit test/config.js. Uncomment sections referencing those servers and enter your credentials. The table _sess_test will be created during testing.