hono + drizzle

my drizzle notes

pnpm create hono

pnpm add drizzle-orm pg dotenv
pnpm add -D drizzle-kit @types/pg

.env

DATABASE_URL=postgresql://qin:1@192.168.1.4:5432/db1

drizzle.config.ts

import "dotenv/config";
import { defineConfig } from "drizzle-kit";

export default defineConfig({
  out: "./drizzle",
  schema: "./src/db/schema",
  dialect: "postgresql",
  dbCredentials: {
    url: process.env.DATABASE_URL!,
  },
});

同步数据库

npx drizzle-kit push