• amy26 - Tuesday, September 11, 2018 10:29 AM

    Sorry, the argument isn't over storing it as XML ... which was perhaps an explanation error on my part.  The argument is just over a single table with a blob field storing every value for a data element using string based values instead of keys etc.  They do put some XML into the blob field...but most of the values are just straight characters.  It is also pure laziness and no regard for proper design.  Especially after having me (for months now) labor to create all the said proper tables and then cause one developer complained "boo hoo I have to change my code", he apparently had enough clout to have it remain as is.  I don't really care if the data is stored as XML or not, its just this single table thing that is going to get SUPER huge and some of our data records are one to many relationships... so not quite sure how the hell they plan to handle that.

    Are you telling me you spent months designing tables in isolation from your developers? Maybe we should drop the design questions here and you could go into more detail on the process you're burdened with operating within. How did they finish code that they cannot now change, if the tables weren't done? Clearly there should have been some agreement on table structure before either of you started, why didn't that happen?