Lightweight ORM for SQLite with typesafe client and code generation from SQL (WIP).
yarn add -D @fuwa-orm/cli
yarn add @fuwa-orm/client-- schema.sql
CREATE TABLE User (
id INTEGER NOT NULL,
email TEXT NOT NULL,
name TEXT,
PRIMARY KEY (id),
UNIQUE (email)
);
CREATE TABLE Post (
id INTEGER NOT NULL,
authorId INTEGER NOT NULL,
title TEXT NOT NULL,
published integer NOT NULL DEFAULT 0, -- Boolean
PRIMARY KEY (id),
FOREIGN KEY (authorId) REFERENCES User (id)
);yarn fuwa generate schema.sqlimport Database from "better-sqlite3";
import { FuwaClient } from "@fuwa-orm/client";
import { ModelGateways } from "./.fuwa-orm/index.js";
const db = FuwaClient.create<ModelGateways>(new Database("sample.db"));
const user = db.user.create();
console.log(user);
const post = db.post.create();
console.log(post);
const users = db.user.findMany();
console.log(users);