DEV Community

Prisma + Postgres

awalias on October 30, 2024

In this tutorial, we'll explore how to set up Prisma + Postgres. We'll use real-world examples involving books and authors. Prerequisites...

Read full post

awalias • Oct 30 '24 • Edited

If anyone needs help regarding Prisma / Postgres you can get support in our discord

Joshen Lim • Oct 30 '24

Hopefully this might be helpful - there's a set of handy instructions on your projects' home page if you click the "Connect" button and select the "ORMs" tab

Supabase • Oct 30 '24

Yes! Thanks for sharing @joshenlim

Steve_Val • Oct 30 '24

The memes in there are crazy lol

Also note for anyone else who's wondering the official Prisma documentation related to this is here: prisma.io/docs/orm/overview/databa...

The important step adding

datasource db {
  provider  = "postgresql"
  url       = env("DATABASE_URL")
  directUrl = env("DIRECT_URL")
}

Very nice.

swamp_dog • Oct 30 '24

I was trying initially without the direct_url but apparently it's required if you need to do migrations.

Supabase Community • Oct 30 '24

Prisma Postgres is an incredible pairing for a backend. Both tools are used and loved by the Supabase Community.

Chris • Oct 30 '24 • Edited

thanks for this! If I am using a pooler like Supavisor does that mean I do not use Accelerate or anything, just the Prisma library and Supabase handles the rest?

Tyler Fontaine • Oct 31 '24

Bingo! You got it

Aleksi Immonen • Oct 30 '24

Excellent guide !

Aleksi Immonen • Oct 30 '24

Excellent guide!

Qian Li • Nov 5 '24

Thanks for the starter tutorial -- it's clear and simple. Things can get tricker if you modify the schema and want to actually push to production:

prisma migrate dev is only for dev environment. Use npx prisma migrate deploy for production and testing (CI/CD pipelines). Docs
Run npx prisma generate to generate new client code whenever you modify the schema as well.

Also, I noticed that Prisma doesn't really support rolling back schema changes. So to revert changes you need to revert your schema file and generate a "new" migration/client to undo the previous change instead.

Dave • Oct 31 '24

This is great!

Subham • Nov 6 '24

Interesting guide, but honestly, why go through all this setup with Prisma + Postgres when you could use Drizzle ORM? Drizzle is so much cleaner and more TypeScript friendly without all the heavy migration overhead.

Wen Bo Xie • Oct 31 '24

Excited to use Prisma and Supabase together! This makes it so easy to get started and distinguish between which database connection strings to use and why.