SQLite

SQLite is an embedded relational database. It stores data in a single file, or fully in memory for ephemeral use.

Setup

Install

npm install @primate/sqlite

Configure

// config/database/index.ts
import sqlite from "@primate/sqlite";

export default sqlite({
  // database: ":memory:",        // in-memory (default)
  // database: "/var/data.db",     // file path (persists)
});

Options

":memory:" uses an in-memory database. It does not persist across runs.