安装

pnpm add drizzle-orm better-sqlite3
pnpm add drizzle-kit @types/better-sqlite3 -D

定义表

schema.ts

import { integer, sqliteTable } from "drizzle-orm/sqlite-core";

export const videos = sqliteTable("videos", {
  id: integer("id").primaryKey(),
});

配置

drizzle.config.ts

import { defineConfig } from "drizzle-kit";
export default defineConfig({
  schema: "./src/schema.ts",
  dialect: "sqlite",
  dbCredentials: {
    url: "./sqlite.db",
  },
});

初始化

pnpm drizzle-kit push

生成了一个 sqlite.db 文件

可视化查看数据库

pnpm drizzle-kit studio

参考

• https://orm.drizzle.team/docs/get-started-sqlite#better-sqlite3
• https://orm.drizzle.team/kit-docs/overview#drizzle-studio
• https://orm.drizzle.team/kit-docs/conf#push-and-pull
• https://orm.drizzle.team/kit-docs/config-reference#dbcredentials