3 ms·
Did I miss in the article where OP reveals the magic database that actually does this? 3rd party solutions like https://readyset.io/ https://readyset.io/ and h
by jelder 1y ago
Did I miss in the article where OP reveals the magic database that actually does this?
3rd party solutions like https://readyset.io/ https://readyset.io/ and https://materialize.com/ https://materialize.com/ exist specifically because databases don’t actually have what we all want materialized views to be.
- sophiebits 1y agoThese startups (and a handful of others) are what I meant!
- jelder 1y agoWhat others do you know of?
- jamesblonde 1y agoFeldera
- sophiebits 1y agoFeldera, RisingWave, DeltaStream, Epsio, Decodable, Confluent all seem to have some offerings in this space. Probably others too!
- rapind 1y agoYou 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.
- anon84873628 1y agoIn 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.