Edge Functions, Remix, Drizzle connecting nightmare HELP
Constanly getting errors like "remaing connections reserved..." "Max Client connections limit reach" "Write access timed-out".
I've tried multiple solutions.
But i know im still just missing something...
For example. I notice for my role i have 9 active connections, and then when i run an edge function that is connecting via this URL
DATABASE_URL="postgres://postgres.[xxx]:[password]@aws-0-us-west-1.pooler.supabase.com:6543/postgrse?connection_limit=1&pgbouncer=true"
After the end of the edge function running, i then have 24 connections
Anyone have an idea of why 15 new connections are being spun up even though i have the connection_limit set to 1??
Any help would be gratefully appreciated, and I will even leave in my codebase a comment about how you are my savior
I've tried multiple solutions.
But i know im still just missing something...
For example. I notice for my role i have 9 active connections, and then when i run an edge function that is connecting via this URL
DATABASE_URL="postgres://postgres.[xxx]:[password]@aws-0-us-west-1.pooler.supabase.com:6543/postgrse?connection_limit=1&pgbouncer=true"
After the end of the edge function running, i then have 24 connections
Anyone have an idea of why 15 new connections are being spun up even though i have the connection_limit set to 1??
Any help would be gratefully appreciated, and I will even leave in my codebase a comment about how you are my savior
