Ynt: [PHP-DB] 'Best' DB for Linux/Apache/PHP?

huh. mysql is not a database :o) no RI, no trigger, no transaction, no SP. new generation Btrieve.. Alpay Alkan "Jason" <jbeebe@op480.com> wrote in message news:00ed01c07072$8b264e60$5e510d82@uswest.net... > 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@chirp.com.au>| > > |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@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >