CRUD SQLite (ORM + migrations)

import { defineModel } from "@bext-stack/framework/orm";
import { migrate } from "@bext-stack/framework/migrate";

// Tracked, idempotent schema — no lazy CREATE TABLE IF NOT EXISTS.
const migrations = [{
  id: "0001_create_notes",
  up: (db) => db.schema.createTable("notes", (t) => {
    t.id();
    t.text("body").notNull();
    t.timestamps();
  }),
  down: (db) => db.schema.dropTable("notes"),
}];

const Notes = defineModel<Note>({ table: "notes", db: ".bext/data/notes.db", timestamps: true });

export async function loader() {
  migrate({ db: DB }, migrations);            // applies pending only
  const notes = Notes.query().orderBy("id", "desc").limit(20).all();
  return { notes };                            // real typed objects
}

export async function action({ request }) {
  const form = await request.formData();
  if (form.get("op") === "add")    Notes.create({ body: form.get("body") });
  if (form.get("op") === "delete") Notes.delete(Number(form.get("id")));
  return new Response(null, { status: 303, headers: { Location: "/examples/db-crud" } });
}