Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: Re: Perl and Databases

by sdyates (Scribe)
on Mar 28, 2002 at 18:22 UTC ( [id://155061]=note: print w/replies, xml ) Need Help??


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

I think what you need to do is ask: What is the right database for me to use?

Perl has drivers that allow it to connect with MySQL, MSQL, ODBC and many others. You are using DBI and DBD to connect, after that, the type of DB you are using is irrelavent from perl's standpoint.

From here, concentrate on the database for your needs.

Do you need a transactional DB?
Do you need a relational DB?
Do you need speed over functions?
Is price an issue?
What do most of your clients use?
What is the size of the company or job?
Will you DB be heavily used to monetary transactions?
What OS does the DB support?

I have been using MySQL with perl for almost a year. I have also used perl to access ODBC databases and perl does the job well. I think you may be asking the wrong question.

I use MySQL for the following reasons:

-It is free for me and cheap for my clients.
-It is easy to install and easy to manage.
-It works on many platforms, but works very well on linux.
-It is very fast.

Oracle is great for large companies and has functions for pretty well anything you could want. However, you will pay for this with dollars and speed. It is transactional and fits in very well for e-commerce situations where losing a transaction or corrupting a transaction can prove costly.

MySQL works well for non-transaction based applications and in small to mid sized companies. It is fast and designed to be so. It has few functions compared to ORacle. MySQl is cheap... I could go on, but you need to determine what you need and then create a proposal table to see which DB scores the best

Simon

Replies are listed 'Best First'.
Re: Re: Re: Perl and Databases
by Avi (Acolyte) on Mar 28, 2002 at 23:19 UTC
    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
      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.)

      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://155061]
help
Chatterbox?
and the web crawler heard nothing...

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

    No recent polls found