pf » EnterpriseDB - PostgreSQL with Oracle Compatibility

Another much more mature product based on PostgreSQL is the Netezza Database Appliance:

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.

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.

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.

I have some issues with CA as well, but none the less they did invest in ingres development, and fundamentally it is a strong database contender - especially when the price tag is zero.

(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

Avoid EnterpriseDB at all costs! I worked for them and they're about as open source as a four star general on meth! A couple of developers are okay, actually, but management is an enterprise class ASS.

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