Hacker News new | past | comments | ask | show | jobs | submit login

I think if they were better integrated with the IDE and easier to debug then they would probably write better stored procedures.



And 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.


As a C# dev myself, fuck stored procedures, to be quite honest.


Please elaborate


1.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


Totally 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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: