SQLite

Pass a better-sqlite3 database straight into restaq({ database }). Restaq detects the dialect automatically and applies its own schema migrations.

pnpm add better-sqlite3

npm install better-sqlite3

yarn add better-sqlite3

bun add better-sqlite3

// relay.ts
import { restaq as createRestaq } from 'restaq';
import Database from 'better-sqlite3';

export const restaq = createRestaq({
  database: new Database('restaq.db'),
  plugins: [
    // ...
  ],
});

Good for local development, testing, and small single-instance deployments. Once you're running more than one instance of your app, move to Postgres or MySQL instead.