3 ms·
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
by ams6110 18y ago
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.
- jaxn 18y agoCONNECT 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 18y ago> 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 18y agoThanks for the tip! The list of features that justify using a commercial database keeps getting shorter each year.