Guidance progressing beyond the example

[jlag34]

Hi Matt,

I'm migrating off AWS Aurora PG to Heroku PG and found your article you wrote in 2019, using the code from this repo. I'm basing my Serverless Framework API around this example but I'm running into issues due to hanging calls and/or pool errors.

1. If I don't use await pgPool.end(), my API calls will hang
2. If I use await pgPool.end() it will work once, then I will run into this error: Cannot use a pool after calling end on the pool

I made a post on Stack Overflow here and I was wondering if you could take a peak at it. Mostly around when to open/close the connection to the database to prevent hanging calls and/or the pool error.

Thanks,
Joe