Hi community! I need some advice on how to use caching with sqlalchemy.orm. I am writing an app for data exploration. The app uses sqlalchemy to query data from a database. Some of the queries can run for quite a bit of time but the result is reusable at different points in the app. Hence the need…

Now we can play … we want to use hash_funcs to map a python data type like this orm.query.Query to a particular value that is easily compared and stored. For a SQL ORM query, my first idea is to compile and generate the SQL string statement, which looks possible , so when I get the same query multip…

How to use st.cache with sqlalchemy.orm objects

Using Streamlit

amitg1 June 10, 2020, 2:04pm 4

Hi, I ran into the same issue here:

I tried various solutions with no success as you can see in the post
I did create a small example in the post, but I guess not small enough since no one answered.

Topic		Replies	Views
Caching issue with sqlalchemy Using Streamlit cache	2	1046	November 19, 2021
St.cache with sqlalchemy Using Streamlit cache	4	5403	November 19, 2021
Streamlit cannot hash an object of type <class 'sqlalchemy.engine.base.Engine'> Using Streamlit cache , windows	8	3286	November 19, 2021
Streamlit with sqlalchemy Using Streamlit cache , pandas	3	3052	July 26, 2023
UnhashableType: Cannot hash object of type _thread._local Using Streamlit cache	16	11477	January 4, 2023

How to use st.cache with sqlalchemy.orm objects

Related topics

Hello there 👋🏻

Cookie settings

Strictly necessary cookies

Performance cookies

Functional cookies

Targeting cookies