Saving Versions of Data
Posted: Tue Jun 29, 2010 10:24 am
Hi everyone, new web developer here working on a big project, in need of a bit of advice.
To make this very simple, I'm making a database for utility meter readings for a group of apartment complexes. I'm mostly not having any issues, but they want a way to be able to roll back the data in case any mistakes are made. I figured it wouldn't be too hard to automatically record the current version of the data every time someone clicks "save", but I can't think of an elegant way to do it. Will I have to create a new table for the data every time someone clicks "save" or is there a better way to do it?
Please ask if you need any clarification. Thanks for helping!
- Matt
To make this very simple, I'm making a database for utility meter readings for a group of apartment complexes. I'm mostly not having any issues, but they want a way to be able to roll back the data in case any mistakes are made. I figured it wouldn't be too hard to automatically record the current version of the data every time someone clicks "save", but I can't think of an elegant way to do it. Will I have to create a new table for the data every time someone clicks "save" or is there a better way to do it?
Please ask if you need any clarification. Thanks for helping!
- Matt