RisingWave Community - Is it possible to subscribe directly to changes in materialized views using existing postgres clients?

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