KC

SQLifting

Exercise smarter with a personalized exercise and workout plan building application, packed with analytic and social features

The Process

When starting this project I had one goal in mind, to expand my abilities working with structured databases. I chose MySQL because of the tried and true user experience. Additionally, this project allowed me to explore more services in the AWS cloud ecosystem. For this project, I utilized the Relational Database Service (RDS) service.

To start, I designed a simple front-end interface to display the data I would be rendering. Next, I spun up my express server, connected the database and started writing my first queries. Hitting the server routes and seeing my queries run for the first time was empowering. I developed much more appreciation for backend development. Throughout my work, I realized how to optimize my queries and improve how I architect the database, which is the most important aspect to me. This app, originally meant to practice querying with SQL, became one I use daily.

Reflection

  • Developed skills working with a structured database
  • Learned more about the AWS cloud ecosystem and services it offers
  • Improved skills writing dynamic functions that do more with less code
  • Became more fluent with data manipulation and working with complex objects
  • Technology Stack

    ReactSASSExpressjsAWS RDSMySQL

    Resources

  • https://www.postgresql.org
  • https://aws.amazon.com/rds
  • Explore