I noticed a rollback for question edits. I assume this is a similar concept to version control or how we have on windows a system restore where it will rollback to any previous snapshot point.
My question is not limited to only StackOverflow but in general how does this site or other sites in general store this in the DB? If they use RDMs that means 1 entire row for each change. And a row can have even 50–100 columns when only 1 column was updated so lot of data being written again and again.
For StackOverflow this may be fine because at most a person may edit the question say 10 times so 10 new rows. But for something like say your interests which people updated each day that is like 1 update per person per day and have 10 million users so 10 million new rows each day of just historical data.