 | | | -none- | -none- 2007-09-05 - By Roby Sherman
Back
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
\=======================================================================
<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit
-line-break: after-white-space; ">
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
:<div><br><div><div><div>* They defaulted to INVOKERS rights (Oracle defaults to
DEFINERS)</div><div>* They didn't support DEFINERS rights on packages or
procedures (functions, yes!?)</div><div>* They didn't throw any errors on any
stored procedures that couldn't compile when "migrated" to EnterpriseDB?</div>
<div>* 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).</div><div>*
They claimed to have some compatibility with Oracle packages, but the only
thing they supported was DBMS_OUTPUT</div><div><div><br class="webkit-block
-placeholder"></div><div><div>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.</div><div><br class="webkit-block-placeholder"></div><div><br class
="webkit-block-placeholder"></div><div>--Roby</div><div><br class="webkit-block
-placeholder"></div><div><br><div><div>On Sep 5, 2007, at 6:56 PM, Ben Poels
wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div
style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px
; ">I know many people have mentioned in the past that they find Postgres a</div
><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left
: 0px; ">viable alternative to Oracle for many uses. Now there is EnterpriseDb
which</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px;
margin-left: 0px; ">is based on Postgres but takes it one step further and
claims it is Oracle</div><div style="margin-top: 0px; margin-right: 0px; margin
-bottom: 0px; margin-left: 0px; ">compatible. It even has range partitioning w/o
the extra $$$. They are</div><div style="margin-top: 0px; margin-right: 0px;
margin-bottom: 0px; margin-left: 0px; ">touting FTD, Vonage and Sony's gaming
division as major users.</div><div style="margin-top: 0px; margin-right: 0px;
margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style=
"margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Is
anyone using EnterpriseDB for there non-critical databases to save money</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left:
0px; ">on licensing? If you are, how accurate are the compatibility claims? I
know</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px;
margin-left: 0px; ">it doesn't support XMLTYPE and private synonyms for
instance. Anyone done<span class="Apple-converted-space">?</span></div><div
style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px
; ">any benchmarks?</div><div style="margin-top: 0px; margin-right: 0px; margin
-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin
-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Ben</div>
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left:
0px; ">--</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom:
0px; margin-left: 0px; "><a href="http://www.freelists.org/webpage/oracle-l"
>http://www.freelists.org/webpage/oracle-l</a></div><div style="margin-top: 0px;
margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; ">
<br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px;
margin-left: 0px; min-height: 14px; "><br></div> </blockquote></div><br></div><
/div></div></div></div></div><br><br><div> <span class="Apple-style-span" style=
"border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font
-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height: normal; text-align:
auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text
-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal;
widows: 2; word-spacing: 0px; "><div>/=========================================
==============================</div><div>|? Roby Sherman? ( r x s h e r m @ i n
t e r e a l m . c o m )</div><div>|? DBA, Architect, Computer Scientist, Pain
in the keister</div><div>|-- ---- ---- ---- ---- ---- ---- ---- ---- ---- -----
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --</div><div>|?
<a href="http://www.robysherman.org">http://www.robysherman.org</a></div><div>|=
======================================================================</div><div
>| A computer without a Microsoft operating system is like a dog without bricks
tied to it's head?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?</div><div>\================
=======================================================</div><div><br class=
"khtml-block-placeholder"></div><br class="Apple-interchange-newline"></span> <
/div><br></body></html>
|
|
|