I don't know about you but I love saving money. So, recently I have been taking a look at the spending habits in my home and trying to find ways to help us make better decisions about what we buy and as a result save money. That brings us to this project, an area that needs a complete make-over is our pantry, refrigerator, and grocery management. We spend way too much on stuff we already have, and a lot of it ends up going to waste.
Enter the Home Pantry Management Server aka HPMS. This is quite literally a SQL server running a database that keeps track of what we have in the pantry, refrigerator, and freezer, how much of it we have, when the expire date is, how much the item costs, and possibly some other information depending on how much time I have.
How It Works
But what does it do? Couldn't anybody set up a server and track their groceries? What makes this one special? The answer to that first question is in the paragraph above and also sort of answered in the second question. Yes, anybody could set up a server or even an excel sheet to do this which brings us to the last question. This one is special because of a few extra integrations. The main thing is the Android app that allows you to either manually enter info into the database or scan the info in with the barcode. the second is the two laptops that will also be able to interact with the server. One of those laptops will be a remote terminal allowing me to access the server and make any software adjustments and the second belongs to my grandmother (who does most of the shopping list making) and will allow her to view the information in a nice list format letting her know what we have, what we need, the price of everything, and to create a shopping list based on all the information.
How do you plan to go about all this? First off, why do you ask so many questions? Second, thanks for asking!!! The server is going to be on a Raspberry Pi Model 3 with a 16gb Class 10 micro sd card running Ubuntu Server. It will be connected to the router via ethernet cable which will make it slightly easier so I don't have to connect it to wifi and also wifi isn't the best option for servers. I'm using Ubuntu Server because it's an enterprise grade server os and it's free, you can't beat that. The mobile app will be developed using Unity and some extra code written in C# using Visual Studio Community 2017 ( I couldn't choose that above so I just went with the closest thing.) Both computer applications will probably be done the same way as the mobile application just reworked for you know... computers. For now that explains most of my project I just wanted to get this set up for when I do start working on it (I don't currently have the Raspberry Pi I am trying to get one) Thank you.