Nevera Smart Fridge

Intro: 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.

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.

Step 5:

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

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.

Share

    Recommendations

    • Metalworking Contest

      Metalworking Contest
    • Tiny Home Contest

      Tiny Home Contest
    • Fix It! Contest

      Fix It! Contest

    Discussions

    0
    None
    DIY Hacks and How Tos

    3 months ago

    Good idea for keeping track of what goes in and out of your fridge.