Drizzle with node-postgres driver pooled connection hangs forever after some requests
Hi everyone. I'm using drizzle-orm node-postgres driver with pooled connection, after some requests to the database, it varies sometimes in frequency then subsequent request/connection to the database hangs forever and i then have to restart my server again to connect to the database. I'm using neon database free tier and it goes inactive after about five minutes but i expect the server to still be able to reconnect to the database when new request finally comes in but this happens even before the neon database goes inactive. I read the docs for pooled connection with node-postgres and i saw after queries, the client is meant to be released back to the pool, i don't know if drizzle does this under the hood and maybe it's the cause of my problem.
my connection code in nestjs
my connection code in nestjs



0 Replies