Rohit You did start by saying that you did not want to start a religious war but looks like you want one. This also reminds me of early days where someone wanted a script to do something simple. Then they wanted to make sure that the script was "fool proof". They identified several use cases where the script would not work or would fail. Then in the end people started to complain that the script was too complex and 'difficult" to understand. So that is what it is - in the end you use what you want and see if that fits your over all need. How come no one is asking why ORACLE dba's are unaffordable. Or why is main frame so unaffordable. Or why a BMW is so unaffordable. ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of RP Khare Sent: Monday, November 08, 2010 9:20 AM To: richard.goulet@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: Why is Oracle unaffordable? Dick, What about BerkelyDB? I think it is meant to be an embedded DB? ________________________________ Subject: RE: Why is Oracle unaffordable? Date: Mon, 8 Nov 2010 09:14:09 -0500 From: Richard.Goulet@xxxxxxxxxxx To: passionate_programmer@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx Rohit, There is an old saying that "one gets what one pays for". That goes for database software as well. Sql*server is "nice", but it doesn't have a lot of the fault tolerance and features of Oracle. MySql is a toy that got promoted to something it was never designed for. BerkelyDB is similar, it was designed for small projects, but then got promoted to larger things. DB2 and Oracle are "similar" in robustness though feature sets are different as well as packaging. PostgreSql is somewhere between Oracle and SQL*Server, though a lot closer to Oracle. The bottom line is that a db is dependant on what you the developer want. If your looking for an imbedded DB, then I suggest you try a Google search, or possibly a visit to your local bookstore. I will agree that as an embedded db Oracle is a poor choice and there are a number of better ones out there, but many lack the recoverability, flexibility, and possibly ACID compliance of Oracle, but then maybe you don't need that. We have one application designed to reside on a laptop that uses the Java Based Apache Derby database which is open source. Fits nicely on a 8GB memory stick. Dick Goulet Senior Oracle DBA ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of RP Khare Sent: Monday, November 08, 2010 4:31 AM To: oracle-l@xxxxxxxxxxxxx Subject: Why is Oracle unaffordable? Hi, I don't want to initiate a religious war. I have been using MySQL since last two years in production environment. I used SQL Server Express and Oracle Express before. I have no complaints with either of the databases, except that Oracle is over expensive and the architecture is unnecessarily complicated. I want to know whether the complexity of the Oracle architecture and its ever demanding need for a dedicated DBA is worth paying or not. If you are an Oracle disciple, I don't want to hurt you and my views here are totally unbiased. I need an embedded database for a shrink-wrapped application. I looked around for the alternatives. I read about SQL Server CE, SQL Anywhere and BerkleyDB. I want to try BerkleyDB, but the prices are too high. You could afford and enterprise class IBM DB2 or Sybase Adaptive Server or SQL Server with a far lesser amount. Oracle is a good product but it is beyond the reach of customers other than big giants who pump in too much money just to keep those DBAs happy, who sit around that black dump command line screen. Why it can't be GUI and simple and affordable? ............... Rohit.
Please visit our website at http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html for important disclosures and information about our e-mail policies. For your protection, please do not transmit orders or instructions by e-mail or include account numbers, Social Security numbers, credit card numbers, passwords, or other personal information.