Prisma ORM

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

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

model User {
  id        String   @id @default(cuid())
  email     String   @unique
  createdAt DateTime @default(now())
  posts     Post[]
}

model Post {
  id       String  @id @default(cuid())
  title    String
  body     String
  author   User    @relation(fields: [authorId], references: [id])
  authorId String
}

import { PrismaClient } from "@prisma/client";
const prisma = new PrismaClient();

export async function createPost(authorEmail: string, title: string, body: string) {
  try {
    return await prisma.post.create({
      data: {
        title,
        body,
        author: { connect: { email: authorEmail } },
      },
      include: { author: true },
    });
  } catch (e) {
    console.error("createPost failed", e);
    throw e;
  }
}

export async function recentPosts() {
  return prisma.post.findMany({
    orderBy: { id: "desc" },
    take: 20,
    include: { author: { select: { email: true } } },
  });
}