db-core-persistence

name	db-core/persistence
description	SQLite-backed persistence for TanStack DB collections. persistedCollectionOptions wraps any adapter (Electric, Query, PowerSync, or local-only) with durable local storage. Platform adapters: browser (WA-SQLite OPFS), React Native (op-sqlite), Expo (expo-sqlite), Electron (IPC), Node (better-sqlite3), Capacitor, Tauri, Cloudflare Durable Objects. Multi-tab/multi-process coordination via BrowserCollectionCoordinator / ElectronCollectionCoordinator / SingleProcessCoordinator. schemaVersion for migration resets. Local-only mode for offline-first without a server. Applied transaction log pruning and safe full-reload recovery.
type	sub-skill
library	db
library_version	0.6.17
sources	["TanStack/db:packages/db-sqlite-persistence-core/src/persisted.ts","TanStack/db:packages/browser-db-sqlite-persistence/src/index.ts","TanStack/db:packages/react-native-db-sqlite-persistence/src/index.ts","TanStack/db:packages/expo-db-sqlite-persistence/src/index.ts","TanStack/db:packages/electron-db-sqlite-persistence/src/index.ts","TanStack/db:packages/node-db-sqlite-persistence/src/index.ts","TanStack/db:examples/react/offline-transactions/src/db/persisted-todos.ts","TanStack/db:examples/react-native/shopping-list/src/db/collections.ts"]

This skill builds on db-core and db-core/collection-setup. Read those first.

SQLite Persistence

TanStack DB persistence adds a durable SQLite-backed layer to any collection. Data survives page reloads, app restarts, and offline periods. The server remains authoritative for synced collections -- persistence provides a local cache that hydrates instantly.

Choosing a Platform Package

Platform	Package	Create function
Browser (OPFS)	@tanstack/browser-db-sqlite-persistence	createBrowserWASQLitePersistence
React Native	@tanstack/react-native-db-sqlite-persistence	createReactNativeSQLitePersistence
Expo	@tanstack/expo-db-sqlite-persistence	createExpoSQLitePersistence
Electron	@tanstack/electron-db-sqlite-persistence	createElectronSQLitePersistence (renderer)
Node.js	@tanstack/node-db-sqlite-persistence	createNodeSQLitePersistence
Capacitor	@tanstack/capacitor-db-sqlite-persistence	createCapacitorSQLitePersistence
Tauri	@tanstack/tauri-db-sqlite-persistence	createTauriSQLitePersistence
Cloudflare DO	@tanstack/cloudflare-durable-objects-db-sqlite-persistence	createCloudflareDOSQLitePersistence

All platform packages re-export persistedCollectionOptions from the core.

Local-Only Persistence (No Server)

For purely local data with no sync backend:

import { createCollection } from '@tanstack/react-db'
import {
  createBrowserWASQLitePersistence,
  openBrowserWASQLiteOPFSDatabase,
  persistedCollectionOptions,
} from '@tanstack/browser-db-sqlite-persistence'

 database =  ({
  : ,
})

 persistence = ({
  database,
})

 draftsCollection = (
  persistedCollectionOptions<, >({
    : ,
    :  d.,
    persistence,
    : ,
  }),
)