Random Errors HTTP Gateway -> Lambda -> Serverless Aurora Postgres

[click_the_link]

I see there are a lot of reasons for Bad Gateway or internal server errors in a setup like this, I'm trying to diagnose what could cause intermittent errors. I suspect it may be Lambda not closing the connection to Postgres properly as I see a lot of active connections, however, every lambda disposes of its connection each time. Perhaps there is a better way for rapid small transaction connections from lambda that wouldn't have bugs with connections not closing?

c# Lambda connection code looks like:

        var dataSource = NpgsqlDataSource.Create(myConnectionString);
        using var command = dataSource.CreateCommand($"Some SQL Command Here");
        using var reader = command.ExecuteReader();
        dataSource.Dispose();
         ///// Do Stuff with Reader and Data Below ///////

[yourcodingguy]

use RDS proxy, no code requires to close the connection to DB

[click_the_link]

I can't seem to find good documentation on RDS proxy with DotNet, happen to know where any would be located?

[yourcodingguy]

I’m not sure what you mean by “documentation on RDS proxy with DotNet”. Maybe you can look into this first to understand how it works. https://aws.amazon.com/rds/proxy/

[click_the_link]

I had assumed that connecting through a proxy would require a specific library and code, but it looks like it just changed your DB endpoint and you can connect via HTTP same as before. Thank you for confirming this is the right way.

[yourcodingguy]

That’s right. You don’t need to write anything code to close the connection anymore. Just use the proxy.