Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: Re: Perl/CGI Performance

by IlyaM (Parson)
on Jul 30, 2002 at 10:49 UTC ( [id://186164]=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://186164]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others meditating upon the Monastery: (3)
As of 2024-03-29 07:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found