Re: [PHP-DB] 'Best' DB for Linux/Apache/PHP? From: Jason (jbeebe <email protected>)
Date: 12/27/00

Well, I think the volume of people discussing mySQL, whether it be for
support or whatever is a positive sign. The user base and community support
for this db is tremendous. personally, i've used mysql on a number of sites.
1 in particular is quite busy. i think that mysql can hold its own against
most db's. is it the best... probably not. it is very good though. it
depends on what you're using it for and how you'll use it. as far as mysql,
i've never had a problem with performance, stability, or anything else.
pgsql is very good also. but again, its all in what you'll use it for. if
you're coding in php, it has a tremendous number of built in functions for
mysql. it does support pgsql and other dbs very good as well also. mysql
lacks certain features that other sql dbs have. one of them is foreign key
support. there is a method to the madness tho. it really just depends on
what exactly you'll be using it for. i would recommend mysql or pgsql.
interbase is free and borland claims its an ass kicker, but i've never dealt
with it, nor heard much about. maybe worth looking into.

jason

> On Thu, Dec 28, 2000 at 12:08:56PM +1030, Tyson Lloyd Thwaites wrote:
> > I am looking for an enterprise strength db server for Linux. I have
> > looked at IBM DB2, Sybase ASE, and Oracle...as well as mysql and
> > pgsql.
>
> i haven't had any experience with the commercial dbs, except for one
> encounter with oracle that i'd rather forget. i, too, would like some
> opinions here.
>
> > What are people using for the big sites? Any general experiences that
> > people have had would be most appreciated!
>
> having read this list for a few months now, i've seen a lot of people
> (myself included) recommend pgsql. as i've commented previously on this
> list, lots of people want help with mysql and oracle. LOTS. even
> accounting for the different sized user bases, i think this is a bit
> worrying... quite rare is the poster needing pgsql help.
>
> pgsql has its odd quirks, but on the whole its a very easy to admin and
> SOLID db server. we've been using 7.0.3 on a few fairly busy sites, and
> it hasn't blinked yet. very fast, too. the data corruption bugs i saw
> in 6.5.x with INSERT/UPDATE longer than they were supposed to be, are
> long gone.
>
> slightly offtopic (*grin*): anyone looking for a unix admin/web
> developer? email me off-list if you are interested. my job here ends
> mid january.
>
> j.
>
> --
> .----------+------------------------------------.
> |John Slee `-----------. <john <email protected>>|
> |Chirp Web Design | http://www.chirp.com.au|
> |Phone: +61 2 62301871 `----. +61 2 62301515 Fax|
> `---------------------------+-------------------'
>
> --
> 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>
> 

-- 
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>