Registry / database / connect-sqlite

connect-sqlite

JSON →
library0.0.1jsnpmunverified

SQLite session store for Express/Connect session middleware. Version 0.0.1 is a legacy package that persists Express sessions to a SQLite database using the node-sqlite3 driver. It works with older versions of Connect/Express (before Express 4.x). No active development; superseded by modern alternatives like connect-sqlite3 or better-sqlite3-session-store. Key differentiator: minimal implementation for basic session storage without external database servers.

databasestorage
npm install connect-sqlite
package ↗
INSTALL
IMPORT
SIG · CONNECT-SQLITE
C
connect-sqlite
databasejavascriptv0.0.1
harness data pending
Install & Compatibility
Where this runs

No compatibility data collected yet for this library.

Code
Verified usage

Verified import paths — ran on the pinned version, not inferred.

default
✓ var SQLiteStore = require('connect-sqlite')(express);
✗ const SQLiteStore = require('connect-sqlite');
The function must be called with the express module to get the store constructor.
SQLiteStore
✓ var SQLiteStore = require('connect-sqlite')(require('express'))
✗ import SQLiteStore from 'connect-sqlite'
Only CommonJS supported; no ESM exports.
store instance
✓ var store = new SQLiteStore();
Default constructor uses 'sessions.db' in current directory. Options available.

Basic Express session setup using connect-sqlite store with custom directory and database name.

var express = require('express'); var session = require('express-session'); var SQLiteStore = require('connect-sqlite')(express); var app = express(); app.use(session({ store: new SQLiteStore({ dir: './data', db: 'sessions.db' }), secret: 'keyboard cat', resave: false, saveUninitialized: true, cookie: { secure: false } })); app.get('/', function(req, res) { req.session.views = (req.session.views || 0) + 1; res.send('Views: ' + req.session.views); }); app.listen(3000);
Debug
Known issues
deprecatedPackage is no longer maintained. Use modern alternatives like connect-sqlite3, better-sqlite3-session-store, or express-session with a compatible store.
fix
Migrate to a maintained session store (see description).
affects: <=0.0.1
gotchaThe store constructor expects the express module as argument. Forgetting to pass it will cause a runtime error.
fix
Always call require('connect-sqlite')(require('express')).
affects: >=0.0.0
gotchaBy default, the SQLite database file is created in the current working directory ('sessions.db'). This can overwrite existing files if not careful.
fix
Pass options like { dir: './data', db: 'sessions.db' } to the constructor.
affects: >=0.0.0
breakingWorks only with older versions of Express/Connect (before Express 4.x). Not compatible with express-session 1.x without proper configuration.
fix
Ensure you are using compatible versions (Express <4). For Express 4+, use a different store.
affects: >=0.0.0
Errors
Common errors & fixes
Cannot find module 'connect-sqlite'
Package not installed or typo in require path.
fix
npm install connect-sqlite
SQLiteStore is not a constructor
The require returned the wrapper function, not the store class.
fix
Use var SQLiteStore = require('connect-sqlite')(require('express'));
SQLITE_ERROR: no such table: sessions
Automatic table creation failed due to permissions or missing 'dir' option.
fix
Ensure the directory exists and is writable. create table manually if needed.
Upgrade
Version history
0.0.1latest on npm
Audit
Dependencies
expressoptionalConnect is bundled with Express session middleware; the store works with express-session
node-sqlite3requiredUnderlying SQLite driver for database operations
Agent activity
23 hits · last 30 days
node
22
OpenAI (training)
1
Resources
packageconnect-sqlite ↗
connect-sqlite — npm install connect-sqlite · libregistry