Skip to the card

Card 605 of 9832026-09-30 issue

Observed arrival · 2026-09-30

OpenIVM: refresh the changes, not the whole pipeline

openivm.org Visit website
Editorial interest 78/100 Selection signal · not a rating of the site

OpenIVM is an open-source compiler that turns SQL materialized views into incremental SQL for DuckDB and, in development, Spark.

Landing page captured for the 2026-09-30 issue.
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

Ask the Descendants

390,826 arrived 1,000 judged 983 catalogued Enter the complete issue
openivm.org

Landing page observed 2026-09-30. The live site may have changed.