Re:Gitlab 500 error
by mdpopescu on Tuesday June 12, 2018 @01:44PM
(#17295786)
Not a bad point. Then again, once you hit your first 1200-line stored procedure, full of logical bugs including SQL injections, you'll realize SQL isn't that amazing either :)
[ Parent
| on HN ]
If your stored procedure has 1200 lines, you're doing something wrong.
Re:Gitlab 500 error
by DisposableMike on Tuesday June 12, 2018 @03:02PM
(#17296748)
How about recreating a report to feed into a legacy system from an ERP installation with 5,000 tables and 12,000 stored procedures - none of which you're allowed to modify or face losing support?
I also try my best to avoid SQL procedures as much as possible (except for database migrations; no avoiding them there). The 1200 line procedure should definitely be written in a real programming language, but what's done is done, I guess haha.