Prisma•3mo ago

Supabase with Pulse and Accelerate

Hi! I am setting op Supabase in combination with Fly, Pulse and Accelerate. I received two URLS: A connection pooler URL A direct URL I have set this in the schema like this

url               = env("DATABASE_POOLER_URL")
directUrl         = env("DATABASE_URL")

url               = env("DATABASE_POOLER_URL")
directUrl         = env("DATABASE_URL")

However, I used the direct url (the one with port 5432) to setup Accelerate and I got back a prisma database url. Should I know replace the direct url with this new prisma://accelerate.prisma-data.net/ ? So it would result in this:

url               = url to connectionpooler Supabase
directUrl         = the prisma://accelerate.prismadata.net url

url               = url to connectionpooler Supabase
directUrl         = the prisma://accelerate.prismadata.net url

2 Replies

Nurul•3mo ago

Your url value should be the one that you got back from Accelerate (starting with prisma:// one) and directUrl should be the Supabase one with port 5432

DennisKOP•3mo ago

All right. So there is no connection pooler connection anymore since I also used the 5432 one to connect Supabase with Accelerate. Leaves the question: What is this connection pooler (the one of Supabase) actually doing? I am missing the knowledge so just asking 🙂 And will it be compatible with Prisma in the near future?

Gaming

Programming

Supabase with Pulse and Accelerate