News for hackers. Stuff that matters.

A comment on Traits of Serverless Architecture. Parent comment

Re:Traits of Serverless Architecture by wstrange on Monday August 19, 2019 @01:22PM (#20739686)
A lot of CIOs would dearly love to move away from Oracle. The cost of rewriting software that was not designed to be portable is immense. Oracle knows this, and keeps the pain just below the threshold where porting to postgres or mysql is cost effective.

I agree with the general sentiment that optimizing for extreme portability does not make sense- but there is a balance that needs to be struck. Designing your apps to be relatively SQL agnostic, or at least isolating those dependencies, makes a lot of sense.

[ Parent | on HN ]
Re:Traits of Serverless Architecture by scarface74 on Monday August 19, 2019 @02:45PM (#20740526)
And even if you do have a policy of “designing your apps to be SQL agnostic” and you have had that policy for 5 years over dozens of apps. Would you trust your policy enough that you would change your connection string from pointing to Oracle to pointing to MySQL and hope everything would work?

What about all of the programs that you used that depended on Oracle specific drivers. Even in a perfect world where everything was using standard SQL, would the regression testing and migrations be something you would want to tackle as a CTO? Would you be willing to take the reputational risks of something going wrong?

[ Parent | on HN ]