User:Daniel Kinzler (WMDE)/parent id


 * Semantics of rev_parent_id is unclear. Linked list or tree/graph? Changing with rev-del, or unchanging?
 * rev_parent_id is not maintained consistently on rev-deletion, import, etc.
 * Contradicts with timestamp based display on history page, diff navigation.
 * Use case:
 * show size difference. Can be computed on the fly, except on the contributions page (currently computed via a batch query based on rev_parent_id).
 * "diff as made my user" - currently not possible. should it be possible? needs the parent-id to stay fixed.
 * Warn when showing a "bad" diff
 * detect first revision of a page (but what if that gets deleted? first revision should perhaps be in the page table)
 * how to handle imported revisions?
 * Size diff itself isn't so useful. "Diff size" would be better (characters added+removed). But expensive to compute for old revisions.
 * Alternative: Record difference on save
 * add rev_size_diff
 * store in a dedicated table
 * introduce a contributions table and store there
 * store in a rev tag parameter