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

It really needs to be an enterprise-strength database. I know that MySQL is the
fastest, but the lack of other features makes it unsuitable for a large,
corporate site.

I am really looking for a good commercial database. Like I said, my current
candidates are Sybase and IBM DB2.

If anyone has any experience with big systems like this, (ie they rule, they
suck) I would really appreciate hearing about it. 

--

Regards,

Tyson Lloyd Thwaites
I.T&e eCommerce Division
Adelaide
www.ite.com.au

""Jason"" <jbeebe <email protected>> wrote in message
news:00ed01c07072$8b264e60$5e510d82 <email protected>
> 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>
>

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