Pete FreitagEnterpriseDB - PostgreSQL with Oracle Compatibility
Updated on November 16, 2023
By Pete Freitag
By Pete Freitag
I have been hearing a bit of buzz about EnterpriseDB lately. I think the main reason is that they just secured $7 million in venture capital funding.
What is EnterpriseDB?
EnterpriseDB is based on the source code for the open source PostgreSQL database server. PostgreSQL is the most fully featured open source database out there, they already support pretty much everything on the MySQL 5 feature list.
What the EnterpriseDB people have done is taken the PostgreSQL source code and added features to make it more compatable with Oracle.
EnterpriseDB 2005s built-in compatibility features allow most existing Oracle-based applications to run unchanged. If you are building new applications, there is no need to learn new versions of SQL syntax, data types, triggers, and stored procedures. Your existing applications - and your existing skill sets - work with EnterpriseDB.
Enterprise DB starts at Free (1CPU, 1GB Ram, 4GB data) and goes up to $5000/CPU a year with the best support options.
EnterpriseDB - PostgreSQL with Oracle Compatibility was first published on September 14, 2005.
If you like reading about enterprisedb, enterprise, oracle, databases, or postgresql then you might also like:
- SELECT a random row with SQL
- SQL Reserved Key Words Checker Tool
- Running PostgreSQL in Docker for local dev
- How to run Oracle DB on a Mac with Docker
Discuss / Follow me on Twitter ↯
Tweet Follow @pfreitagComments
postgres + features hmmmmm sounds like ingres to me!
http://opensource.ca.com/projects/ingres
postgres and ingres share common roots but ingres has benefited from extensive commercial development by computer associates, until its recent release as open source. The release 3 version was developed primarily for linux and it is basically an enterprise DB for free.
http://opensource.ca.com/projects/ingres
postgres and ingres share common roots but ingres has benefited from extensive commercial development by computer associates, until its recent release as open source. The release 3 version was developed primarily for linux and it is basically an enterprise DB for free.
by Mike T on 09/15/2005 at 4:15:58 AM UTC
Netezza sounds pretty cool, I'll have to check that out.
by Pete Freitag on 09/15/2005 at 9:34:31 AM UTC
Honestly, I giggled when I read "extensive commercial development" and CA in the same setnence. After using a number of other CA products, I would take "extensive commerical development" with at least two pounds of salt.
Pretty much any product that CA buys and takes over barely has a pulse as far as development goes. ERWin is still stuck in the Windows 3.1 days, as is their Anti-Virus product.
If their revenue is only based on their software, I have no idea why they are so big. EVERY piece of software of theirs which I've used has been terrible, not to mentioned poorly supported by workers in India (I'm not a fan of outsourcing/offshoring). No thanks.
Pretty much any product that CA buys and takes over barely has a pulse as far as development goes. ERWin is still stuck in the Windows 3.1 days, as is their Anti-Virus product.
If their revenue is only based on their software, I have no idea why they are so big. EVERY piece of software of theirs which I've used has been terrible, not to mentioned poorly supported by workers in India (I'm not a fan of outsourcing/offshoring). No thanks.
by Brandon Harper on 09/15/2005 at 9:38:44 AM UTC
(A note from the horses mouth)
EnterpriseDB is neither Neteeza nor Ingres...here are the differences...
EnterpriseDB is Postgres + Compatibility + Scalability. In other words, we stay completely up to date with the latest versions of Postgres, and add some pretty cool features like (a) compatibility with most applications written for Oracle, (b) faster performance, and (c) a 24/7 commercial-quality support organization.
Neteeza is a forked version of Postgres, placed into hardware, and optimized for very large databases. You're buying an appliance.
Ingres, as someone above has noted, has been hanging around without active development for a long time inside CA. It's a good RDBMS, hasn't had an active following for quite some time.
thoughts are welcome at andy@enterprisedb.com
Andy Astor
President & CEO
EnterpriseDB
andy@enterprisedb.com
EnterpriseDB is neither Neteeza nor Ingres...here are the differences...
EnterpriseDB is Postgres + Compatibility + Scalability. In other words, we stay completely up to date with the latest versions of Postgres, and add some pretty cool features like (a) compatibility with most applications written for Oracle, (b) faster performance, and (c) a 24/7 commercial-quality support organization.
Neteeza is a forked version of Postgres, placed into hardware, and optimized for very large databases. You're buying an appliance.
Ingres, as someone above has noted, has been hanging around without active development for a long time inside CA. It's a good RDBMS, hasn't had an active following for quite some time.
thoughts are welcome at andy@enterprisedb.com
Andy Astor
President & CEO
EnterpriseDB
andy@enterprisedb.com
by Andy Astor on 09/15/2005 at 10:33:31 AM UTC
Thanks for takign the time to comment Andy.
by Pete Freitag on 09/15/2005 at 11:17:58 AM UTC
Dear Jason T.,
I'm the co-founder and CEO of EnterpriseDB, and I don't believe we've ever met. You've certainly never worked in this company, and have no clue about our openness and contributions, which are both extensive. Thanks,
Andy Astor
I'm the co-founder and CEO of EnterpriseDB, and I don't believe we've ever met. You've certainly never worked in this company, and have no clue about our openness and contributions, which are both extensive. Thanks,
Andy Astor
by Andy Astor on 11/22/2006 at 12:18:07 PM UTC
Woohoo !!!
Old Jason T. is probably just using some anti-marketing techniques here, because PostgreSQL's Oracle compatibility is a major attraction for a very very huge Oracle client base!
Old Jason T. is probably just using some anti-marketing techniques here, because PostgreSQL's Oracle compatibility is a major attraction for a very very huge Oracle client base!
by Observer on 10/23/2009 at 12:56:32 PM UTC
http://www.netezza.com/
Basically it's a highly customized version of PostgreSQL which is highly optimized for the hardware which it ships with. Sort of an all around solution rather than having to acquire servers, software, and SAN space all at the same time. Cool stuff.
I've read that it does some pretty wicked stuff, including being able to take queries, split them up and run them as paralell queries on available CPU's for additional speed, etc. I'm sort of curious how the partioning by hashing works and how alternate WHERE clauses would affect the speed if they weren't specifically kosher for the partitioning method.
Granted it's more for data warehousing and analytics type work (which is currently my bread and butter), but still a very interesting product. I believe one of those start for around 200K, which is very hefty, but most likely worth it in the right environment.