Re: EnterpriseDB as an Oracle replacement

From: Roby Sherman <rxsherm_at_interealm.com>
Date: Wed, 5 Sep 2007 19:59:38 -0600
Message-Id: <52768FB7-41B7-4768-B121-3349FC744C2B@interealm.com>

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
> --
> http://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

\=======================================================================

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 05 2007 - 20:59:38 CDT