0.0.4 • Published 3 years ago

express-sqlite3 v0.0.4

Weekly downloads
-
License
MIT
Repository
github
Last release
3 years ago

express-sqlite3

npm codecov

SQLite3 session store for the express-session package.

Installation

npm i express-sqlite3

Options

namedescriptiondefault value
dbDatabase file namesessions
dirDatabase file directory./
modeSQLite3 client mode option
tableDatabase table namesessions
maxAgeSessions maximum age in msecs86400000 (One day)
concurentDbEnables WAL modefalse
cleanupIntervalInterval for expired sessions cleanup in msecs3600000 (One hour)

Example

For Express 4.xx

const express = require('express');
const session = require('express-session');
const Store = require('express-sqlite3')(session);

const app = express();

const storeOptions = {
  db: ':memory:', // Use SQLite3 in memory db.
  concurentDb: true, // Enable SQLite3 WAL.
};

app.use(session({
  store: new Store(storeOptions),
  secret: 'qwerty',
  resave: false,
  saveUninitialized: true,
}));

Test

Install dev dependencies.

npm i -D express-sqlite3

Then run

npm test or npm run test:coverage