/Streamlit-SQLAlchemy

Streamlit example project with SQLAlchemy 2.0 Database ORM

Primary LanguagePythonMIT LicenseMIT

Streamlit SQLAlchemy 2.0 ORM Example Project 📀

Streamlit

Streamlit example app with SQLAlchemy 2.0 ORM.

Description ✏️

This Streamlit app is only a simple example of how to use SQLAlchemy 2.0 ORM with Streamlit. It uses a local SQLite database to store the data.

This app is a simple post generator with fake data. Random posts are generated with the Faker library and the py-avataaars library is used to generate avatars. You can add random posts, delete posts and delete all posts.

ToDo ☑️

  • Add more CSS styling for the Streamlit app
  • Test Streamlit app on Streamlit Cloud from different clients

Ideas 💡

  • Make example with an external database instead of local SQLite

Issues 🐛

  • This app only uses a local SQLite database, there is no external database connection, therefore data is not persistent.

Status ✔️

  • Streamlit app is working
  • Last changed: 2023-11-26

Libraries 📚

Used Python Libraries in this app:


Resources 🔗

Python Database ORM Libraries 🐍

ORM Libraries Overview 👓

More Python Database Libraries 🐍


Youtube Tutorials 📺

SQLAlchemy 2.0 related video tutorials on Youtube: