Using Lambda and RDS is really a let down with the VPC issues (see: https://rubyonjets.com/docs/considerations/vpc/). @tung I just wanted to put this on your radar if it isn’t already. There is hope with the AWS Data API which is generally available only for MySQL Aurora Serverless. Hopefully we get PostgreSQL soon. Serverless Aurora would really take things to the next level.
I’m interested also to improve the way to work with aurora serverless, I’ve been talking with aws support, and to run the migrations we can do that from an ec2 with our correct vpc configuration because aurora in serverless mode doesn’t have a public ip.
@dkobia The Aurora Data API is interesting. Sounds like someone just needs to write a decent library for it Then woudn’t need to use the VPC config for Aurora.