SPUG: Stupid Ascii question

Don Shanks me at donshanks.com
Thu Aug 15 13:29:05 CDT 2002

Failing the access to the database, have you considered ( Here goes my
heretical slant ) using XML, something simple like XML::Element,
compress the file if need be. both string and binary data can be stored.

-----Original Message-----
From: owner-spug-list at pm.org [mailto:owner-spug-list at pm.org] On Behalf
Of O'neil, Jerome
Sent: Thursday, 15 August, 2002 10:55
To: Peter Darley; SPUG
Subject: RE: SPUG: Stupid Ascii question

> 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... 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.pm.org/archives/spug-list/attachments/20020815/e407b7af/attachment.htm

More information about the spug-list mailing list