AWS for Developers: RDS MySQL Database with Lambdas

Learn how to leverage RDS (relational databases) for MySQL Database with Lambdas.

Introduction

• Lambda access to RDS MySQL
• What you should know

1. AWS RDS MySQL Database

• AWS account and console
• RDS and costs
• Creating a MySQL database
• Accessing the database
• Creating a database table

2. Node.js Project

• Initialize a Node.js project
• Adding MySQL
• Using a separate config file
• Creating a DB connection
• Running a query locally

3. Lambda

• Lambda basics
• Converting code to Lambda
• Uploading the Lambda
• Testing the Lambda
• Promisify to clean up

4. SQL Queries

• Query rows
• Insert rows
• Delete rows
• Update rows
• Passing in data
• Calling Lambdas

Conclusion

• Next steps