3 ms·
> The problem of this approach is the tooling and lock-in. I've seen a program rewritten or heavily refactored on top of an existing database more times than I
by yamtaddle 4y ago
> The problem of this approach is the tooling and lock-in.
I've seen a program rewritten or heavily refactored on top of an existing database more times than I've seen the database swapped on an app that had reached production (which I've seen zero times).
Consequently, I have regard remaining "database agnostic" as having very little worth. If you pick a DB with a bunch of great features that can save you time, improve performance, and improve data integrity—use those features!
Plus, if you find yourself in that rewriting-or-heavily-refactoring job that I've seen a few times, your favorite person in the whole world will be whoever put all those annoying constraints and triggers and such in the DB itself. It'll make the operation far easier and safer.