Displaying intermediate results from query result stream until query finishes

[jbau]

Hey guys.

Right now I have a datatable that is populated based on a query to a database. This database query sometimes takes a looooong (did I say LONG) time. Luckily, I have a way of obtaining a result stream from this query, but I have no idea how to display this stream as I receive the results.

Right now I have an update_table method that queries the db, gets the results, and displays them whenever it is done. How should I go about querying the db, display the results received in the stream while the query is not finished, and when the query is finished print the final results?

If anyone needs any more clarification on my problem PLEASE let me know. I really really need help here!

[flyingcujo]

Check this out…post is a little old but it should provide an option for you…

Our new boilerplate dash app supporting Celery (show and tell)

Hi folks. We’ve completely updated our Wiley boilerplate dash app to take advantage of the new features of Dash Deployment Server. Key features include: Execution of long-running tasks on a Redis database via Celery (no more server timeouts or flashing screens!) Display/interrogate results using DataTable Download results in Excel format via Amazon S3 Verbose logging in the Terminal to help learning and debugging Even with the extra features, it should still be possible to drop in your ow…

[jbau]

This looks very promising. I’ll try and use this tomorrow and I’ll let you know if this helps me! Thanks so much!