← Back to team overview

maria-discuss team mailing list archive

Re: on stored procedures


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 :)

Follow ups