pouchdb-sqlite-driver-node

Concrete driver for Node's built-in node:sqlite API.

Pre-0.1; not published to npm yet.

import PouchDB from "pouchdb-core";
import genericSQLite from "pouchdb-adapter-generic-sqlite";
import { createNodeSQLiteDriver } from "pouchdb-sqlite-driver-node";

const DB = PouchDB.plugin(genericSQLite);
const driver = createNodeSQLiteDriver({ journalMode: "WAL" });

const db = new DB("app.sqlite", {
  adapter: "generic-sqlite",
  sqlite: { driver },
});

Supported floor: Node >=22.5. Early Node 22 releases may require --experimental-sqlite.

By default relative database names resolve against the working directory captured when the factory is created. Custom filename resolution or deletion hooks require an explicit cacheNamespace because they change physical storage identity.

The driver detects SQLite's variable limit from compile options, preserves Uint8Array BLOBs, serializes transactions, and deletes ordinary database files plus WAL/SHM/journal sidecars on Pouch destroy.