Week 5 Worklog

Week 5 Objectives:

  • Deploy and manage cloud databases using Amazon RDS.
  • Apply cost optimization strategies for database storage.
  • Successfully integrate an ORM tool to synchronize data between local and server environments.

Tasks to be implemented this week:

DayTaskStart DateEnd DateResources
MonSet up and tested direct connections from the local machine to Amazon RDS.02/02/202602/02/2026Personal Practice
TueResearched RDS cost reduction strategies; decided against Multi-AZ to fit the testing phase budget.03/02/202603/02/2026AWS Cost Optimization
WedInstalled and configured Prisma ORM locally; tested user data query flows.04/02/202604/02/2026Prisma Documentation
ThuDeployed Prisma on the EC2 instance; configured network and security settings to successfully connect EC2 and RDS.05/02/202605/02/2026AWS Documentation
FriStarted researching Amazon S3 (Simple Storage Service) to prepare for hosting static assets (cosmetic product images, system files).06/02/202606/02/2026AWS Documentation

Week 5 Achievements:

  • Effective Database Management: Built a logical workflow for connecting and interacting with Amazon RDS, optimizing performance.
  • Cost Optimization: Understood the financial impact of configuration options (like Multi-AZ) and eliminated unnecessary settings to save budget.
  • Workflow Standardization: Successfully configuring Prisma ORM and the EC2-RDS connection established a standard, understandable process, allowing any team member to contribute.