Re:Amazon Aurora Backtrack
by scarface74 on Thursday May 10, 2018 @12:56PM
(#17040657)
Or "I'm going to put a facade over my database access because I don't want to be locked in to one vendor". Hardly anyone ever changes there database vendors just to save a few dollars.
[ Parent
| on HN ]
In 23 years I've worked on one project that moved databases. Client requirement, huge system that Oracle was the best match for.
Also, one that was a licensed software that needed to support DB2, Oracle and MS-SQL to integrate with various state's agencies. The former was a huge pain, the latter was horrible to write code for.
For the most part, you use what works for you and stick with it. The more risky a platform, the less you rely on features like stored procedures, etc. In the end, I'd rather have vendor lock-in than have to write complex queries three times, and other really cumbersome abstractions, slowing things down a lot! Extrapolating to services beyond the DB.
In the end, the db migration was far less time/effort than maintaining an untethered software.