|Problems? Is your data what you think it is?|
Re: RFC: Placeholder creation for SQL statementsby sundialsvc4 (Abbot)
|on Mar 14, 2018 at 00:52 UTC||Need Help??|
Hark! Did somebody mention my name? (Let the Downvotes begin afresh!)
Nonetheless, I do happen to agree – if you don’t know in advance what SQL statement you are executing, and therefore how many placeholders it contains, then that’s another problem entirely. Whereas, if you do, there is no problem remaining to be solved.
– – –
Gentlebeings™, I have in all these years never apologized for the fact that my point-of-view on such things is affected by the somewhat-curious path that my by-now long career has taken: an admixture of Firefighter and ER Triage Nurse. I’ve seen more than my share of cleverness, and have frankly come to loathe it, because what i-n-e-v-i-t-a-b-l-y happens is that “one day there is an exception to the rule, and then all Hell breaks loose.” Because now we have what IBM calls a “Highly Pervasive (HIPER) change.” And furthermore, a needless one.
The Original Programmer™ – if (s)he is still alive – is by now comfortably two or three jobs hence. We are now the ones who are tasked with un-doing this “act of cleverness.” (Which, I assure you, none of us anticipated when laying out the application-rehabilitation project plan. This is the sort of thing that can result in financial loss in our chosen way of doing business.)
Therefore, I would say this: “If you legitimately need to do this sort of thing ... if you deem that you absolutely have no alternative but to do this ... then please proceed, and please leave-behind copious documentation.” Otherwise, pretty-please don’t do it. Please don’t create a “HIPER hot-spot” for your successors – such as my teams – to work out, when there were no technical mandates to justify your choices. Cut-and-paste is your friend.
To clarify: the #1 concern that I have – as a businessman as well as a multi-language programmer – is what I call “technical spill.” This is where the actions of a particular piece of code – or, coding practice – “spill” beyond the minimum technically-necessary boundaries, and(!) do so in such a way as to make it difficult (or, merely uncertain) to ascertain just how broadly they have “spilled.” The Original Programmer (OP) did something to coalesce all of the use-cases that (s)he was then aware of, without fully considering that one day there would be some other case that legitimately broke the mold. Therefore, I am now faced with the realization that the mold has been broken, and that I might now have been pushed into triage-mode as I race first to identify and then to contain the
Therefore, if I may say – and with utmost respect to the OP(!) – “this at-least smacks of exactly the sort of thing that I am talking about.” Without(!) in any way calling into question your technical judgment as an esteemed colleague, please do think-in-advance about me.
"AtDhVaAnNkCsE" == Thanks in Advance.