Did I miss in the article where OP reveals the magic database that actually does this?

3rd party solutions like https://readyset.io/ and https://materialize.com/ exist specifically because databases don’t actually have what we all want materialized views to be.

▲

sophiebits 8 days ago | parent | next [-]

These startups (and a handful of others) are what I meant!

▲

jelder 8 days ago | parent [-]

What others do you know of?

	▲	sophiebits 8 days ago \| parent \| next [-]
		Feldera, RisingWave, DeltaStream, Epsio, Decodable, Confluent all seem to have some offerings in this space. Probably others too!
	▲	jamesblonde 8 days ago \| parent \| prev [-]
		Feldera

▲

anon84873628 8 days ago | parent | prev | next [-]

In the analytics world, BigQuery MVs seem pretty cool. You can tune the freshness parameters, it will maintain user-specific row-level security, and even rewrite regular queries to use the pre-computed aggregates if possible.

But I don't think there is anything similar in the GCP transactional db options like Spanner or CloudSQL.

▲

rapind 8 days ago | parent | prev [-]

You can do targeted materialized view updates via triggers. It's definitely verbose but does give you a lot of control.

I'm currently parking PostgREST behind Fastly (varnish) for pretty much the same benefits plus edge CDNs for my read APIs. I really just use materialized views for report generation now.