5 ms·

There’s so much value in database triggers when they’re done right. Anything where live stats are needed gets a whole lot easier with triggers rather than count

There’s so much value in database triggers when they’re done right. Anything where live stats are needed gets a whole lot easier with triggers rather than counts.

trollied 4y ago
Then you discover Materialised Views... :) Magic.
- switchbak 4y ago
  Just wait until we get Incremental Materialized Views!
  - NeutralForest 4y ago
    I was gonna mention that as well. There's a relevant talk from the System distributed convention https://www.youtube.com/watch?v=QtQMWUik0oY https://www.youtube.com/watch?v=QtQMWUik0oY It's about caching views or queries and updating them when necessary as well as keeping your cache and DB in sync automatically.
  - trollied 4y ago
    Oracle has done them for 20+ years.