Aurora Database Setup

Having been on the development side of Aurora, I’ve been curious about how customers use Aurora databases. Here’s a quick tutorial on it: Step 1: Create Aurora PostgreSQL Cluster Via AWS Console: Navigate to RDS Console Go to AWS Console → RDS → Databases Click “Create database” Database Creation Method Select “Standard create” Engine Configuration Engine type: Amazon Aurora Edition: Amazon Aurora PostgreSQL-Compatible Edition Version: Aurora PostgreSQL 15.4 (or latest available) Templates ...

March 1, 2025

OpenAI Web App

First, decide the high-level stack. For frontend, do you want React/Vue or simple HTML/JS/CSS? I have chosen FastAPI (Python) for backend and React (Next.js) for frontend, hosting on EC2 and potentially use Nginx in future Launch an EC2 instance, recommended to use t3.small or above (I faced OOM issues using t2.micro free tier) Choose Ubuntu 22.04 LTS as the OS. Configure default security groups. Also allow all traffic on port 8000 for FastAPI If you want to use EC2 instance connect, be sure to allowlist the ec2 instance connect CIDR on port 22, e.g. for PDX the CIDR is 18.237.140.160/29 Connect to EC2 instance and install dependencies ...

February 9, 2025