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....
> Yet SQL does not provide a way of indexing queries that involve a JOIN. Social apps that want to query "what are all the posts of all the people I follow ordered in time" must design their own systems because SQL cannot index that query (SQL will need to load all of the posts of all the people you follow over all time, and sort them in memory!)
rough query but you get the idea
Please read a textbook about databases before building your own.