Prisma ORM 시작하기

Prisma ORM 기본 설정:

# 설치
npm install prisma @prisma/client
npx prisma init

// prisma/schema.prisma
datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "prisma-client-js"
}

model User {
  id        Int      @id @default(autoincrement())
  email     String   @unique
  name      String?
  posts     Post[]
  createdAt DateTime @default(now())
}

model Post {
  id       Int    @id @default(autoincrement())
  title    String
  content  String?
  author   User   @relation(fields: [authorId], references: [id])
  authorId Int
}

# 마이그레이션
npx prisma migrate dev --name init

# 사용
const user = await prisma.user.create({
  data: { email: "test@test.com", name: "홍길동" }
});
const posts = await prisma.post.findMany({
  include: { author: true }
});

TypeScript 자동완성이 완벽해서 생산성이 매우 높습니다.