Oracle: Don't hate it just because you don't get it, get it?

Random Recent Oracle Stuff

TrackBack — Wed, 08 Dec 2004 13:17:00 GMT

re: Oracle: Don't hate it just because you don't get it, get it?

Clint — Tue, 07 Dec 2004 01:43:00 GMT

I have installed, admined, and programmed Oracle 8i and 9i, SQL Server 2000, Postgresql 7, and MySQL 4. Here are my observations.

Oracle 8i/9i
-------------
admin/install - I curse thee at the top of my lungs.
features - Unbeatable, unmatched.

SQL Server 2000
-------------------
admin/install - Easy as cake, the way it should be.
features - I started out on Oracle, so compared to Oracle I felt restricted in my options. Some shortcomings were a major PITA but mostly because I was spoiled by Oracle.

PostgreSQL
----------------
admin/install - Way easier than Oracle, slightly harder than SQL Server 2000.
features - A poor man's Oracle. Matches almost all the features from Oracle that I use.

MySQL
----------------
admin/install - Same as Postgres.
features - Crap, see ya later.

My ideal database would be the cost/license of PostgreSQL, ease of admining and installation of SQL Server 2000, and the feature set and stability of Oracle.

re: Oracle: Don't hate it just because you don't get it, get it?

Guy S. — Sat, 04 Dec 2004 17:29:00 GMT

If this could be easily done I would install an Oracle developer edition on my PC and use it for my training purposes - but the tools r still problematic. The DB and its related build in features r assume and as Frans pointed lots of Yukon "amazing" stuff were supported in Oracle for a long time.

I had the opportunity to work with pl/sql for few months and I found it enjoyable and comfortable much like working with a real language and not just scripts.

re: Oracle: Don't hate it just because you don't get it, get it?

Brendan Tompkins — Fri, 03 Dec 2004 14:19:00 GMT

I agree with Frans. My last experience with Oracle was in 1999, when it "Just Worked" and SQL Server "Just Crashed" (This was before SQL 2000, and now SQL Server "Just Works.") I agree that you can't judge a db by the tools you use to manage it. Strange. There's so many apps out there that are truly deserved of harsh harsh critcisim (can you say Crustal?) that I just don't get the oracle bashing.

re: Oracle: Don't hate it just because you don't get it, get it?

Frans Bouma — Fri, 03 Dec 2004 09:31:00 GMT

Oracle is a kick-ass database. The tools are crap, the database isn't. However if you use toad, there is nothing to wish for.

Remember: a database is there to do things database related. Oracle has more functionality than SqlServer 2000 has, and even Yukon will not come close to Oracle 10g.

DB2's tools are even worse than Oracle's. Still DB2 even beats Oracle for features. Do you think DB2 became marketleader because it sucks so much? No, because it kicks ass in featureset, same for oracle.

For example, try to do a live backup on a production system on sqlserver without losing 1 row. You can't (locked rows are not backupped). This kind of silly things make or break a database in enterprise environments.

Admitted, I have questioned the reasoning behind some of Oracle's constructs as well, but most of them are tool related, not database related and often it's legacy type support (like the good old LONG type, no-one uses that one anymore.

So, albeit funny, that IHOC should be renamed to IHOTC (I Hate Oracle Tools Club).

Don't Hate Oracle Because it's Beautiful

TrackBack — Fri, 03 Dec 2004 08:28:00 GMT

Don't Hate Oracle Because it's Beautiful

re: Oracle: Don't hate it just because you don't get it, get it?

Sahil Malik — Fri, 03 Dec 2004 02:19:00 GMT

And talking about oracle consultants, you've gotta check this thread out ---

http://dotnetjunkies.com/WebLog/sahilmalik/archive/2004/11/28/33936.aspx

(Check out the link in the comments too -- the one about "Icing on the cake").

IMHO, You have to be mentally sick to work in Oracle to start with. Which that guy clearly is.

re: Oracle: Don't hate it just because you don't get it, get it?

Sahil Malik — Fri, 03 Dec 2004 02:16:00 GMT

Roy,

You've gotta read this thread man !!!

http://dotnetjunkies.com/WebLog/sahilmalik/archive/2004/08/28/23563.aspx

And women and oracle are not a fair comparison. Women are desirable, oracle is as desirable as yeti's ass.

Oooh .. who did I piss off now !!

Oracle Rant, by proxy

TrackBack — Thu, 02 Dec 2004 21:49:00 GMT