How do I build a real-time dashboard that updates graph-like UIs every second?

[boondoge]

Goal:
Realtime data steaming display. The expected behavior is to be able to connect to PusherJS to receive realtime data update from server.

Steps:

Best practice for realtime/event-based apps?

Use Workflows for notifications if need be but why would there be updates every 5 seconds? Just curious... yes CRUD is supported very well on this platform!

IoT/OT in Retool and realtime handling

Interesting I had a look at doing MQTT in the client and that looks like a non starter. Also if you search for retool realtime you will find that it's not supported as a concept. So what ever you message store is DB/MQTT/REDIS your retool app will have to poll. Now interestingly it seems retool are starting to support http/2 SSE server sent events for postgres. Using SSE fits very well with retool can only hope this is an ongoing and strategic choice to build responsive apps.

Seems like the only way is to use custom component + WebSocket. We are using PusherJS, the current workaround would require extra configuration and setup to manage the data and re-pipe the data to WebSocket.

[khill-fbmc]

Is long polling not an option? You could have a query run every second and pull fresh data into the chart?

[lchen110]

Not really. Our system use Pusher to broadcast realtime data. Due to the way our system operate, we can't use pull. We are also not storing the realtime data.

[Jack_T]

Hi @boondoge,

We currently do not have any built in integrations for this type of functionality.

You may be able to hack together something using @khill-fbmc's suggestion of running a query to a REST API and have that server serve the data back to the app.

We have docs on data streaming here.

Also a workflow has an exposed trigger URL that could be the recipient of data payloads from a webhook. This could be used to get data and move it to a place where it is accessible by an app query.