Recently minted database technologies that I find intriguing
Materialize is neat, but there are other database systems that refresh at least some materialized views on the fly, while being smart about not rebuilding the entire view every time.  See for example, Oracle, where FAST REFRESH ON COMMIT does most of what Materialize is advertised as doing, at least for views which that feature can support (restriction list here: <a href="https:&#x2F;&#x2F;stackoverflow.com&#x2F;questions&#x2F;49578932&#x2F;materialized-view-in-oracle-with-fast-refresh-instead-of-complete-dosnt-work" rel="nofollow">https:&#x2F;&#x2F;stackoverflow.com&#x2F;questions&#x2F;49578932&#x2F;materialized-vi...</a> ).  Mind you, this comes with Oracle&#x27;s extremely hefty price tag, so I&#x27;m not sure I&#x27;d recommend it to anyone who isn&#x27;t already stuck with Oracle, but it is technical precedent.<p>It would be interesting to compare notes, and see what Materialize does better.