News for hackers. Stuff that matters.
Re:Your templating engine sucks and everything you've ever w... by pyre on Sunday December 11, 2011 @01:48AM (#3339485)

  > I've worked (and work) on old projects with hundreds
  > of SQL queries spread throughout the code,
So have/do I. The fact that there is SQL inlined with the code is probably the least of your worries when talking about such a large/old code base.
Re:Your templating engine sucks and everything you've ever w... by postfuturist on Sunday December 11, 2011 @02:52AM (#3339576)
Actually, the bits of SQL everywhere is the #1 problem with the code. We spent weeks just auditing them all to remove SQL injection vulnerabilities. All the SQL are fragile bits of code, difficult to write meaningful unit tests for, since you can't separate database interaction from logic, etc.
Re:Your templating engine sucks and everything you've ever w... by einhverfr on Sunday December 11, 2011 @03:52AM (#3339664)
Been there too, which is why I like stored procedures now (testability, clean code, predictability).