ShelfChecker

This project was made for the module Project I during my NMCT bachelor degree. The goal was to make a smart object using a Raspberry Pi. We also had to write a matching website. ShelfChecker got displayed at a local exposition, called IoT Fest, and on several other occasions. But what is this project exactly? Since I love to read, I obviously choose to make a smart bookshelf. This bookshelf keeps track of to whom you borrowed your books and how many times they got borrowed. On top of this, it also helps you to keep your books organised because a helpful NeoPixel LED strip tells you whether you placed a book on the right place. I am proud to be able to say ShelfChecker got featured on both Instructables (with almost 7000 views!) and on the official Raspberry Pi Blog. Check out the link below if you don't believe me (I couldn't believe it myself) or take a look at some extra pictures on this page.
Client : SchoolDate : June 2017Technologies : Arduino, CSS, Flask, HTML, MySQL, Python
Here you can see the original concept compared to how ShelfChecker ended up eventually. As you can see, I planned to build separators between the books but ended up deciding against it and just used some metal hooks instead. This made it possible to place all kinds of books onto the shelf, either small or big, short or tall. The presence of books gets detected by light sensors. If a light sensor doesn't receive any light, it means a book is present. The shelf is constantly monitoring a change of light so the database can be updated accordingly. To find out more about the database, read on below.
Here you can see the accompanying website. The making of the smart bookshelf took three weeks, therefore this website was made in only one week. I researched the fonts most used in books (Baskerville, Sabon, Garamond, Caslon and Utopia) and based the website on this. The website also got inspired by GoodReads to create the same atmosphere of calmness. To see which books are available, this website is coupled with a MySQL database. Both the database and the MySQL database are hosted on the Raspberry Pi, so a live demo is unfortunately impossible. I hope you enjoy the screenshots! (Tip: if you click them, you can see a bigger version.)