bun-drizzle-integration

# Bun Drizzle Integration Drizzle ORM provides type-safe database access with Bun's SQLite driver. ## Quick Start ```bash bun add drizzle-orm bun add -D drizzle-kit ``` ## Schema Definition ```typescript // src/db/schema.ts import { sqliteTable, text, integer } from "drizzle-orm/sqlite-core"; export const users = sqliteTable("users", { id: integer("id").primaryKey({ autoIncrement: true }), name: text("name").notNull(), email: text("email").notNull().unique(), createdAt: integer("created_at", { mode: "timestamp" }) .notNull() .default(sql`(unixepoch())`), }); export const posts = sqliteTable("posts", { id: integer("id").primaryKey({ autoIncrement: true }), title: text("title").notNull(), content: text("content"), authorId: integer("author_id") .notNull() .references(() => users.id), }); ``` ## Database Setup ```typescript // src/db/index.ts import { drizzle } from "drizzle-orm/bun-sqlite"; import { Database } from "bun:sqlite"; import * as schema from "./schema"; const sqlite = new Database("app.db"); export const db = drizzle(sqlite, { schema }); ``` ## Configuration ```typescript // drizzle.config.ts import type { Config } from "drizzle-kit"; export default { schema: "./src/db/schema.ts", out: "./drizzle", dialect: "sqlite", dbCredentials: { url: "./app.db", }, } satisfies Config; ``` ## Migrations ```bash # Generate migration bun drizzle-kit generate # Apply migrations bun drizzle-kit migrate # Push schema direc...