Supabase

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.

Development Connection String

Seed your remote database or test locally using the following Connection String configuration:

DATABASE_URL="postgresql://{USER}:{PASSWORD}@{HOST}:5432/postgres"

Production Connection String

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

Supabase Documentation

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.