I first tried to create a provisioned server database on RDS, but I couldn't figure out the security to make a connection from Lambda. Instead I went the simpler route and used Aurora Serverless to build a database cluster I could access via the Data API.
See #9
I first tried to create a provisioned server database on RDS, but I couldn't figure out the security to make a connection from Lambda. Instead I went the simpler route and used Aurora Serverless to build a database cluster I could access via the Data API.
https://stackoverflow.com/questions/35468372/using-boto3-to-interact-with-amazon-aurora-on-rds ^CDK instructions to build the Aurora MySQL database and enable permissions to access from Lambda
https://stackoverflow.com/questions/35468372/using-boto3-to-interact-with-amazon-aurora-on-rds ^Inspiration for the Output Generator's Insert and Query statements.
https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/rds-data.html#RDSDataService.Client.execute_statement ^The documentation for the Data API using boto3