How to fetch real time sql data without refreshing page

Hi @adamschroeder
Thanks for your reply.

This way dcc.interval will update the data really well. but then the problem is with the dcc.store.

That way it’ll work but the problem is that my data refreshes after every 30 seconds.
My dataframe sontains 30 columns.

So my maximum no. of rows for a day can be 24 * 60 * 2 = 2880 for a day.

And if the user wants to display a month’s data in one go then the max no. of rows can be of 2880 * 31 = 89280.

So my question is that will the dcc.store be able to store a dataframe of size 89280 * 30 in it?

I read that redis is storing the data in the cache form in the system. So whenever the data gets updated by the dcc.interval, is there any way to store that data to the system cache wherever and then fetching it from it?

I hope I was able to explain and may get some help in it.

Thanks in advance :slight_smile: