Materialize looks like a perfect tool for the job should the need ever arise.

I think my ideal would be for the functionality to be baked directly into PostgreSQL.

Has anyone here used it?

Any comments on speed/scalability/reliability?

The self hosted license seems fairly permissive (Don't cluster, don't let your users manage the database views/queries [IANAL, read the license yourself]), but I'm hesitant given that I have never heard anyones stories about production use.

> The self hosted license seems fairly permissive (Don't cluster, don't let your users manage the database views/queries [IANAL, read the license yourself])

The self-hosted version is being discontinued after the current version. The only offering will be the purely commercial cloud offering.