I’ve got a dash app in production which is backed by a snowflake (AWS hosted SQL service) instance. Snowflake has a 4 hour timeout on any of their connections, so I need to architect this in a way to keep the connection open. Let’s assume for the time being that I can’t edit the 4 hour timeout. My t…

Couldn’t you just create a method or an object that creates a new connection, if the previous one has timed out? Something like, conn_cache = {} def get_conn(key): try: conn = conn_cache[key] except Exception: # limit to the actual exceptions; key missing, timeout, etc. co…

Thanks @Emil … I’ve implemented a method to this extent, I’ll see how it works with the timeout overnight tonight, and will let you know, appreciate the insight.

Hi Emil, Thanks again for the help. Here’s how I’ve implemented this on my side, unfortunately, I’m still getting the conn timeout error… this may be more of a snowflake issue than it is a dash/plotly one. I’m not sure if anyone out there has synced up Dash to this specific DB instance before, or h…

I’m starting to think the solution will be something more along these lines (or going full redis)… [image] [Solved] Updating server side app data on a schedule Dash Python Hi @chriddyp @nedned , can you please give a example for this? I’m having problems with this and have…

Further, I think SQLalchemy may have a solution to this. I’ll reply here if I think this solves my issue… https://docs.sqlalchemy.org/en/13/core/pooling.html#pool-disconnects

Keeping DB conn open using dcc.Interval

Dash Python

jezlax December 27, 2019, 5:49pm 5

I’m starting to think the solution will be something more along these lines (or going full redis)…

Topic		Replies	Views
Working principle of database connections and data refresh Dash Python question	4	185	February 2, 2025
Python Dash SQLAlchemy Dash Python	9	2994	January 21, 2022
Consistent update dash page across connections Dash Python question	2	361	October 7, 2022
Dash python dcc interval update callbacks Dash Python	1	347	March 27, 2023
Dash with global persistent Postgresql connection object? Dash Python	3	858	December 30, 2020

Keeping DB conn open using dcc.Interval

Related topics