© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•3y ago•
1 reply
Jay Bell

Prisma + Supabase (Supavisor) connection pooling

If I am using Prisma in my servers (not serverless, running Docker containers on fly.io should I use the Connection Pooling string or the Direct Connection string? The docs say use pooling if using Prisma but also say only for serverless.

Additionally Prisma says to run
pgbouncer
pgbouncer
in transaction mode for the most reliable functionality but Supabase says that prepared statements are not available in
transaction
transaction
mode (but are in
session
session
mode). Prisma uses prepared statements internally. I am assuming that I want to run it in session mode (if I use the connection pooling).

So 2 questions:
1. do I use connection pooling? (We would have 4 different servers connecting to the DB)
2. If I do, should I use
session
session
mode since Prisma requires prepared statements?
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Connection Pooling & Prisma
SupabaseSSupabase / help-and-questions
4y ago
Use connection pooling with supabase-js
SupabaseSSupabase / help-and-questions
4y ago
General Question on how to switch to connection pooling / supavisor
SupabaseSSupabase / help-and-questions
3y ago
Connection pooling issues in self-hosted Supabase
SupabaseSSupabase / help-and-questions
3mo ago