Geeks With Blogs

The Life and Times of a Dev Yes, we're really that weird

Call me an anti-java, oracle biggot, but these technologies are driving me crazy.

First, Oracle's licensing plans are EXPENSIVE and COMPLEX.  As updated January 11th, they now consider different hardware platforms cores to rate at different levels.  For example, AMD/Intel cores are rated at .50 of a processor.  Have a four core chip?  You need two oracle processor licenses, and depending on the version of db you get, that means big bucks ($40,000 per processor for the enterprise version, YIKES!).  DB2 isn't much better.  Microsoft prices Sql Server per processor socket, so for the same machine, you'd pay a total of $20,000 for Sql Server enterprise, rather than $80,000.  And MySql is free!

As a developer using Oracle, MySql, and SqlServer (yes, all at the same time), I really can't tell much of a difference between the three.  I've seen large dbs in all three, and they all seem to do well, although MySql is a bit skimpy on most admin type stuff.  If 99% of what you need to do is supported by MySql and Sql Server, choosing to use Oracle is silly.

I've never seen, or run into a situation where any of the three wouldn't work just fine, and I've played with some very large databases (sql server doing more than 1,000,000 transactions a day, for example).

For developers, MySql and SqlServer are far easier to use and administer.  For example, I don't have to worry about large text values using ADO.NET with MySql or Sql Server, but with Oracle, you have to go back to the early ADO days where you worry about chunking and stuff.  And boy do I miss autonumber with Oracle.  Sequences with Triggers just don't cut it.

Oracle biggots, get over it.  There's a reason why Oracle is diversifying.  If they thought they could survive with just their database, they would, but I'm sure they also see their database as not having any real compelling features above other databases any more, hence, they need other cash cows.  MS has a similar problem--they're so tied to their OS that they won't release stuff for other OS's--why don't we have a linux version of Sql Server or Exchange??

Anyway, flame me if you want, don't expect a response though. :)  Since I haven't even proof read this post, its really probably not very coherent anyway!

Happy coding.

Posted on Friday, October 13, 2006 11:41 AM Work | Back to top

Comments on this post: Why I will not recommend oracle, to anyone.

# re: Why I will not recommend oracle, to anyone.
Requesting Gravatar...
MySql sucks because it lacks real referential intergity features. Innodb is slo..ow. Look at PstgresSQL, it's powerful & free.
Left by Dave on Oct 13, 2006 4:54 PM

# re: Why I will not recommend oracle, to anyone.
Requesting Gravatar...
LOL! Did you have a bad day with Oracle...??? I'm glad somebody said SOMETHING!
Left by Steve Kaschimer on Oct 13, 2006 10:34 PM

Your comment:
 (will show your gravatar)

Copyright © Robert May | Powered by: