2016-11-07 18:43 GMT+03:00 Sergei Golubchik <serg@mariadb.org>:
Hi, Federico!
On Nov 07, Federico Razzoli wrote:
Some good points from Bill Karwin: https://www.quora.com/What-are-the-reasons-not-to-use-or-not-use-stored-proc...
Thanks.
These are valid points, and some of them are related. For example, "does not have a rich library of functions or standard procedures" that follows from "does not support packages". Which might be fixed in https://jira.mariadb.org/browse/MDEV-10591
External languages for stored procedures - that's a very cool feature, and patches exist for many years. But, apparently, it's more cool than practically useful? There were almost no requests for it, not when I was in MySQL, not in MariaDB. And, frankly, I do not know why, this looks insanely useful to me.
I value stored procedures only for maintenance tasks and only in the `mysql` DB. Anything else is PITA :)