News for hackers. Stuff that matters.
Re:ArangoDB by Pxtl on Friday December 06, 2013 @09:56AM (#6861314)
Personally I loathe stored procedures because often they include a lot of logic that shouldn't be on the database and they also generally involve SQL extenstions that are pretty terrible for the general-purpose computing you see them used for.

But if that layer is primarily used for providing, controlling, and optimizing access to the data I can see the appeal. And in that case? Being able to write the procedural parts in a language that's less-terrible than typical SQL extensions would be really nice.

Re:ArangoDB by jeffdavis on Friday December 06, 2013 @11:45AM (#6861968)
"Being able to write the procedural parts in a language that's less-terrible than typical SQL extensions would be really nice."

Postgres allows writing functions in many languages, including C, python, and javascript.

Re:ArangoDB by ArbitraryLimits on Friday December 06, 2013 @12:14PM (#6862166)
Exactly, the problem with stored procedures isn't that they exist but that once a programmer is working in a given environment he won't change to another one until forced, with the result that once someone starts writing stored procedures they tend not to stop until the app is in the database. If there were a clear mechanism to stop app data from going in the SPs they'd have a much better reputation.