I have been hearing a bit of buzz about EnterpriseDB latley. 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.
Another much more mature product based on PostgreSQL is the Netezza Database Appliance:
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.
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.
(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 email@example.com
President & CEO