What is RDS ?
Amazon Relational Database Service (RDS) is a managed database service provided by Amazon Web Services (AWS) that simplifies the setup, operation, and scaling of a relational database in the cloud. It offers cost-efficient and resizable capacity while automating time-consuming administration tasks such as hardware provisioning, database setup, patching, and backups.
RDS supports several database instance types - optimized for memory, performance, or I/O - and provides six familiar database engines to choose from, including:
Amazon Aurora
PostgreSQL
MySQL
MariaDB
Oracle Database
SQL Server
What is Dynamodb?
DynamoDB is a fully managed NoSQL database service provided by Amazon Web Services (AWS) that is designed for speed and flexibility. It supports both key-value and document data models, making it a versatile choice for a wide range of applications. Here are some key features and concepts related to DynamoDB:
Fully Managed
Performance at Scale
Flexible Data Model
Security
Global Tables
Provisioned and On-Demand Capacity
Use Cases: It's suited for a variety of applications, including mobile apps, gaming, IoT, and others that require low-latency data access at any scale.
What is AWS Lambda ?
AWS Lambda is a serverless compute service provided by Amazon Web Services (AWS) that allows you to run code without provisioning or managing servers. With Lambda, you can execute code for virtually any type of application or backend service with zero administration. Just upload your code, and Lambda takes care of everything required to run and scale your code with high availability. You can set up your code to automatically trigger from other AWS services or call it directly from any web or mobile app.
How to use lambda function to insert value and delete values in table using lambda function?
Firstly create a table using dynamodb. Enter name of table and partition_key.
The partition_key (also known as the hash key) is a core component in the architecture of many distributed data stores, including Amazon DynamoDB. Its primary purpose is to ensure data distribution across multiple nodes for scalability and availability.
Now search for lambda function service in aws dashboard and create a function as following values. and create a function.
now you can able to see a dasboard like below:-
now in configuration go to permission and edit that select the role which you have created using IAM role to access dynamodb. and save the details.
after that write the code as below :-
CODE TO INSERT VALUES IN TABLE USING EVENT
import json import boto3
Initialize a boto3 client for DynamoDB
dynamodb = boto3.resource('dynamodb', region_name='us-east-2') # Specify your region table = dynamodb.Table('Student')
def lambda_handler(event, context): # Example event: { "student_id": "123", "name": "John Doe", "age": 20, "major": "Computer Science" }
# Insert the student record into the DynamoDB table response = table.put_item(Item=event)
return { 'statusCode': 200, 'body': json.dumps('Student record inserted successfully!') }
Now when you write the code and try to test it will create an event by which we can add the values in table.
as you can status is succeeded that means our code run successfully.
now go to dynamodb you will be able to see added values in table.
Now i am adding more values to show how can we delete the values.
CODE TO DELETE VALUES IN TABLE WITHOUT USING EVENT
import boto3
Initialize a boto3 client for DynamoDB
dynamodb = boto3.resource('dynamodb', region_name='us-east-2') # Specify your region table = dynamodb.Table('Student')
def lambda_handler(event, context): # Specify the student_id of the item to delete student_id_to_delete = '1' # Change this to the ID of the student you want to delete
# Delete the item from the DynamoDB table response = table.delete_item( Key={ 'student_id': student_id_to_delete } )
return { 'statusCode': 200, 'body': f"Student with ID {student_id_to_delete} deleted successfully." }
FOR NOT USING EVENT IN FUNCTION YOU HAVE TO SPECIFY WHICH VALUE TO BE DELETED. BUT IF YOU WANT TO DELETE VALUES IN LARGE NUMBERS YOU CAN USE EVENT AS BELOW
import json import boto3
Initialize a Boto3 client for DynamoDB
dynamodb = boto3.resource('dynamodb', region_name='us-east-2) # Adjust the region accordingly table = dynamodb.Table('Student')
def lambda_handler(event, context): # Assume event contains {"student_id": ""} student_id = event.get('student_id')
# Delete the student record from the DynamoDB table response = table.delete_item( Key={ 'student_id': student_id } )
return { 'statusCode': 200, 'body': json.dumps(f'Successfully deleted student record with ID {student_id}') }
As you can see he code is Successfully executed now student_id:3 is deleted from table of dynamodb.
Thank You all for reading till here.
I hope you liked it 😊.