PostgreSQL & Prisma: Modern Database Development

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        String   @id @default(uuid())
  email     String   @unique
  name      String?
  posts     Post[]
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

model Post {
  id        String   @id @default(uuid())
  title     String
  content   String?
  published Boolean  @default(false)
  author    User     @relation(fields: [authorId], references: [id])
  authorId  String
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

# Create migration
npx prisma migrate dev --name init

# Reset database
npx prisma migrate reset

# Deploy migrations
npx prisma migrate deploy

import { PrismaClient } from '@prisma/client';

const prisma = new PrismaClient();

const user = await prisma.user.create({
  data: {
    email: 'john@example.com',
    name: 'John Doe',
    posts: {
      create: {
        title: 'My First Post'
      }
    }
  }
});

// Find many
const users = await prisma.user.findMany();

// Find unique
const user = await prisma.user.findUnique({
  where: { email: 'john@example.com' }
});

// Find first
const user = await prisma.user.findFirst({
  where: { name: { contains: 'John' } }
});

// Include relations
const user = await prisma.user.findUnique({
  where: { id: userId },
  include: { posts: true }
});

const user = await prisma.user.update({
  where: { id: userId },
  data: { name: 'Jane Doe' }
});

await prisma.user.delete({
  where: { id: userId }
});

const users = await prisma.user.findMany({
  where: {
    email: { contains: 'example' },
    posts: {
      some: { published: true }
    }
  },
  orderBy: {
    createdAt: 'desc'
  },
  take: 10,
  skip: 20
});

const result = await prisma.$transaction(async (tx) => {
  const user = await tx.user.create({
    data: { email: 'john@example.com' }
  });

  const post = await tx.post.create({
    data: {
      title: 'Hello',
      authorId: user.id
    }
  });

  return { user, post };
});