Make EditHistory Great Again
Correlating edit history with the current value is currently a matching game. eg find the lates edit in the editHistory that matches the value of the cell. This means we need to do a lot of extra compute during merges and restricts the apps ability to roll back changes.
We need to start storing an id for each edit in the edit history. (we can just hash the value + timestamp + author to create an id for existing edits)
The id of the corresponding edit can then be used as a pointer in the cell value. This will result in a simple system that allows us to scale and makes merging edits a lot easier.
Make EditHistory Great Again
Correlating edit history with the current value is currently a matching game. eg find the lates edit in the editHistory that matches the value of the cell. This means we need to do a lot of extra compute during merges and restricts the apps ability to roll back changes.
We need to start storing an id for each edit in the edit history. (we can just hash the value + timestamp + author to create an id for existing edits)
The id of the corresponding edit can then be used as a pointer in the cell value. This will result in a simple system that allows us to scale and makes merging edits a lot easier.