To showcase the power of using a database with Streamlit apps to display live data, this app enables users to insert their own data into a table on their database. The new data is then automatically displayed and used in the app.
You can try out the app here.
You can find the corresponding blog post here.
In app.py, you will find this line of code. If you are deploying on the Ploomber Cloud, set this to True.
cloud = False To run this app locally ensure you replace YOUR_URI in
DB_URI = environ["DB_URI"] if cloud else "YOUR_URI"to your personal database URI and that you have installed all the packages listed in requirements.txt. Then, execute streamlit run app.py in your command line.
When deploying this app on Ploomber Cloud you should omit your personal DB URI from your app.py file so it doesn't get exposed. You can do this by setting cloud = True and leaving "YOUR_URI" unmodified in the code above.
To access our URI, we instead need to set the DB_URI as a secret in the deployment environment. Refer to the documentation or blog post to learn more.