Error connecting to DB
I am a new supabase user, my idea is as follows: code personal project with nextjs then deploy with vercel, DB use supabase, it works fine on local but when deploy it gets error as below image. Please let me know what should I do. Thanks everyone for your help
3 Replies
Try to use the transaction pooler instead of a direction connection.
Direct connection is for long-lived connections and transaction pooler is for short interactions with the DB
In Supabase -> Connect in the top -> Method -> Transaction Pooler -> Using the shared pooler -> Copy it and paste it in Vercel under env vars
I will try, I will get back to you
it worked, thank you very much. Can you tell me if this change has any impact? (on performance, or DB lifetime, ...) @Timur
No worries, I guess if you burst the Supabase instance it will handle the connection pool more smoothly now compared to before (if we are talking about performance).