SPUG: Stupid Ascii question
O'neil, Jerome
joneil at cobaltgroup.com
Thu Aug 15 12:54:36 CDT 2002
> Peter Darley <pdarley at kinesis-cem.com> wrote:
> Friends, I am working with database stuff and I
> want to store deleted database records, so
> there's a history of what was in the database.
I know I'll be declared a heretic for recommending it, but if you have
access to the database, why not simply let the database handle it instead of
writing a bunch of code and custom formats.
Add a boolean 'deleted' attribute to the relations in question, or create a
new 'deleted records' relation, and add a trigger to copy the record on
delete. Standard OLAP stuff.
This way you have a complete history in the database, everything is fully
recoverable via your SOP database management practices, and you've saved a
bunch of time.
$0.02 worth. Spend wisely...
-Jerome
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.pm.org/archives/spug-list/attachments/20020815/6be11196/attachment.htm
More information about the spug-list
mailing list