EnterpriseDB

THis isn’t news but I just recently gave EnterpriseDB a spin.

If imitation is the sincerest form of flattery, Larry Ellison’s giant ego will be getting even bigger.

EnterpriseDB bills itself as an Oracle compatible database. It is PostgeSQL with a PL/SQL and SQLPLUS layer on top of it. Most Oracle PL/SQL apps and scripts are said run on it.
The focus is on the app side. The administration is still largely PostgreSQL though some of the Oracle DBA views are replicated.

With Oracle giving away low end versions, Express and StandardOne, I don’t see a lot of incentive for the Oracle compatibility. PostgreSQL on its own has enough merit that this is still worthwhile though. Some Oracle compatibility is just a bit of icing perhaps.

Advertisements

One Response to EnterpriseDB

  1. LewisC says:

    Hi.

    Just a note on the incentive. EnterpriseDB adds integrated enterprise functionality to postgres as part of the package, i.e. support, administrative tools, reporting, etc. Those are things you can get for postgres but you have to find them, test them for compatibility, find support, etc.

    The other selling point versus oracle express or standard edition is that with those products, when you want to scale, you need to pay more in licensing fees (not just for more CPUs but for more functionality like partitioning). With EnterpriseDB, you scale as needed. The base product has partitioning and other scaling functionality.

    Of course, the downside is that you don’t have data guard or RAC should you need those. The SQL and PL/SQL is not yet 100% compatible (and probably never will be).

    I have found postgres, and hence EnterpriseDB, administration to be fairly simple if you are already familiar with administrating other enterprise class databases (like Oracle or DB2). You have a redo log, recovery is mostly automatic, a backup is a backup, you optimize memory and buffer caches, you set database parameters, configure security. The specifics are different but the concepts are all the same.

    Thanks,

    LewisC

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: