When I'm looking down the front page on dba.se, I often wish I could tell at a glance what happened to the question to bump it there. Sometimes it is obvious from looking at the number of answers, other times you have to follow a link to find out if it has been edited or if an answer has been added or updated.
I'm guessing this is just as applicable on other SE sites - this is the kind of thing I'm suggesting:
A couple of suggestions from the comments that might be good:
- To reduce clutter the word 'ago' could be removed at the same time.
- The new text could be visible only to established users - ie users who are likely to be reviewing/editing and would benefit from seeing at a glance what kind of change has occurred.
top 1
on a highly optimized index on the last updated/modified/answered fields. Same for the cache. But, yes, it's up to SE to decide./review
queue is going to pick that up (at least I'd hope so).