Recommended Connection Settings For AWS Lambda?

[bestickley]

Hi, love this package! Makes queries a breeze. I'm using this in AWS Lambda. Does anyone have any recommendations for optimal connecting settings that don't hold on to connections too long which aren't ideal for a "serverless" environment? Ideally, I'd like something like sql.end() like from [serverless-mysql] (https://github.com/jeremydaly/serverless-mysql) which does "connection management".

Thank you!

[bestickley]

Based on How To: Manage RDS Connections from AWS Serverless Lamda Functions reducing the max_timeout to 10 minutes is maybe a start?

[porsager]

Thanks a lot 😊

You'll properly know best based on your functions requirements, but setting idle_timeout to 0 will effectively close the connection as soon as no queries are queued. If you do several queries with other work inbetween perhaps 30 seconds is a good value.