5 ms·
I think if they were better integrated with the IDE and easier to debug then they would probably write better stored procedures.
by maxxxxx 10y ago
I think if they were better integrated with the IDE and easier to debug then they would probably write better stored procedures.
- ZanyProgrammer 10y agoAs a C# dev myself, fuck stored procedures, to be quite honest.
- intrasight 10y agoPlease elaborate
- ZanyProgrammer 10y ago1.They are a pain in the ass to keep track of in version control. 2. They are hard to debug, especially when lots of business logic gets dumped to them
- maxxxxx 10y agoTotally agree. It's hard to do code and stored procedures right with the same level of quality. The tools are different and the thinking is different.
- lmm 10y agoAnd easier to unit-test, and profile, and had a better standard library available, and... SQL is a terrible general-purpose programming language by the standards of today, which makes it a terrible way to express business logic.