Why do i get a TypeError when using the following code. The error only occurs on my cloud app, but runs fine locally. Should I rather use psycopg2 to create the connection instead of st.connection()? conn = st.connection("postgresql", type="sql") users_df = conn.query("SELECT * from users") st.dat…

Can't query using st.connection()

LStaehli March 4, 2024, 12:43pm 4

Hi, I had the same issue. I upgraded sqlalchemy to version v.2.0.27 (latest as of today), which fixed this issue.
streamlit==1.31.1, SQLAlchemy==2.0.27

Best, L.

1 Like

Raise TypeError("Query must be a string unless using sqlalchemy.")

Topic		Replies	Views
Raise TypeError("Query must be a string unless using sqlalchemy.") Using Streamlit streamlit-cloud , debugging	3	6777	August 31, 2024
String url calls sqlalchemy and sqlalchemy calls for psycopg2 Community Cloud streamlit-cloud	8	791	November 2, 2023
Connecting to Postgresql Using Streamlit database , debugging , postgresql	4	1865	February 22, 2024
ModuleNotFoundError: No module named 'sqlalchemy' Community Cloud	7	6032	April 22, 2024
No module named 'sqlalchemy' with deployed app Community Cloud	5	613	July 20, 2024

Can't query using st.connection()

Related topics