• python 3.9
• pipenv
• mysql-server

• Install python packages.

pipenv sync 

• Create restaurant_supply_express database.

mysql> source path/to/schema.sql;

• Add procedures to database.

mysql> source path/to/procedures.sql;

• Create secrets.toml by copying the secrets.toml.sampleand set the password of the mysql root user.

• Activate pipenv virtual environment.

pipenv shell 

• Start application.

streamlit run src/app.py

Streamlit is a low-stake frontend tool, that requires not prior experience in frontend development.

Streamlit library that adds support for multiple layouts; in our case private and public layouts. The public layout is used for authentication and login; the private layouts are used to enforce role-based access control.

Python package used to connect to mysql database and execute queries.

streamlit-book template