all-things-risingwave
Is it possible to subscribe directly to changes in materialized views using existing postgres clients?
Fudini is looking for a way to subscribe directly to changes in materialized views using existing postgres clients. The discussion involves exploring options like creating a sink to capture changes continuously or using client libraries to subscribe to notifications.
Fu
Fudini
Asked on Dec 30, 2023
- Existing postgres clients do not have the ability to subscribe to changes in materialized views directly.
- To capture changes continuously, you can create a sink to a message queue like Kafka, Pulsar, or NATS and subscribe to the topic.
- RisingWave is considering implementing a feature similar to subscribing to changes in materialized views, but it is not available yet.
- You can track the progress of this feature through the GitHub issue: Issue 14316.
Jan 03, 2024Edited by