How can I display a live materialized view in a web UI and bind it to ag-Grid with WebSocket support or Middleware for live updates?
I am looking for a simple solution to display a live materialized view in a web UI and bind it to ag-Grid. I am interested in options like WebSocket support for client subscriptions or suggested Middleware for live updates.
PJP
Asked on Apr 08, 2024
- Consider querying the materialized views periodically:
Instead of subscribing to changes via WebSocket or Middleware, you can have the visualization layer query the materialized views directly, possibly through a PostgreSQL REST proxy, at regular intervals.
- Sink data to Kafka for near real-time updates:
You can sink the data from the materialized view to Kafka and then read from Kafka to get near real-time updates. This approach depends on how the pipeline is configured.
- Explore Pulsar WebSocket API:
If you are interested in WebSocket support, you can explore using Pulsar's WebSocket API. Pulsar provides a WebSocket API that you can leverage for real-time data streaming. You can try using Pulsar's WebSocket API with the sink to achieve live updates in your web UI.