Supabase postgres not working sometime
So I'm working on a project using next.js and a simple CMS. Now I wanted to use supabase as a Backend for the project (bacause it has a free tier). To use postgres I decided to go with Prisma. But for some reason the project automatically disconnects from the supabase postgres. Sometime it works sometime it doesnt.
Now I know that this is not enough information. So I tried to find the answer by changing passwords. Restarting supabase project, but it still showing the same stuff after sometime.
I followed the official guide by supabase but the problem still exists.
Is the issue with prisma or supabase or me?
4 Replies
try providing the connection timeout in the database connection URL
&connect_timeout=10
might help
or setting it to 0?
for no timeoutDid you get any specific errors when your app was getting disconnected?
Yupp connection timeout
yeahh it make sense
Let us know in case you are still facing this issue