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 • Edited

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

Joshen Lim • Oct 30

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

Yes! Thanks for sharing @joshenlim

Steve_Val • Oct 30

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

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

Supabase Community • Oct 30

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

timnpalmer • Oct 31

AMAZING!!

Thor 雷神 • Oct 30

You can also find some details on using Row Level Security (RLS) with Prisma here: supabase.com/partners/integrations...

Jon • Nov 1

This is an absolute game changer!

Tyler Hillery • Oct 31

Prisma + Supabse is an awesome combo.

Tyler Hillery • Oct 31

The discord is very welcoming to new comers!

Chase Granberry • Oct 31

💚 Prisma + Supabase

Julien Goux • Oct 31

Prisma and Supabase are really a great fit. Great combo!

Deji Ibrahim • Oct 31

Easy to setup 👌, thanks!

David Wilson • Oct 31

yes yes yes

Lee AVULAT • Oct 30

Nice guide. I would add that if you want to use prisma to generate migrations. For those to be usable with supabase-js and postgrest I recommend to leverage the native database functions in your "id" definitions like mentioned here: github.com/supabase/cli/issues/277...

Joel Lee • Oct 31

Thanks, will check it out

Jon • Nov 1

This is so sick! 💯

Tyler Shukert • Nov 1

I know a lot of apps built with this combination!

Greg Richardson • Oct 31

Super seamless, nice 😃🚀

Francesco Sansalvadore • Nov 1

Prisma + Supabase is the perfect combo.

Karlo Ison • Oct 31

Awesome! 🤩

SupaDavid • Oct 31

awesome

Chandana Anumula • Nov 2

This is great!!

Jessica Shears • Oct 31

This is awesome!

Paul C • Nov 1 • Edited

Supabase and Prisma is the perfect match for us, it makes life so easy to build things quickly.

abc3 🇺🇦 • Nov 2

Supabase and Prisma makes development so much easier. Love this combo

flutter_for_life • Nov 1

Nice share!

Alexander Korotkov • Nov 2

Brilliant, thank you!

Raminder Singh Sidhu • Nov 3

Thank you so much, this is what I was looking for. A great guide to setup Prisma with Postgres.

Raminder Singh • Nov 3

I was just trying out setting up Prisma with Postgres and found this guide. Thanks for writing this.

Guilherme Souza • Nov 4

That is awesome!

Alexander Korotkov • Nov 2

Thank you!

Sreyas Udayavarman • Nov 4

Thankyou!

Illia Basalaiev • Nov 3

This is amazing! 💪💪

Kamil Ogórek • Nov 5

Always happy to help

samrose • Nov 3

Thank you so much. I wish I had known how easy this was in the past. Grateful for this resource!

Chris • Oct 30 • 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

Bingo! You got it

Aleksi Immonen • Oct 30

Excellent guide !

Qian Li • Nov 5

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.

Aleksi Immonen • Oct 30

Excellent guide!

Dave • Oct 31

This is great!

Subham • Nov 6

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.

Jon • Nov 1

What an incredibly powerful stack! Prisma and Postgres powered by Supabase! 🚀

Wen Bo Xie • Oct 31

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.

timnpalmer • Oct 31

Super valuable guide, thanks

Sreyas Udayavarman • Nov 4

This is great! Easy to setup.