Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: Re: Re: Re: Perl and Databases

by RiotTown (Scribe)
on Mar 29, 2002 at 19:28 UTC ( [id://155311]=note: print w/replies, xml ) Need Help??


in reply to Re: Re: Re: Perl and Databases
in thread Perl and Databases

This has been an ongoing argument within the engineering staffs at my company for ages... mySQL is fast, but it does not allow for any relational integrity of data within the tables themselves; it also does not support transactions, which I feel is not made up by the improvement in speed. Even simple webpages can eventually end up making multiple updates/inserts/deletes into a database that could potentially cause problems, and would easily be handled by a rollback statement, but with mySQL you have to handle the transaction pieces yourself. PostgreSQL is really a quality free product that performs almost everything that Oracle can do without the pricetag. (not too sure on the scalability as I haven't used it in large deployments) And as a benefit, PostgreSQL allows stored procedures to be written in Perl!

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others musing on the Monastery: (4)
As of 2024-04-25 14:04 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found