maria-discuss team mailing list archive

[Игорь Пашев <pashev.igor@xxxxxxxxx>]

2016-11-07 18:43 GMT+03:00 Sergei Golubchik <serg@xxxxxxxxxxx>:
> 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-procedures/answer/Bill-Karwin
>
> 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 :)