Posts

Showing posts with the label typeorm

Guide to using AWS RDS public endpoint

Image
Introduction In the previous article, I introduced the basic concepts of AWS RDS as well as how to securely connect using a tunnel; you can review it to grasp the necessary information before proceeding. In this article, I will guide you through creating an RDS Postgres with public access, meaning this database can be accessed from any computer. This method may be considered less secure than the previous one, but it is useful when you need to share database connections with many users during the development process who do not have an AWS account to connect via a tunnel. Detailed Instructions Using AWS CDK, create the file lib/rds-public-stack.ts import * as cdk from "aws-cdk-lib" import * as ec2 from "aws-cdk-lib/aws-ec2" import * as rds from "aws-cdk-lib/aws-rds" import * as secretsmanager from "aws-cdk-lib/aws-secretsmanager" import * as ssm from "aws-cdk-lib/aws-ssm" export class RdsPublicStack extends cd...

Guide to Using AWS RDS

Image
Introduction Amazon RDS (Relational Database Service) is a fully managed relational database service provided by Amazon Web Services. It makes it easy to set up, operate, and scale popular databases in the cloud without worrying about hardware management or complex software installation. Key advantages Automated Management & Time Saving RDS automates time-consuming administrative tasks such as: Installation & Configuration: Launch a database with just a few clicks. Patching: Automatically applies security patches and software updates. Backup: Automatically performs daily backups and allows point-in-time recovery within 35 days. Flexible Scalability Vertical Scaling: Easily adjust CPU and RAM resources to match workload demands. Horizontal Scaling (Read Replicas): Create read-only replicas to offload traffic from the primary database, improving performance for read-heavy applications. High Availability & Reliability Multi-AZ Deployment: RDS automatically replicates data to a...