This week, I gathered 80+ recipe URLs from Allrecipes.com, with at least 20 recipes in each category of breakfast, lunch, dinner, and dessert and completed the code to connect to the database via the AWS VPC endpoint and store and query recipe data. The recipes are stored in four different tables (one for each category), and each row in the table represents a different recipe, with the columns containing recipe details such as ingredients, title, and execution steps. All interactions with the database are done using a PostgreSQL client from the node-postgres module for NodeJS. I also began implementing the UI for the web app using the Material UI react libraries. So far, I’ve only made the visual elements of the UI, with hardcoded recipe cards displayed, and I will begin implementing routing and interactive elements, such as a form for users to add their own recipes, in the UI next week. The progress is back on schedule.
Github repo (frontend code is in the client/src/pages directory, backend is in server/index.js)