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

Integrity - you may trash your "database" via a fatfingers (or late night) typo, very easy to do if you delete where you should have inserted.

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.

The latest stable release doesnt support transactions

Not true (for quite long time) with InnoDB table type which is part of source MySQL distro and part of MySQL-Max binary distro.

--
Ilya Martynov (http://martynov.org/)

Replies are listed 'Best First'.
Re: Re: Re: PERL/CGI Performance
by Tomte (Priest) on Jul 30, 2002 at 17:12 UTC
    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
[reply]
      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.

[reply]

In Section Seekers of Perl Wisdom