RE: EnterpriseDB as an Oracle replacement
- From: "David Green" <thump@xxxxxxxxxxxxxxxx>
- To: <rxsherm@xxxxxxxxxxxxx>, <ben.poels@xxxxxxxxxx>
- Date: Thu, 6 Sep 2007 18:55:43 -0700
What version did you eval?
8.2 made huge strides in the right direction and 8.3 will go further towards
improving the "compatibility" and inclusion of more coolness.
The EDB partitioning model is closer in comparison to the old school
partition views with check constraints model we used to have to employ under
Oracle 7.se the right direction and 8.3 will
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Roby Sherman
Sent: Wednesday, September 05, 2007 7:00 PM
To: ben.poels@xxxxxxxxxx
Cc: oracle-l
Subject: Re: EnterpriseDB as an Oracle replacement
We evaluated it a few months ago and found that the compatibility was not
great in several areas. In the case of PL/SQL stored procedures, for
example, they lacked support even for the most basic things that we were
looking for, such as:
* They defaulted to INVOKERS rights (Oracle defaults to DEFINERS)
* They didn't support DEFINERS rights on packages or procedures (functions,
yes!?)
* They didn't throw any errors on any stored procedures that couldn't
compile when "migrated" to EnterpriseDB
* There's was no status indicator that tells you that the code is even
broken (short of trying to run it and finding out the hard way).
* They claimed to have some compatibility with Oracle packages, but the only
thing they supported was DBMS_OUTPUT
Obviously this isn't the full and comprehensive list and, perhaps, you
don't care about PL/SQL compatibility, but if you have other areas you are
concerned about, shoot me an e-mail and I'll try to share what I can.
--Roby
On Sep 5, 2007, at 6:56 PM, Ben Poels wrote:
I know many people have mentioned in the past that they find Postgres a
viable alternative to Oracle for many uses. Now there is EnterpriseDb which
is based on Postgres but takes it one step further and claims it is Oracle
compatible. It even has range partitioning w/o the extra $$$. They are
touting FTD, Vonage and Sony's gaming division as major users.
Is anyone using EnterpriseDB for there non-critical databases to save money
on licensing? If you are, how accurate are the compatibility claims? I know
it doesn't support XMLTYPE and private synonyms for instance. Anyone done
any benchmarks?
Ben
--
//www.freelists.org/webpage/oracle-l
/=======================================================================
| Roby Sherman ( r x s h e r m @ i n t e r e a l m . c o m )
| DBA, Architect, Computer Scientist, Pain in the keister
|---------------------------------------------------------------------------
-------------------------------------------
| http://www.robysherman.org
|=======================================================================
| A computer without a Microsoft operating system is like a dog without
bricks tied to it's head
\=======================================================================
Other related posts:
