Best Way to Implement a Versioning System for User Edited Content

Question

I have a requirement to let users edit each others entries. So in case of bad entries, I need to be able to go back to an earlier version.

What is the best way to implement this in the data layer? Should I have like a triage table? And once the admin approves the edit, the triage version gets copied and put into the main entries table?

How would you guys do this?

Thanks, Alex

score 2 · Accepted Answer · edited May 23 '17 at 12:11

2

This answer may work for you.

Rolling Your Own Plaintext Wiki (Wiki inside a DB)

edited May 23 '17 at 12:11

Community

1
1

answered Mar 04 '11 at 22:36

Will Hartung

115,893
19
128
203

score 1 · Answer 2 · answered Mar 04 '11 at 22:25

1

I know you're thinking in terms of a database, but you may want to look in to using Mercurial or Git as the back-end to your application. It won't work like a database, but you'll have full version control.

answered Mar 04 '11 at 22:25

Tony Casale

1,537
8
7

Best Way to Implement a Versioning System for User Edited Content

2 Answers2