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.