Supabase

  • Author
    by Admin User
    3 months ago
  • 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
    
    Connection slots error

    I hope this quick guide was useful! Let me know if you have any questions.

    We respect your privacy.

    This website uses cookies to help personalize your online experience. Learn more.