Eternally Fresh

• 

  Landing Page

• 

  Customer Log In

• 

  Customer Home Page After Logging In

• 

  Adding a New Item By Entering the Barcode Number

• 

  All Recipes Available for this Customer

• 

  Creating your Own Recipe

• 

  Moderator Home Page

• 

  All Items Page for Moderator to review

Inspiration

Going into the freezer at home and finding food that I am about to put into the oven before seeing it is 2 years out of date and being sad that such good food has gone to waste

What it does

Tracks how close your food is to expiring and shows it on the front screen while also suggesting recipes that use the most amount of your nearly expired food with extra weighting towards food that you still have an excess of.

How we built it

Front end is HTML CSS and static JavaScript Middleware is done through Express.js to route the data properly Backend is node.js connected to PostgreSQL through the pg npm package

Challenges I ran into

PostgreSQL requiring "" around table or column name if there is a capital causing 90% of the bugs for the first 6 hours or so. Also, my program suddenly deciding a client connection was not good enough so having to refactor all my SQL functions into using a pool instead after I had just finished them all.

Accomplishments that I am proud of

Eternally Fresh working with even more functionality than I was originally hoping to get in 25 hours going into it.

What we learned

The difference between MySQL and PostgreSQL generally and especially when using node.js.

What's next for Eternally Fresh

Adding in shopping list estimation by adding a table of customer logs for how often they have certain foods and adding it to a shopping list when the rate they are consuming it means that they will need to replace it soon. If there is enough data and customers this would be done using Machine Learning instead of just estimating it using rate of change.

Built With

• css
• express.js
• html5
• node.js
• pg
• postgresql