#materialized-view

Every post I've written about materialized-view — 1 article, across Engineering. Most recent: “When SQL Is Enough for Streaming: What Incremental View Maintenance Guarantees — and What It Refuses.”

Engineering01

When SQL Is Enough for Streaming: What Incremental View Maintenance Guarantees — and What It Refuses

The 2026 pitch is that a hand-written stream job collapses into one CREATE MATERIALIZED VIEW, so I built one in RisingWave and spent my study time trying to break it. These are my notes on the consistency the view actually delivers as events arrive, why every join in it is a standing memory bill, and the queries that refuse to be incremental — with a Node consumer riding the view's changefeed over the plain Postgres protocol.

Jul 19

Posts tagged #materialized-view

When SQL Is Enough for Streaming: What Incremental View Maintenance Guarantees — and What It Refuses