Card · Drizzle

SQL-first, type-safe, minimal magic for App Router.

Core

SQL-first; great with App Router.
SQLite start; swap driver for Postgres/MySQL.

Snippets

npm install drizzle-orm better-sqlite3
npm install -D drizzle-kit

export const users = sqliteTable("users", {
  id: integer("id").primaryKey(),
  email: text("email").notNull(),
});
const sqlite = new Database("dev.db");
export const db = drizzle(sqlite);
await db.select().from(users);

Study Card · Chapter 13-drizzle