Moving to per-tenant DB architecture

Using Streamlit
, , ,
1

Our Streamlit app is currently served from a single DB and we use an auth function to determine which rows a user can access. We use the st.cache_resource for the DB connection.

We are moving our DB to Turso and where each user will have their own DB. How do we cache which DB a user can access in such a way that when multiple users are logged into the Streamlit app they don’t overwrite each other’s cached DB value?

2

Store each user’s connection in st.session_state.

3

Thanks. I was hoping it was going to be that simple.

4

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