SaasRock uses Supabase as it's PostgreSQL database provider, but there are a few things to be aware of when hosting in a Serverless environment like Vercel.
Seed your remote database or test locally using the following Connection String configuration:
DATABASE_URL="postgresql://{USER}:{PASSWORD}@{HOST}:5432/postgres"
If you deploy your app to a serverless environment, you need to use the Connection Pooling configuration:
DATABASE_URL=postgres://{USER}:{PASSWORD}@{HOST}:6543/postgres?pgbouncer=true
Click here to learn more about this on the Supabase documentation.
Otherwise you could get error the following error:
Remaining connection slots are reserved for non-replication superuser connections
I hope this quick guide was useful! Let me know if you have any questions.
We respect your privacy. We respect your personal privacy.
This website uses cookies to help personalize your online experience. Learn more. This website uses cookies to help personalize your online experience. A cookie is a text file that is placed on your hard disk by a web page server. Learn more