News for hackers. Stuff that matters.
Re:Are Commercial Databases Worth It? by ams6110 on Thursday April 30, 2009 @07:31PM (#587756)
Where a lot of people make their mistake is in spending tens or hundreds of thousands of dollars on commercial databases and then doing nothing more than simple SELECT, UPDATE, INSERT type operations with them, bury them under an ORM and try to pretend they aren't there.

Can you get your money's worth out of a database like Oracle? I think you absolutely can if you USE the features it comes with. If you don't want to do that, or don't need those features, then you are throwing your money away.

Re:Are Commercial Databases Worth It? by jaxn on Thursday April 30, 2009 @09:04PM (#587860)
CONNECT BY PRIOR on the other hand can be a life saver.

There are projects where I really love using Oracle (and to a lesser degree SQL Server). It has everything to do with features that solve problems.

I loathe DB2 though. Also, there are some weird smaller commercial databases like Pervasive that seem to add nothing but difficult interfaces.

Re:Are Commercial Databases Worth It? by neilc on Thursday April 30, 2009 @10:28PM (#587968)
> CONNECT BY PRIOR on the other hand can be a life saver.

FWIW, the latest beta release of PostgreSQL supports recursive queries (using the SQL standard WITH RECURSIVE rather than CONNECT BY, but still).

Re:Are Commercial Databases Worth It? by jaxn on Thursday April 30, 2009 @10:56PM (#588002)
Thanks for the tip!

The list of features that justify using a commercial database keeps getting shorter each year.