On: Are Commercial Databases Worth It?

[jaxn]

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.

[neilc → jaxn]

> 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).

[jaxn → neilc]

Thanks for the tip!

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