php-db | 2001041

Re: [PHP-DB] Oracle vs MS SQL vs MySQL From: Steve Farmer (hts <email protected>)
Date: 04/04/01

Hi Brian,

At 7:24 PM -0500 4/4/01, Brian.J.Mauter wrote:
>Hey,
>
>Has anyone tried out all three of these DBMS packages and evaluated them?

well not all of them :)

>I was wondering what everyone is having the best luck with when writing
>PHP scripts.

On that level it doesn't make much difference to me....

>
>I'm using Oracle8i and if you don't mind, it's a pain in the tail. :-P

Kinda wondering what in particular is a PIA about it, apart from the
knowledge level required to install, configure and tune Oracle !!

>
>While I'm asking, let's not limit it to just those three, if anyone is
>overwhelmingly pleased with something else, name it please! :-)

MySQL - best price :) , very fast when doing reads, not very good
when a lot of writes are happening, lacking in some fundamental
features eg foreign keys etc. Integrates well with PHP.

PostGres - no experience , but V7 seem to be getting very good
reviews, I am going to try it out very soon now.

Oracle - the "18 wheeler" of the RDBMS world. Expensive but highly
scaleable, full featured , excellent security etc. It needs a fair
amount of knowledge to really get it happening though. PHP
integrates well, including with stored procedures.

So IMHO it's a matter of "horses for courses" i.e. choosing the right
tool for the job.

>
>Thanks,
>Brian

HTH
Steve Farmer

-- 
---------------------------------------------------
"Minds are like parachutes, they work best when open"
Support free speech; visit http://www.efa.org.au/

Heads Together Systems Pty Ltd http://www.hts.com.au Email: hts <email protected> Tel: 612 9982 6767 Fax: 612 9981 3081

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe <email protected> For additional commands, e-mail: php-db-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>