Re: which database is best for perl ?


Clear questions and runnable code get the best and fastest answer
	PerlMonks

Re: which database is best for perl ?

by Abigail-II (Bishop)

on Feb 09, 2004 at 10:43 UTC ( [id://327593]=note: print w/replies, xml )

Need Help??

in reply to which database is best for perl ?

Is mysql eventually better suited for the use with perl ?

No. Most, if not all, popular databases can be connected with from Perl using the DBI. Meaning the interface is the same.

Your decision of what is the appropriate database to use should not depend on the language you use, but on your data. How important is the data to you? How volatile is it? What kind of queries are you going to perform? How often? How important is performance? How much data are you going to store?

Abigail

Comment on Re: which database is best for perl ?

Replies are listed 'Best First'.

Re: Re: which database is best for perl ?
by Gyro (Monk) on Feb 10, 2004 at 17:57 UTC

Abigail-II

Don't think of it a what is right for Perl but what is right for you. Perl can be used to touch practically any database, the list of compatible DBI modules keeps growing. We seem to adopt that which we first come in contact with. Which you seem to have done, but it doesn't hurt to look around. Here is a link to MySQL's db comparison page.
Some other things to consider:

How stable is it?
How portable is it?
How secure it is?
How easy is it to administer?
What kind of support is available and does it have a cost?
How much does the db cost?(for the budget minded)
How mature is the DBD module for the db you want? If you are using DBI.
What third party apps are available for it?

Cheers
Gyro

[reply]

In Section Seekers of Perl Wisdom