RE: [PHP-DB] db's war

You might want to also check out Virtuoso http://www.openlinksw.com/virtuoso/ It's as scalable ast the 'cadillacs' and has expected features like triggers, foreign keys, and stored procedure support, and is considerably cheaper. It also has advanced XML, SOAP, and WebDAV features - fun to work with in PHP :) Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: Szii [mailto:szii@sziisoft.com] > Sent: Tuesday, September 18, 2001 4:22 PM > To: Paul Gardiner > Cc: php-db@lists.php.net > Subject: Re: [PHP-DB] db's war > > > IMHO, having run all three, I summarize them like this... > > MySQL, Postgres > Fast, open source, free. Good for projects, small-medium sized > businesses, > and playing around. > > DB2 > Good, solid database. Their UI needs work (it's 100% > java-based) and it's > significantly more complex (and pricier) than the OpenSource ones. > However, > it IS slower. It can handle MUCH larger datasets. It can be run in a > clustered > environment. It has the robustness for large business, but can > be handled > by a > medium sized one. > > Oracle > Often referred to as the "Cadillac of Databases," this thing's a beast. > Expect to not > only pay through the nose for it, but also for help/contractors/DBAs to > set it up, > tune it, maintain it, and handle the problems. It -can- be setup by > smaller firms, but > definately do your homework here. Go with someone who's been doing it a > while > and is in the enterprise space you want to be in. It's also got a HUGE > set of > applications and modules that can run on top of the raw database (no one > else really > has this from a single vendor) but that's a whole new can of > worms, costs, > problems, > etc. > > My personal favorite is DB2. The key to DB2, though, is not the common > sense things > like "do the training classes" and "get a book." The key is in their UI > stuff. Ditch it. > Learn the command lines, the scripting tools, and the database > connectivity > stuff. Sure, > you can do simple things with their UI, but it's going to > restrict you in a > lot of ways. > DB2 is big enough for "real enterprise work" but small enough not > to get out > of hand. > > However, DB2 is almost the cost of Oracle (purchasing) but your recurring > costs are > considerably cheaper. Oracle does have the advantage of being "first" and > so the > knowledge base/finding people who know a bit about Oracle is easier, and > they DO have > all of the applications modules which DB2 currently does not have. (Rumors > are that they're > looking at expanding into that realm a little more, but I don't know > anything for sure.) > > If you need a consolodated system for the whole company, well, Oracle wins > that hands down. > If you just need a super fast lightweight database, OpenSource. > For everything else, DB2. > > And if you need a kick-arse track-anything-anywhere-anyhow system, look at > Camstar Systems, > which will handle backends of both DB2 and Oracle. It's better than the > Oracle MES/tracking modules. > > -Szii > > ----- Original Message ----- > From: "Paul Gardiner" <paul.gardiner@barleychalu.co.uk> > To: <php-db@lists.php.net>; "Sommai Fongnamthip" > <sommai@thaithanakit.co.th> > Sent: Tuesday, September 18, 2001 3:16 AM > Subject: Re: [PHP-DB] db's war > > > > Hi, > > > > I'm also very interested in other peoples thoughts and > reactions to this. > > We've been hit twofold, we run on SCO which Caldera has now > taken over and > > also use Informix which IBM have acquired, whom I'm sure will > try to make > us > > move to DB2 at some point. > > > > The other trouble we have is a lot of our programs are written > in Informix > > 4GL and so will be a pain to convert. I would have liked to of had a DB > > independent 4GL but this was already in place before I got > here. The only > > real other choice like you say is Oracle but I've always heard > bad things > > regarding pricing where they are concerned. They had a special offer on > for > > anyone who jumped over two them quickly but I like to 'look before you > leap' > > :) > > > > We plan to start looking at possible alternative's before we're > forced to > > change and so would be glad to hear from anyone else who is in the same > boat > > so to speak. > > > > Best Regards, > > - Paul - > > > > > > ----- Original Message ----- > > From: "Sommai Fongnamthip" <sommai@thaithanakit.co.th> > > To: <php-db@lists.php.net> > > Sent: Tuesday, September 18, 2001 2:36 AM > > Subject: [PHP-DB] db's war > > > > > > > hi > > > I'd like to survey php commnunity about how do you think about merge > > > between informix and ibm? Did there remain only 2 major dbms (oracle > and > > > db2)? do you think MySQL will be the leader with next version 4? > > > > > > SF > > > > > > > > > -- > > > 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 > > > -- > 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 > >