pnpm add drizzle-orm
pnpm add -D drizzle-kit
yarn add drizzle-orm
yarn add -D drizzle-kit
npm install drizzle-orm
npm install -D drizzle-kit
bun add drizzle-orm
bun add --dev drizzle-kit
// drizzle.config.ts
import { defineConfig } from "drizzle-kit";
export default defineConfig({
dialect: "sqlite",
schema: "./server/db/schema/index.ts",
out: "./server/db/migrations",
});
You can access the database instance and schema directly from hub:db:
import { db, schema } from 'hub:db'
And for other utilities:
import { sql, eq, and, or } from 'drizzle-orm'
To avoid typing the lengthy bun run drizzle-kit generate command every time, add this script to your package.json:
// package.json
{
"scripts": {
"db:generate": "nuxt db generate"
}
}
Later, you can generate schemas by simply running bun run db:generate.