On Wed, Mar 31, 2010 at 7:51 AM, Justin Giboney <[email protected]> wrote: > Is there a design pattern for handling updates to information? > > I am designing a application that needs to know when things changed > and who changed them. Is the best way to do this to create a > transaction table for each table in the database that records the new > update every time something changes
On a different project in a different language, another programmer and I were just having this discussion. He provided a couple of links I haven't read yet that deals with this. I'm passing them along just in case they are useful. http://www.simple-talk.com/sql/database-administration/database-design-a-point-in-time-architecture/ http://opensource.anasoft.com/daofusion-site/index.html _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
