in reply to Re: Re: Perl/CGI Performance
in thread Perl/CGI Performance for a Shopping Cart

I've heard so many horror stories about late night mistakes like forgetting about WHERE part of UPDATE or DELETE queries that I don't think that SQL database is any safer than filesystem in this respect. In reallity no matter what database backend you use backups are must have for important data.

Jepp! Two years ago I damaged all ongoing projects of my company from home by forgetting a where-clause; the backups were not @home :-)

pure luck I wasn't killed in a car-crash that day...while we hurried to the companys rooms

So while typos aren't an argument for DBMS :-), an rdbms is the way to go if scaleabilty matters, and it matters for every project not typed at the console-prompt (and somtimes even there...)


regards,
tomte

Replies are listed 'Best First'.
Re: Re: Re: Re: PERL/CGI Performance
by Ryszard (Priest) on Jul 31, 2002 at 07:29 UTC
    Agreed, however I was thinking the integrity of the structure of the database, as opposed to the integrity of the data in database.

    For example a badly formed "query" may remove data partway across fields, damage the data definition (if there is one) etc etc...

    With an RDMBS you're looking at a standard interface to your data that wont corrupt the framework of your RDBMS.