Re:Beware of Developers Who Do Negative Work
by jholman on Monday December 19, 2016 @07:40AM
(#13211021)
Write your stored procedures in any language you like. Postgres supports pgSQL, Tcl, Perl, and Python out of the box, with third-party bindings for some other languages.
When procedural coding is necessary, use a procedural language, in your stored procedures. What's the problem?
Re:Beware of Developers Who Do Negative Work
by renolc on Monday December 19, 2016 @08:21AM
(#13211183)
Valid point. I should have been more clear in my original post. The issue was more that it was institutionalized to write all stored procedures in MS-SQL, rather than utilizing available CLR options (at least for the vast majority of the time). It should be noted that I'm complaining about a specific company's development method and not the practice altogether.
Re:Beware of Developers Who Do Negative Work
by lostboys67 on Monday December 19, 2016 @03:49AM
(#13210291)
And your point is? yes sometimes you have complex business logic but throwing way all the benefits of using a RDBS is a sign that your developers cant hack SQL properly.
Re:Beware of Developers Who Do Negative Work
by renolc on Monday December 19, 2016 @08:38AM
(#13211272)
I would be the first one to admit my SQL chops are probably lacking, so perhaps this is just my own bias revealing itself. I'm not saying to _not_ use stored procedures. I'm just saying that throwing literally _all_ of the business logic in them feels a lot like a silver bullet. I've always felt that any of the more "standard" backbend languages would be a better choice for that complexity, since their expressiveness helps to describe that complexity in a way that is easier to grok for a larger number of developers.
Re:Beware of Developers Who Do Negative Work
by lostboys67 on Monday December 19, 2016 @10:51AM
(#13212115)
you mean like COBOL :-)
You _could_ delve into cursors or long merge statements or what have you, but in business logic specifically, the code will be read and altered numerous times by several different people. In that case, a language made specifically for expressive statements is significantly easier to deal with. That's not to say that I believe the opposite is true and that _everything_ should be done in programming space. I just think there is a better balance that can be achieved, and to default having everything in either category probably means you're not balancing correctly.