In this project, we created a restaurant operation system that allows the user to take customer orders on table-to-table basis, update the availability of menu items so that servers know what items customers can order, and organize/store customer orders so kitchen staff know what orders to prioritize. What inspired us to build this project was that we have both worked part-time jobs at restaurants, so we understand that dealing with an unorganized restaurant not only is bad for customers, but also stresses out the workers.
We built this project using Python and a relational database, specifically PostgreSQL. Within Python, we connected the file to the relational database so that updates can be made to the tables within the database, which includes the item menu and orders made. These updates would be shown in a streamlit website, which acted as the restaurant operation system. In the streamlit, the user (workers) would configure buttons such as updating availability which then updates the specific table from the database in real time. Additionally, an API was implemented so that multiple devices can not only access the system, but can also send requests within the streamlit website, resulting in table updates and proper outputs to the website.
The main challenges we came across was setting up the API and fixing the improper layout of the streamlit website. Despite these challenges, we overcame them and were able to create a finalized system that is able to commit functions proper for a restaurant to operate. What we took away from this project is how APIs are used to take requests and how to organize a UI system.
Built With
- flask
- postgresql
- python
- streamlit
Log in or sign up for Devpost to join the conversation.