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

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.

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

Supabase Community • Oct 30

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

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...

Thor 雷神 • Oct 30

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

Aleksi Immonen • Oct 30

Excellent guide !

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?

Aleksi Immonen • Oct 30

Excellent guide!