Re:Tuple Database – A reactive, local-first db inspired by F...
by amirouche on Monday June 06, 2022 @01:35AM
(#31637501)
Read the whole textbook, MATERIALIZED VIEW requires a REFRESH that is outside the transaction that made the change: https://www.postgresql.org/docs/current/rules-materializedvi...
[ Parent
| on HN ]
Re:Tuple Database – A reactive, local-first db inspired by F...
by apavlo on Monday June 06, 2022 @07:41AM
(#31639229)
Postgres is not every system. Just because it requires manually refreshing matviews doesn't mean that every DBMS works that way.
Seriously, read a textbook:
http://db.cs.duke.edu/papers/fntdb12-ChirkovaYang-mat_views....