How to Set Up Next.js with Prisma Client in Easy Steps

Key Takeaways

• Properly set up a Next.js project with Prisma by initializing the project, installing the Prisma Client, and configuring the Prisma schema to ensure efficient database interactions.
• Utilize methods like Server-Side Rendering (SSR) and Static Site Generation (SSG) to fetch data from the database effectively, enhancing application performance and flexibility.
• Adopt best practices such as maintaining a single PrismaClient instance, implementing connection pooling, and leveraging TypeScript for type safety to optimize the use of Prisma Client in a Next.js application.

How to Set Up Your Next.js Project with Prisma

Initialize a Next.js Project

To start, create a new Next.js project using the create-next-app command:

Copy
1npx create-next-app@latest project-name

After creating the project, navigate to the new project folder and start the development server:

Copy
1cd project-name
2npm run dev

Install Prisma Client

Install Prisma and its client library:

Copy
1npm install prisma @prisma/client

Or, if using yarn:

Copy
1yarn add prisma @prisma/client

Configure Prisma Schema

Initialize Prisma to generate the necessary files:

Copy
1npx prisma init

This command creates a prisma folder with a schema file (schema.prisma) and a .env file for environment variables.

Connecting to Your Database

Setup PostgreSQL Database

Ensure PostgreSQL is set up locally or on a cloud platform like AWS RDS or Heroku. Use the connection string format: postgresql://USER:PASSWORD@HOST:PORT/DATABASE.

Update .env File

Add the PostgreSQL connection string to .env:

Copy
1DATABASE_URL="postgresql://USER:PASSWORD@HOST:PORT/DATABASE"

Generating Prisma Client

Run Prisma Init

Copy
1npx prisma init

Generate Prisma Client

After defining your schema, generate the Prisma Client:

Copy
1npx prisma generate

Defining Models in Prisma Schema

Define your models in schema.prisma. For instance, here’s a basic example of a User model:

Copy
1model User {
2  id    Int    @id @default(autoincrement())
3  name  String
4  email String @unique
5  posts Post[]
6}
7
8model Post {
9  id        Int    @id @default(autoincrement())
10  title     String
11  content   String?
12  authorId  Int
13  author    User    @relation(fields: [authorId], references: [id])
14}

Running Migrations

To sync your models with the database:

Copy
1npx prisma migrate dev --name init

Fetching Data in Next.js

Server-Side Rendering (SSR) with Prisma

Use getServerSideProps to fetch data with Prisma for SSR:

Copy
1// pages/index.js
2
3import prisma from '../lib/prisma'
4
5export async function getServerSideProps() {
6  const users = await prisma.user.findMany()
7  return { props: { users } }
8}
9
10export default function Home({ users }) {
11  return (
12    <div>
13      {users.map(user => (
14        <p key={user.id}>{user.name}</p>
15      ))}
16    </div>
17  )
18}

Static Site Generation (SSG) with Prisma

For SSG, use getStaticProps:

Copy
1// pages/posts.js
2
3import prisma from '../lib/prisma'
4
5export async function getStaticProps() {
6  const posts = await prisma.post.findMany()
7  return { props: { posts } }
8}
9
10export default function Posts({ posts }) {
11  return (
12    <div>
13      {posts.map(post => (
14        <p key={post.id}>{post.title}</p>
15      ))}
16    </div>
17  )
18}

API Routes with Prisma

To create API routes for CRUD operations:

Copy
1// pages/api/users.js
2
3import prisma from '../../lib/prisma'
4
5export default async function handler(req, res) {
6  if (req.method === 'GET') {
7    const users = await prisma.user.findMany()
8    res.json(users)
9  }
10}

Handling Database Queries

Querying Data

To retrieve data, use functions like findMany and findUnique:

Copy
1const users = await prisma.user.findMany()
2const user = await prisma.user.findUnique({
3  where: { id: 1 },
4})

Mutating Data

Use create, update, and delete for data mutations:

Copy
1// Create
2const newUser = await prisma.user.create({
3  data: { name: 'Alice', email: 'alice@example.com' },
4})
5
6// Update
7const updatedUser = await prisma.user.update({
8  where: { id: 1 },
9  data: { email: 'new-email@example.com' },
10})
11
12// Delete
13await prisma.user.delete({
14  where: { id: 1 },
15})

Using Prisma Studio

To open Prisma Studio for an interactive interface to manage data:

Copy
1npx prisma studio

Best Practices for Prisma Client in Next.js

Single PrismaClient Instance

Create a prisma.js file in the lib folder:

Copy
1// lib/prisma.js
2
3import { PrismaClient } from '@prisma/client'
4
5let prisma
6
7if (process.env.NODE_ENV === 'production') {
8  prisma = new PrismaClient()
9} else {
10  if (!global.prisma) {
11    global.prisma = new PrismaClient()
12  }
13  prisma = global.prisma
14}
15
16export default prisma

Connection Pooling

Prisma Accelerate or native pooling libraries are helpful for managing connections in serverless environments.

Type Safety

Use TypeScript with Prisma to improve type safety. Prisma automatically generates TypeScript types based on your schema, making data handling safer.

Deploying Your Next.js App

Deployment on Vercel

Deploying Prisma with Next.js on Vercel is straightforward:

1. Add your PostgreSQL credentials to Vercel's environment settings.
2. Follow Vercel’s deployment setup and integrate Prisma Client.

Environment Variables

Use .env for local development. In production, manage variables through Vercel's Environment Variables settings.

Common Issues and Troubleshooting

Exhausted Database Connections

Maintain a single instance of Prisma Client to avoid connection exhaustion:

Copy
1// lib/prisma.js (as defined above)

Schema Exposure in Client-Side

To protect schema details, avoid exposing the Prisma schema directly to the client side, and restrict sensitive data.