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.
Step 1: Materials
- 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
Step 2: Wiring
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.
Step 3: Database
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.
Step 4: Website
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:
Step 6: Housing
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.