So I’ve been using dash for a little bit now and I’m used to taking my data and storing it locally before using it in my apps. Typically I store data in a feather format, but this is in essence the same as storing it in any file type. I’m trying to get more advanced with how I connect to databases and store information, but I’m not seeing a clear best approach for this.
I am connecting to a Snowflake database right now, but am unsure how to best connect to it. Should I have a live connection in my app? Should I cache? How does it work? I’ve read this page but didn’t get clear answers - Performance | Dash for Python Documentation | Plotly
It sounds like from this article that flask caching could be useful, but again not sure how it works. Any guidance would be greatly appreciated.