SQLite Plugin

SQLite-backed storage for Node/Electron environments.

Installation

npm install @routier/sqlite-plugin sqlite3

Basic Usage

import { DataStore } from "@routier/datastore";
import { s } from "@routier/core/schema";
import { SqlitePlugin } from "@routier/sqlite-plugin";

const userSchema = s
    .define("users", {
        id: s.string().key().identity(),
        email: s.string().distinct(),
        name: s.string(),
        createdAt: s.date().default(() => new Date()),
    })
    .compile();

class Ctx extends DataStore {
    users = this.collection(userSchema).create();

    constructor() {
        super(new SqlitePlugin("./data.db"));
    }
}

const ctx = new Ctx();
await ctx.users.addAsync({ name: "Ada", email: "[email protected]" });
await ctx.saveChangesAsync();

Notes

• Good when you need SQL and strong persistence locally.