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

$ npm install connect-session-knex

SeeChangelog.md

Example application using the defaults

Example application with PostgreSQL

• 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 thecreateTable option is false.

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

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

Table Namesessions.

Command to manually create table:

CREATETABLE `sessions` (`sid`VARCHAR(255)NOT NULL,`sess` JSONNOT NULL,`expired` DATETIMENOT NULL,PRIMARY KEY (`sid`));

Install Postgresql

Instructions for Ubuntu after intalling the db:

sudo -u postgres psql

CREATEDATABASEtravis_ci_test OWNER postgres;

GRANT all privilegesON DATABASE travis_ci_test TO postgres;

ALTERUSER postgres WITH PASSWORD'postgres';

\q

Install Mysql

Instructions for Ubuntu after installing the db:

sudo mysql -u root

createuser 'travis' identified by'travis';

ALTERUSER'travis'@'localhost' IDENTIFIED BY'travis';

createdatabasetravis_ci_test;

grant allon travis_ci_test.* to'travis';

\q

sudo service mysql restart

Make sure both the MySQL and Postgres services are running

npm runtest