Ask HN: Strategies/practical-advice on lazy database updates?

Looking for pointers/advice on implementing lazy database (sql/no-sql) updates - approaches, systems where it's implemented, pros/cons.

In principle, it sounds like a really good idea, but most references I can find are years even decades old. Why is this?