Observed arrival · 2026-09-30
OpenIVM: refresh the changes, not the whole pipeline
OpenIVM is an open-source compiler that turns SQL materialized views into incremental SQL for DuckDB and, in development, Spark.
○Open
⊠Login
$Paid
†Ads
✦Pretty
●Pro
◎Niche
◉Human
⚑Risk
ƒJS
- For
- DuckDB users and data-pipeline builders
- Worth noticing
- Changes are represented as signed tuples (+1 or −1); the page says unsupported views are classified for full refresh up front.
Field notes
The page describes delta rules derived from operator algebra rather than pattern matching, and says a view is either maintained exactly or classified up front for full refresh. It places view and auxiliary state in ordinary tables, including for batch tables, and links to a SIGMOD Companion 2024 paper. Spark support and the benchmark display are marked as in development or coming soon, so those parts are not presented as ready.
Observed signals
Read the marks
Editorial observations of this landing page, not a rating.
○OpenPublic substance visible
✦PrettyNotable craft visible
●ProPolished or operationally mature
◎NicheUnusually specific use
One card from the complete issue