@copypatch/storage-sqlite

English | Türkçe

SQLite persistence for CopyPatch v3. The adapter implements the asynchronous CopyPatchPersistence contract while using transactional, synchronous SQLite operations internally.

Install

pnpm add @copypatch/core @copypatch/storage-sqlite better-sqlite3

@copypatch/storage-sqlite supports Node.js 20.x, 22.x, 23.x, 24.x, 25.x, and 26.x, matching its better-sqlite3@12 runtime. Node.js 21 is not supported. This SQLite-specific range does not change the >=20 requirement of the other CopyPatch packages.

Usage

import { createSQLitePersistence } from '@copypatch/storage-sqlite';

const persistence = createSQLitePersistence('./copypatch.sqlite');
await persistence.migrate();

try {
  const snapshot = await persistence.readPublished('en');
  console.log(snapshot);
} finally {
  persistence.close();
}

The factory also accepts { filename, busyTimeoutMs }. Call migrate() before the first operation on a new database. Migrations are versioned and idempotent.

Content mutations use atomic compare-and-swap checks against both published and draft revisions. Sessions and rate limits are stored in SQLite so they survive process restarts. Session callers must pass cryptographic token hashes; the adapter never accepts or derives raw session tokens.

Exports

• createSQLitePersistence(filenameOrOptions)
• SQLitePersistence
• SQLitePersistenceOptions

CopyPatch is ESM-only. See the CopyPatch repository for complete API documentation and examples.