News for hackers. Stuff that matters.
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...
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....

Re:Tuple Database – A reactive, local-first db inspired by F... by amirouche on Monday June 06, 2022 @01:25PM (#31643214)
Indeed, I jumped into PostgreSQL documentation, that's where I started reading about materialized views.
Re:Tuple Database – A reactive, local-first db inspired by F... by amirouche on Monday June 06, 2022 @01:34PM (#31643298)
I do not think that PDF is worth taking space in my personal knowledge base. Thanks for sharing.