在 Bun 中使用 Prisma

mkdir prisma-app
cd prisma-app
bun init

bun add -d prisma
bun add @prisma/client @prisma/adapter-libsql

bunx --bun prisma init --datasource-provider sqlite

  generator client {
    provider = "prisma-client"
    output = "./generated"
    engineType = "client"
    runtime = "bun"
  }

  datasource db {
    provider = "sqlite"
    url      = env("DATABASE_URL")
  }

  model User { 
    id    Int     @id @default(autoincrement()) 
    email String  @unique
    name  String?
  } 

 bunx --bun prisma migrate dev --name init

bunx --bun prisma generate

import { PrismaClient } from "./generated/client";
import { PrismaLibSQL } from "@prisma/adapter-libsql";

const adapter = new PrismaLibSQL({ url: process.env.DATABASE_URL || "" });
export const prisma = new PrismaClient({ adapter });

import { prisma } from "./prisma/db";

// 创建一个新用户
await prisma.user.create({
  data: {
    name: "John Dough",
    email: `john-${Math.random()}@example.com`,
  },
});

// 统计用户数量
const count = await prisma.user.count();
console.log(`数据库中共有 ${count} 名用户。`);

bun run index.ts

bun run index.ts

bun run index.ts