Re: [PHP-DB] db's war
Having worked in IBM and in Open Source community I feel I've know both systems very well. MySQL is different to the big boys of DB2 and Oracle. They are designed for enterprise level, and to handle a complexity and quantity of data which mysql just isn't there. The SQL used in mysql is vastly simpler than that used in the others, and could be said to less powerful in that in can do much less. This leads on to what I feel is the key point here, mysql place has not been in doing in enterprise level stuff, it has been in providing a good simple way of doing simpler things. Because of its simplicity it manages to be very effecient, but when you start trying to build it more complex the obvious flaws in the language. I'm eagerly awaiting the next release of mysql to see what they do with it. I think they will either stick to how it as at the moment and further improve performance and the basic features or are they going to take a step up (and away) from where they are at the moment and start to see more complex features (maybe even sub-selects. now that I *would* like to see in there). Either way I don't think mysql competing with db2 or oracle, at least in the reasonably long future, is all that likely. The customer base and trust is there too strong + the products are actually decent (which is where any analogy between ASP and PHP breaks down ;) ) As in almost everything in IT, and I life I guess, it's a case of best tool for the job. Well, there's my ha'penny's worth. Anyone want to start a DB2 / Oracle debate? (JOKE been there done that, neither won) Tom - Original Message - From: Sommai Fongnamthip [EMAIL PROTECTED] To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Sommai Fongnamthip [EMAIL PROTECTED] 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 [EMAIL PROTECTED] To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 4:22 PM To: Paul Gardiner Cc: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Sommai Fongnamthip [EMAIL PROTECTED] 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 [EMAIL PROTECTED] To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e
