How to use an RDS instance or Aurora instead of DynamoDB?

noobCSguy · November 14, 2020, 11:10pm

Hello everyone,

Serverless-stack has been awesome and for my application, I am going to be using a SQL database(specifically MySql) with RDS. I was wondering how I would go about this using serverless-stack. What kind of changes must be made in the back end APIs? I was thinking about putting my RDS connection above each of the files(Ex.create.js,list.js…). Any changes in the serverless.yml file? I’m just trying to replicate that seamless integration with AWS except I just need a relational db instance spun up.

Sincerely,
a fellow user

jayair · November 22, 2020, 7:07pm

Yeah that’s basically right. You just have to put the connections outside the Lambda functions. I think this part would be different as well:

github.com

AnomalyInnovations/serverless-stack-demo-api/blob/master/services/notes/serverless.yml#L33


region: us-east-1
# These environment variables are made available to our functions
# under process.env.
environment:
  stripeSecretKey: ${env:STRIPE_SECRET_KEY}
  tableName: !ImportValue '${self:custom.sstApp}-TableName'
# 'iamRoleStatements' defines the permission policy for the Lambda function.
# In this case Lambda functions are granted with permissions to access DynamoDB.
iamRoleStatements:
  - Effect: Allow
    Action:
      - dynamodb:Scan
      - dynamodb:Query
      - dynamodb:GetItem
      - dynamodb:PutItem
      - dynamodb:UpdateItem
      - dynamodb:DeleteItem
      - dynamodb:DescribeTable
    # Restrict our IAM role permissions to

Topic		Replies	Views
Using RDS instead of Dynamodb?	1	921	January 26, 2019
iamRoleStatement for RDS (mysql) Chapter Comments	1	592	June 8, 2018
DynamoDB as a Serverless Service Chapter Comments	11	1176	February 22, 2020
Error: is not authorized to perform: dynamodb:Query :(	4	4948	August 24, 2020
Deploy the Resources Repo Chapter Comments	4	717	November 12, 2020

How to use an RDS instance or Aurora instead of DynamoDB?

Related topics