Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: Re: Re: Perl and Databases

by Avi (Acolyte)
on Mar 28, 2002 at 23:19 UTC ( [id://155150]=note: print w/replies, xml ) Need Help??


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

Why isn't MySQL good for transactions? I've not worked with any databases, but would like to get into it. Only reason would be for e-commerce solutions.
And if MySQL isn't good for transactions, is PostgreSQL?
Just wanting to get a feel of what database system I should start fiddling around with when I get the free time to do so.

Thanks,
Avi

Replies are listed 'Best First'.
Re: Re: Re: Re: Perl and Databases
by dws (Chancellor) on Mar 29, 2002 at 01:04 UTC
    Why isn't MySQL good for transactions?

    Transactions have only recently become available in MySQL, so they don't have much of a track record yet. Also, many who are biased against MySQL on the basis of no transactions haven't been keeping up with MySQL (not that there aren't other reasons to favor, say, Postgres.)

Re: Re: Re: Re: Perl and Databases
by RiotTown (Scribe) on Mar 29, 2002 at 19:28 UTC
    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://155150]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others exploiting the Monastery: (7)
As of 2024-03-28 22:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found