Postgres materialized views fail at scale because a single row change forces a full recalculation. I wrote a patch to fix this. It adds an optional WHERE clause to the REFRESH MATERIALIZED VIEW ...

Your Django querysets become live Postgres tables. Define a queryset, get a table that updates within milliseconds of every write — to source rows, bulk operations, raw SQL, or writes from other ...

This is a TL;DR Post, it will be followed by an in-depth post. Scoped to Postgres for now, but most of these extend to other RDBMS. These are the patterns I keep seeing, and have been bitten by, while ...