I noticed that the Serverless deployment docs mention setting the production database URL in the environment variable rather than including details on how to create a database in AWS.
Obviously this is because creating an RDS database in AWS is a relatively big task that requires a bunch of skills.
However I think there is definitely a solid argument for making it easy to host the entire Redwood stack from DB to frontend on AWS. There are a lot of reasons why a project might require or prefer hosting soley on AWS but I won’t make that argument here and instead assume it is a widely held view.
In addition AWS Aurora Serverless V2 has recently become generally available (April 2022) and has some great features which make it a solid option for a low maintenance database.
So the discussion I’d like to start is about adding a deployment plugin that leverages the popular AWS CDK infrastructure as code project as well as the new Serverless Stack (SST) project.
Also worth noting is that you can use the RDS proxy with Aurora Serverless V2 ( from the docs )
You can use RDS Proxy with Aurora Serverless v2 clusters but not with Aurora Serverless v1 clusters.