It needs not to have the same capabilities, it needs to have capabilities that people are using. The primary capabilities that people need, in my opinion, are a decent scripting language, with the full complement of the database triggers, procedures, packages and functions, ability to store/access/administer huge objects, hundreds of gigabytes in size, a decent SQL implementation with plethora of functions and a support for standard APIs like JDBC, ODBC, OLE and DBI. A good compiler support with something similar to long extinct SQL*Module (originally an IBM technology) and there would be huge number of users. Fortunately for oracle, MySQL still has problems with the most basic things: transactions, versioning, locking and SQL implementation. My conclusion is that MySQL will never be much more then a toy, despite the hype, catchy name and apparent popularity. I see much more dangerous adversaries in UDB (artist formerly known as DB2) and PostgresSQL. If IBM decides to play open source on Unix, and there are rumors of IBM musing over such a move, Oracle would most probably be toast. I must say that after some oracle's mischiefs, I wouldn't be the last one to defect and switch the databases. I wasn't the last one to leave DEC either, despite the fact that I was teaching VMS courses in 1992. My point is that Oracle is extremely feature rich. Very few people are using more then 20% of the database capabilities. Initially, in V8, I worked hard to learn about the Object PL/SQL, datatypes and classes. Believe it or not, I've never seen it used in production. By now, I've forgotten it all. It's almost the same situation with Java in the database. Very few are using it. Most people test it, then say "aha!" and move on. Those two features will not make a whole lot of difference when a viable competitor emerges. Oracle 10g was written, for the most part outside of US. With beta testing this closed and restricted, it's not going to be tested thoroughly, not even close to thoroughly. What we are likely to get is an unstable, buggy and almost unusable "gridlock" version. Competitor might emerge sooner then some people are realizing.
On 2004.01.19 20:42, [EMAIL PROTECTED] wrote: > If MySQL comes to have the same capabilities that many people expect > from Oracle, marketing will have no effect. The huge differential in > price > point will be all that matters. > > > Jared > > > > > > > DENNIS WILLIAMS <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 01/19/2004 04:04 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject: RE: Oracle vs Mysql > > > Sounds like the old Oracle vs. Ingress battles. Oracle won because it was > better at marketing. All detailed in the book "The Difference Between God > and Larry Ellison". I can see it now -- MySQL, the Oracle of the free > databases. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -----Original Message----- > Sent: Wednesday, January 14, 2004 4:39 PM > To: Multiple recipients of list ORACLE-L > > > Ryan, > > It's postgres.org. I'm not sure how they generate the > operating > revenue they need, but that's why they are not advertising like MySql AB > is. > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -----Original Message----- > Sent: Wednesday, January 14, 2004 5:05 PM > To: Multiple recipients of list ORACLE-L > > > i thought postgre was a for profit company? how do they generate revenues? > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, January 14, 2004 4:19 PM > > > > 1) DBI is a perl module to handle the communication with various > databases. > > 2) Postgres is free. I believe that you can buy commercial support, but > I > don't know > > where. May be Rich can jump in with that. > > 3) DBI is free and so is perl. I'm cheap & easy, but not free. > > > > > > On 01/14/2004 02:34:52 PM, Ryan wrote: > > > what is DBI? > > > > > > is postgre free? Is it like linux where you pay for support? I cant > find > any > > > licensing info on the website. Most shops dont need oracle, sql > server, > > > sybase, or DB2. > > > > > > Most applications are small. I was on a project where the government > had > an > > > Oracle EE license on windows. They didnt even use foreign key > constraints. > > > Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free > database > > > could have handled that. > > > ----- Original Message ----- > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > Sent: Wednesday, January 14, 2004 1:44 PM > > > > > > > > > > > > > > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote: > > > > > If you have the choice, look at PostgreSQL in addition to MySQL. > From > > > what > > > > > I've seen, it's more mature than MySQL. > > > > > > > > I second that. PostgresSQL supports transactions and uses perl as > its > > > > scripting language. From what little I read and saw (just a little > pilot > > > > project with the goal to see "what the heck is Postgres"), it's a > very > > > > decent database, with a decent performance and capabilities > sufficient > > > > for a small, departmental database server. I know nothing of > clustering, > > > > distributed database, database links, replication and alike. In > other > > > words, > > > > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, > but > > > > it can be quite a convenient storage space for a small corner shop > or > a > > > > small department. Because of perl and DBI, exchanging data with > other > > > > servers like oracle or UDB (DB2) is easy. > > > > > > > > -- > > > > Mladen Gogala > > > > Oracle DBA > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > > -- > > > > Author: Mladen Gogala > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > > > San Diego, California -- Mailing list and web hosting > services > > > > > --------------------------------------------------------------------- > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > (or the name of mailing list you want to be removed from). You may > > > > also send the HELP command for other information (like subscribing). > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Ryan > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > > San Diego, California -- Mailing list and web hosting services > > > --------------------------------------------------------------------- > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > > > > > -- > > Mladen Gogala > > Oracle DBA > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Mladen Gogala > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ryan > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Goulet, Dick > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
