I am trying to get data from postgres db. Here is my code. I receive serialization error along with cache error. Error stack trace added after code Python Version - 3.12 Streamli Version - 1.31.1 psycopg2-binary - 2.9.9 SQLAlchemy - 2.0.27 import streamlit as st # Config section defined in [co…

Retrieving data from Postgres DB gives serialization error

Caroline March 4, 2024, 2:29pm 2

Topic		Replies	Views
Reading from Postgres DB gives serialization error Using Streamlit debugging	0	271	February 28, 2024
How to implement Cache when connecting Streamlit with a Postgresql DB? Using Streamlit cache	1	1462	June 7, 2021
UnhashableType: Cannot hash object of type _thread._local Using Streamlit cache	16	11649	January 4, 2023
Streamlit with sqlalchemy Using Streamlit cache , pandas	2	3117	July 26, 2022
String url calls sqlalchemy and sqlalchemy calls for psycopg2 Community Cloud streamlit-cloud	7	818	November 2, 2022