Streamlit App Deployment

Using Streamlit
1

I am planning to deploy an app that uses SQLite database. Where do I host the DB file

2

Hey, thanks for posting,

Streamlit provides support for SQL database,
You can refer to this simple tutorial from the docs


Connect Streamlit to MySQL - Streamlit Docs

3

:+1:

1 Like
4

This would be on either a server or a cloud based system which the app will be pointed to read is my understanding. Hopefully right

5

Yes you are right, this was for server like if you are deploying your app


But if you want to test it on your local then you can use SQLAlchemy library to connect to your local SQL


You can look for this tutorial for some motivation

https://docs.streamlit.io/library/advanced-features/connecting-to-data

6

I followed the docs and set up my app. However, my db is Mysql. And the app is working fine with mysql connector when using # db_config = {
‘user’: ‘user’,
‘password’: ‘passwdxxxx’,
‘host’: ‘xx.xxx.xxx.xxx’,
‘database’: ‘MySQLDB’
}
conn = mysql.connector.connect(**db_config).
Is there something I am missing as I am being asked to install sqlalchemy - wonder if I need to make changes to my code itself.

Thanks in advance

7

:grinning: It is always fine if it is working


The benifit you might get from SQLalchemy is that, SQLAlchemy primarily uses ORM (Object-Relational Mapping) in order to abstract the details of handling the database. This can help avoid errors some times
 whereas mysql connector works only with simple SQL

1 Like
8

Got over this. Now struggling to import mathplotlib import matplotlib.pyplot as plt. Made another thread for this

9

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.