← Back to context

Comment by toomuchtodo

11 days ago

Another curious question: what use case can only be served by an Oracle DB?

Many moons ago when I was green and my skin was a lot smoother I pointed out to my then boss that we could relatively easily (a few weeks of work) move our product from Oracle to Postgres and save n x $1000 for each installation we shipped to a customer.

My personal goal was to avoid becoming an Oracle expert. (Why? Because even as someone who passed advanced Oracle training easily it was still extremely painful. One mistake towards the end of an installation could easily result in 2 days extra work to clear it out.)

Stupid as I was I said nothing about all the work we went through and only mention all the money we could save.

The response was something I learned a lot from.

It was mild and friendly and something along the lines of "here's what you don't get young lad: the customer pays for the Oracle license on top of our original price and we get a 10% cut. Changing to Postgres will effectively cost us money. Also for <this industry> when we say it is based on Oracle they feel safe."

I'm back at Oracle today after a decade of less painful options and Oracle is still painful but these days I'm not the DBA thankfully and only have to deal with connectionstrings that makes every other database look easy, different SQL syntax etc.

Anything that was previously built on Oracle and would be too much of a pain to try to migrate to something else.

The Oracle products built on top of them, such as EPM.

  • EPM products were originally built on SQLServer (or on nothing, like Essbase), and then adapted to run on Oracle. So it's more like "the products commercially forced to run on Oracle, like EPM".

    Not that it matters that much - there are better EPM/CPM products now available, like OneStream ;)