DEV Community

Fixing relational DB mistakes: wrong keys

Kasey Speakman on May 16, 2018

We have a number of legacy applications which are integrated through a database. If an Integration Database anti-pattern that wasn't bad enough, in...
Collapse
 
martinhaeusler profile image
Martin Häusler

When I see something like this, I get a very strong inner urge to run as far away as humanly possible and hide under the next rock. These things are no fun, I've been in similar situations myself, sometimes it cannot be avoided. Thanks for the thorough explanation.

Collapse
 
kspeakman profile image
Kasey Speakman • Edited

We avoided making this change for literally years because it was too hard. But once we sat down and mapped out how we could pull it off without taking the system down, it turned out it wasn't so bad. Definitely a lot of work, but it will let us alleviate many different pain points for our users. And package it for the cloud.

Collapse
 
barryosull profile image
Barry O Sullivan

Great article Kasey.