Sebastian’s Status Report for 3/9/24

Weekly Progress:

• Installed MySQL database onto local machine
  • Able to perform CRUD operations on MySQL command line
  • Below I show an example of an SQL query working on local MySQL DB.
  • 
• Wrote Intro, Testing and Validation, and Summary sections of Design Report

Overall Progress:

Last week I mentioned that I would work on making data persistent on my demo flutter app. I pivoted from that idea since we would like a database on a non-local server that our Sous-Chef webapp will interact with. Therefore, I have decided that for the backend to build out a connector, that will link our front-end flutter app to our MySQL Table that will contain food inventory and other persistent info. The MySQL Connector will be an API built out in Python that will be the backend that Flutter uses to interact with the MySQL database. I am confident that I can get the connector to work with the MySQL database, I am currently not sure how our Dart/Flutter app will connect to the API, I tentatively think using dio or http plugin.

Goals for Next Week:

• Get a working Python Connector with a mockup “food inventory” MySQL DB
• Figure out how Flutter WebApp will talk to Python backend API/Connector