BoManev/streamlit-mysql-app

Dashboard application created using streamlit.py and designed using data-drive approach. No ORM.

Prerequisites

• python 3.9
• pipenv
• mysql-server

Installation

• 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

Dependencies

streamlit

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

streamlit-book

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.

mysql-connector-python

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

Acknowledgments

streamlit-book template