Connect Session Knex

connect-session-knex is an express-session store backed by PostgreSQL, MySQL, MariaDB, MSSQL, Oracle or SQLite3, via the knex.js library.

Installation

1$ npm install connect-session-knex

History

See Changelog.md

Usage

Example application using the defaults

Example application with PostgreSQL

Options

• cleanupInterval milliseconds between clearing expired sessions. Defaults to 60000. 0 disables the automatic clearing of expired sessions.
• createTable if the table for sessions should be created automatically or not.
• knex knex instance to use. Defaults to a new knex instance, using sqlite3 with a file named 'connect-session-knex.sqlite'
• tableName='sessions' Tablename to use. Defaults to 'sessions'.
• sidFieldName='sid' Field name in table to use for storing session ids. Defaults to 'sid'.

If the table does not exist in the schema, this module will attempt to create it unless the createTable option is false.

If a knex instance is not provided, this module will attempt to create a sqlite3 database, with a file named connect-session-knex.sqlite, in the working directory of the process.

Schema

PostgreSQL or SQLite

Table Name "sessions"

Column	Type	Modifiers	Storage
sid	character varying(255)	not null	extended
sess	json	not null	extended
expired	timestamp with time zone	not null	plain

Indexes:

    "sessions_pkey" PRIMARY KEY, btree (sid)
    "sessions_expired_index" btree (expired)

MySQL

Table Name sessions.

Column	Type	Modifiers
sid	VARCHAR(255)	NOT NULL, PK
sess	JSON	NOT NULL
expired	DATETIME	NOT NULL

Command to manually create table:

1CREATE TABLE `sessions` (
2  `sid` VARCHAR(255) NOT NULL,
3  `sess` JSON NOT NULL,
4  `expired` DATETIME NOT NULL,
5  PRIMARY KEY (`sid`));

Testing

Install Postgresql

Instructions for Ubuntu after intalling the db:

1sudo -u postgres psql

1CREATE DATABASE travis_ci_test OWNER postgres;

1GRANT all privileges ON DATABASE travis_ci_test TO postgres;

1ALTER USER postgres WITH PASSWORD 'postgres';

1\q

Install Mysql

Instructions for Ubuntu after installing the db:

1sudo mysql -u root

1create user 'travis' identified by 'travis';

1ALTER USER 'travis'@'localhost' IDENTIFIED BY 'travis';

1create database travis_ci_test;

1grant all on travis_ci_test.* to 'travis';

1\q

1sudo service mysql restart

Make sure both the MySQL and Postgres services are running

1npm run test