[Maria-discuss] on stored procedures
Some good points from Bill Karwin: https://www.quora.com/What-are-the-reasons-not-to-use-or-not-use-stored-proc... Federico
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. Regards, Sergei Chief Architect MariaDB and security@mariadb.org
We discussed it here and it seemed vary popular. WL-820. On Mon, Nov 7, 2016 at 10:43 AM, Sergei Golubchik <serg@mariadb.org> wrote:
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.
Regards, Sergei Chief Architect MariaDB and security@mariadb.org
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Hi, Justin! On Nov 07, Justin Swanhart wrote:
We discussed it here and it seemed vary popular. WL-820.
I know, right? A cool and useful feature, I'd say. I cannot understand why it's constantly being pushed down for the last 10 years. I still hope we get it someday.
On Mon, Nov 7, 2016 at 10:43 AM, Sergei Golubchik <serg@mariadb.org> wrote:
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.
Regards, Sergei Chief Architect MariaDB and security@mariadb.org
Well, because the change to the parser and the VIO layer were major, and because it wasn't merged, it drifted, and it really drifted as major releases were added. At this point, with the X protocol, and changes to triggers so that you can have more than one, and various other changes, it is very hard to merge. I gave a go at it, but I'm not familiar enough with the server to do it, so I gave up. I came up with a different way to run SQL in the server, and for plugging in other languages I just use the gearman UDF which runs them out of process safely (but they can't run SQL on the THD, if they want to use a connection they have to create a new one). On Mon, Nov 7, 2016 at 4:42 PM, Sergei Golubchik <serg@mariadb.org> wrote:
Hi, Justin!
On Nov 07, Justin Swanhart wrote:
We discussed it here and it seemed vary popular. WL-820.
I know, right?
A cool and useful feature, I'd say. I cannot understand why it's constantly being pushed down for the last 10 years.
I still hope we get it someday.
On Mon, Nov 7, 2016 at 10:43 AM, Sergei Golubchik <serg@mariadb.org> wrote:
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.
Regards, Sergei Chief Architect MariaDB and security@mariadb.org
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 :)
There are a great many uses for stored procedures. They can eliminate round trips, and they can encapsulate logic in the database. It is a pity that MySQL stored procedures are so limited that hey do not even encapsulate the full standard, and require difficult constructs by not implementing "for" loops, and other language conveniences. But they are very powerful. I am probably the only person outside of Oracle to publish open source tools that rely on them heavily, because the logic they employ belongs in the database (Flexviews and PS_history being the primary two). As an example from Oracle, the sys schema uses stored functions to great effect. Just because something is clunky, it does not make it worthless, it simply means that more effort has to be put in to get the desired result, but the effort can very well be worth it. On Tue, Nov 8, 2016 at 4:29 AM, Игорь Пашев <pashev.igor@gmail.com> wrote:
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-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 :)
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
I forgot about 'async'. It is a multi-threaded asynchronous (and client agnostic) SQL queue built entirely from MySQL primitives with no external dependencies. On Tue, Nov 8, 2016 at 7:45 AM, Justin Swanhart <greenlion@gmail.com> wrote:
There are a great many uses for stored procedures. They can eliminate round trips, and they can encapsulate logic in the database. It is a pity that MySQL stored procedures are so limited that hey do not even encapsulate the full standard, and require difficult constructs by not implementing "for" loops, and other language conveniences. But they are very powerful. I am probably the only person outside of Oracle to publish open source tools that rely on them heavily, because the logic they employ belongs in the database (Flexviews and PS_history being the primary two). As an example from Oracle, the sys schema uses stored functions to great effect.
Just because something is clunky, it does not make it worthless, it simply means that more effort has to be put in to get the desired result, but the effort can very well be worth it.
On Tue, Nov 8, 2016 at 4:29 AM, Игорь Пашев <pashev.igor@gmail.com> wrote:
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-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 :)
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
I would LOVE to see the SQL language receive extensions, or the ability to plugin a scripting language; something useful like Guile or Lua (not javascript, what is wrong with people?). Will we ever see a return of prepared statement parameters that were introduced then removed in 10.2? I can achieve a lot more with Routines, Functions, and CONNECT than I can with a scripting library. Rich On 7 November 2016 at 15:43, Sergei Golubchik <serg@mariadb.org> wrote:
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.
Regards, Sergei Chief Architect MariaDB and security@mariadb.org
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
What do you mean?
Sorry Sergei, my mistake, I mean Out Parameters, https://mariadb.com/kb/en/mariadb/out-parameters-in-prepare/ They are still there. I thought they were removed for some reason. Rich
participants (5)
-
Federico Razzoli -
Justin Swanhart -
Richard Bensley -
Sergei Golubchik -
Игорь Пашев