[Maria-discuss] Nosql language with plugins
Could be possible use the query rewrite plugin to execute no sql commands? Something like disable sql parser and execute some specific protocol, returning standard sql datasets as result? -- Roberto Spadim SPAEmpresarial - Software ERP/Scada Eng. Automação e Controle, Eng. Financeira
MariaDB doesn't have rewrite plugins. What you want could still not be done with a preparse plugin in MySQL because there is no way to speak an arbitrary protocol. You could have a client that speaks the MySQL protocol but sends non-sql text commands that have some 1:1 match with SQL, for example MDX. For MySQL 8 I have developed an alternative rewrite plugin interface that can execute any number of SQL statements serially on the THD of the client connection, or an arbitrary THD. It would be possible to port to MariaDB but as MariaDB has deleted the KB entries related to my tools, I highly doubt they would upstream it, and I would expect some form of compensation/sponsorship from you if you wanted me to do it. In any case the plugin would still not speak arbitrary binary protocols. MySQL 8 supports the X protocol for document access. It would probably be possible to create an X protocol proxy that speaks arbitrary protocols but that would be a big project that probably not many people would be interested in. On Wed, Apr 29, 2020, 9:14 PM Roberto Spadim <roberto@spadim.com.br> wrote:
Could be possible use the query rewrite plugin to execute no sql commands? Something like disable sql parser and execute some specific protocol, returning standard sql datasets as result? -- Roberto Spadim SPAEmpresarial - Software ERP/Scada Eng. Automação e Controle, Eng. Financeira _______________________________________________ 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
Actually, why have those pages been deleted?The KB includes pages on 3rd party tools. And I think those tools are valid (actually I created the pages). Federico On Thursday, 30 April 2020, 02:49:16 BST, Justin Swanhart <greenlion@gmail.com> wrote: MariaDB doesn't have rewrite plugins. What you want could still not be done with a preparse plugin in MySQL because there is no way to speak an arbitrary protocol. You could have a client that speaks the MySQL protocol but sends non-sql text commands that have some 1:1 match with SQL, for example MDX. For MySQL 8 I have developed an alternative rewrite plugin interface that can execute any number of SQL statements serially on the THD of the client connection, or an arbitrary THD. It would be possible to port to MariaDB but as MariaDB has deleted the KB entries related to my tools, I highly doubt they would upstream it, and I would expect some form of compensation/sponsorship from you if you wanted me to do it. In any case the plugin would still not speak arbitrary binary protocols. MySQL 8 supports the X protocol for document access. It would probably be possible to create an X protocol proxy that speaks arbitrary protocols but that would be a big project that probably not many people would be interested in. On Wed, Apr 29, 2020, 9:14 PM Roberto Spadim <roberto@spadim.com.br> wrote: Could be possible use the query rewrite plugin to execute no sql commands? Something like disable sql parser and execute some specific protocol, returning standard sql datasets as result?-- Roberto Spadim SPAEmpresarial - Software ERP/ScadaEng. Automação e Controle, Eng. Financeira_______________________________________________ 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 _______________________________________________ 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
Seems I didn't get Federico's reply. The answer is because: War, war never changes... I made a stink about BSL, and I have shamed Monty in public. MariaDB recently created a sock puppet LinkedIn account to attack me for my religious views. We are at war On Wed, Apr 29, 2020, 9:48 PM Justin Swanhart <greenlion@gmail.com> wrote:
MariaDB doesn't have rewrite plugins.
What you want could still not be done with a preparse plugin in MySQL because there is no way to speak an arbitrary protocol. You could have a client that speaks the MySQL protocol but sends non-sql text commands that have some 1:1 match with SQL, for example MDX.
For MySQL 8 I have developed an alternative rewrite plugin interface that can execute any number of SQL statements serially on the THD of the client connection, or an arbitrary THD. It would be possible to port to MariaDB but as MariaDB has deleted the KB entries related to my tools, I highly doubt they would upstream it, and I would expect some form of compensation/sponsorship from you if you wanted me to do it. In any case the plugin would still not speak arbitrary binary protocols.
MySQL 8 supports the X protocol for document access. It would probably be possible to create an X protocol proxy that speaks arbitrary protocols but that would be a big project that probably not many people would be interested in.
On Wed, Apr 29, 2020, 9:14 PM Roberto Spadim <roberto@spadim.com.br> wrote:
Could be possible use the query rewrite plugin to execute no sql commands? Something like disable sql parser and execute some specific protocol, returning standard sql datasets as result? -- Roberto Spadim SPAEmpresarial - Software ERP/Scada Eng. Automação e Controle, Eng. Financeira _______________________________________________ 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
*crickets* On Fri, May 8, 2020, 2:33 PM Justin Swanhart <greenlion@gmail.com> wrote:
Seems I didn't get Federico's reply. The answer is because: War, war never changes...
I made a stink about BSL, and I have shamed Monty in public.
MariaDB recently created a sock puppet LinkedIn account to attack me for my religious views.
We are at war
On Wed, Apr 29, 2020, 9:48 PM Justin Swanhart <greenlion@gmail.com> wrote:
MariaDB doesn't have rewrite plugins.
What you want could still not be done with a preparse plugin in MySQL because there is no way to speak an arbitrary protocol. You could have a client that speaks the MySQL protocol but sends non-sql text commands that have some 1:1 match with SQL, for example MDX.
For MySQL 8 I have developed an alternative rewrite plugin interface that can execute any number of SQL statements serially on the THD of the client connection, or an arbitrary THD. It would be possible to port to MariaDB but as MariaDB has deleted the KB entries related to my tools, I highly doubt they would upstream it, and I would expect some form of compensation/sponsorship from you if you wanted me to do it. In any case the plugin would still not speak arbitrary binary protocols.
MySQL 8 supports the X protocol for document access. It would probably be possible to create an X protocol proxy that speaks arbitrary protocols but that would be a big project that probably not many people would be interested in.
On Wed, Apr 29, 2020, 9:14 PM Roberto Spadim <roberto@spadim.com.br> wrote:
Could be possible use the query rewrite plugin to execute no sql commands? Something like disable sql parser and execute some specific protocol, returning standard sql datasets as result? -- Roberto Spadim SPAEmpresarial - Software ERP/Scada Eng. Automação e Controle, Eng. Financeira _______________________________________________ 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
participants (3)
-
Federico Razzoli -
Justin Swanhart -
Roberto Spadim