@pidgeyjs/sqlite

SQLite adapter for Pidgey.

Installation

pnpm add @pidgeyjs/sqlite @pidgeyjs/core better-sqlite3

Usage

Configuration

import { PidgeyClient } from '@pidgeyjs/core';
import { SQLiteQueueAdapter } from '@pidgeyjs/sqlite';

const client = new PidgeyClient(
  new SQLiteQueueAdapter({
    filename: 'path/to/database.sqlite',
  })
);

Migrations

This adapter requires database tables to be created. You can use the Pidgey CLI to manage migrations.

# Create a new migration
pnpm exec pidgey-devkit create-migration

Or you can manually run the SQL files found in node_modules/@pidgeyjs/sqlite/dist/migrations.

License

MIT