Convert old notifications to diffs? Or store a comment diff separately and pointer to that instead?
Diff history could be useful for entry edits also.
Impact, of course, is database space required, retention periods, usefulness of diffs, increased complexity, etc. :-)
Benefit is this sort of thing, plus *much* better audit-trail if necessary, potentially a good way to store drafts and edits, etc.
If you store the diffs as reverse diff from the current state, it makes it easy to expire old/too-many diffs (i.e., keep only the last 5, or 10 or something).
no subject
Diff history could be useful for entry edits also.
Impact, of course, is database space required, retention periods, usefulness of diffs, increased complexity, etc. :-)
Benefit is this sort of thing, plus *much* better audit-trail if necessary, potentially a good way to store drafts and edits, etc.
If you store the diffs as reverse diff from the current state, it makes it easy to expire old/too-many diffs (i.e., keep only the last 5, or 10 or something).