I did just that recently. They certainly seem to offer the most complete solution. Definitely worth keeping an eye on.

I had to pass because of its prohibitive license (for now) and the head-scratching bugs I ran into with the direct Postgres source. I also had some concerns about the complexity Materialize would add to architecture of the sort of small apps I typically build.

I know this is unappreciative of the complexity of the problems that Materialize solves, but it would be so nice if Postgres just had observable (with triggers), no-compromise incremental materialized views.

What sort of experiences have you had with Materialize, if any?

Thanks for trying Materialize, (I work there!) What bugs did you run into with the Postgres Source? If you put them in a reply here or an email to [email protected] we would be very appreciative of your feedback.

Thanks for the reply. I'll make some time this weekend to reproduce my issues and send them your way.