April 8th, 2013, 12:17 AM
Peter Brawley has an excellent article on audit trails on his website http://www.artfulsoftware.com/infotree/Transaction%20time%20validity%20in%20MySQL.pdf
Comments on this post
April 8th, 2013, 08:08 AM
Thanks Barry, Was an interesting article. I noticed, however, that it didn't describe E-Oreo's option 3 for saving data where a audit record is created per column.
Originally Posted by BarryG
April 8th, 2013, 05:59 PM
PB's paper is really an outline of the way an audit trail CAN be done.
Originally Posted by NotionCommotion
Anything you build would need to meet your needs. Perhaps you need to use E-Oreo's method, blended with something you take from PB's paper, or maybe something totally different.
The tools I've built for my use have very lightweight audit capability, because that's all I need. Horses for courses you might say.
April 8th, 2013, 07:06 PM