Database Enhancements Features Progress Timeline

Project (Database Enhancements) Timeline

Week 1: Planning and Preparing Phase

August 15

• Initial brainstorming for the web application
• Looked at developing a client that could "drop" pins on a map for interaction with the database

August 16

• Finialized decisions for languages to be used
  • Client-side: JavaScript
  • Server-side: Python

August 17

• Introduction and deep dive into Leaflet.js
  • Reviewed Quick Start guide and related tutorials

August 19

• Introduction and deep dive into Flask
  • Reviewed Quick Start guide and related tutorials

Week 2: Development Phase

August 21

• Client-side progress
  • implemented map display
  • established event listeners for map interactions

August 22

• Modularized the application
  • Introduced two operational modes: Click Mode and Explore Mode
  • Structured HTML containers specific to each mode

August 23

• Feature additions
  • Incorporated drop-down menus for attributes continent & month and introduced text-box entry for year.
  • Finalized basic development for Click Mode

August 24

• Progress with Server-side implementation
  • Integrated with MySQL database
  • Executed and tested database queries
  • Ensured map markers were operational and visible

August 25

• Database transition and frontend enhancements
  • Shifted database to AWS RDS and verified connection.
  • Introduced visual enhancements: boundary demarcations and interactive sliders.

August 26-28

• Creating an EC2 instance in AWS to store the web app on an AWS server
• Testing the App, Debugging, and Documenting Progress