MATERIALIZED VIEWS ARE OBVIOUSLY USEFUL

Summary from the TLDR Web Dev newsletter

Maintaining derived data, like task counts per project, is a common problem and often has complexities that arise when using caching and manual updates. Instead, "incremental view maintenance" or "differential dataflow" is a better solution. This approach involves defining desired data transformations with SQL, after which the system automatically keeps the results up-to-date.