2 ms·
Oracle is a very good database indeed. You give it data, it gives it back utterly reliably and very fast. You send it crappy queries, it optimises the hell out
by davidgerard 11y ago
Oracle is a very good database indeed. You give it data, it gives it back utterly reliably and very fast. You send it crappy queries, it optimises the hell out of them. It's clunky and laborious to program and administer, but it works superlatively.
The problem is literally everything else about dealing with Oracle in any manner.
There used to be no real alternative. Fortunately, almost everyone with Oracle doesn't need something that ridiculously powerful, and Postgres is in fact the 99% solution.
- marcosdumay 11y ago> You give it data, it gives it back utterly reliably and very fast. Well, it does... if you massage your data correctly, cause Oracle does not support many formats, and if it does not return some cryptic error for a condition that you'd never expect to exist in a DBMS.
- davidgerard 11y agoThis is true. If it's still the 1990s, you can live with this. In 2015, its annoyance factor can get a bit much.