Nevera Smart Fridge

I am a student NMCT at Howest Kortrijk (Belgium) and as a part of the exams we had to make a final project. I made "Nevera", a tool to help you remember everything that’s in your refrigerator. With the help of a barcode scanner, you’ll have to scan the products that go in and out your fridge. These products will be stored in a MySQL database and shown on a website, so you’ll always know what’s in your fridge. On the website you’ll also find a shopping list, where you can add or remove products you have to get from the grocery store, and there’s also a page where you can analyse the previous temperatures inside your fridge.

You can find my porfolio here.

·

• 1 x Rasperry Pi 3
• 1 x SD Card
• 1 x USB Barcode Scanner
• 1 x LCD Display
• 1 x Potentiometer
• 1 x Temperature sensor
• 1 x Breadboard
• Resistors 10kOhm
• Wood and tools

You can see a good overview of the wiring on the pictures above or in the attachment called Nevera_schema.fzz. The .fzz extension can be executed in the program Fritzing, which is free.

The USB-port from the Raspberry Pi is connected with the USB from the barcode scanner.

This is my normalized database in MySQL. It exists of 6 tables:

Product: Here you’ll find the data of all possible products.

Frigo: Here you’ll find all the fridges, so you can have more than one fridge.

Sensor: Here you’ll find your sensor.

Producten_in_frigo: Here you’ll find the information about all the products that are actually in your fridge.

Sensor_in_frigo: Here you’ll find the measured data from the temperature sensor inside your fridge.

Boodschappenlijst: Here you’ll find the data from on the shopping list.

First I made a mobile design in Adobe XD, where I chose my color scheme and the fonts I wanted to use, so I could figure out how I wanted my website to look.

Then I tried to recreate this in html and css to a responsive website.

After the design, I had to import real data into my website by using Flask and MySQL. I also read my data from my temperature and showed it in a chart.

Here is my code:

https://github.com/NMCT-S2-Project-I/project-i-Judithvanass

I used some wood that originally was a drawer from in a box we didn't use anymore. My neighbour cut this in half and used the other half as a roof. We drilled some screws in, to make sure everything stayed in place. Then he cut out a hole the size of my lcd-display. At last he drilled a hole in the front, that I scraped out to a bigger hole for more cables. To close the whole thing he drilled two little holes on the back, so I can open and close it by just turning some screws in the wood.

This is not an exact design, you can put your project in any box you want.