Re: [Maria-discuss] Python 3 Handler Socket

[Richard Bensley]

No rush dude. It's a holiday in the UK. I am FULL of whiskey.

On 27 May 2018 at 22:48, Roberto Spadim <robe...@spadim.com.br> wrote:

> I can share my pyhs with python 3 here
> I didn't updated the speedup.c cause i didn't reas the python c interface,
> and string have changed
> Give me some minutes and i upload it
>
> Em dom, 27 de mai de 2018 às 18:10, Richard Bensley <
> richardbens...@gmail.com> escreveu:
>
>> Hi Roberto,
>>
>> This is something I played with a few years ago in python 3.4, I had some
>> success but nothing production worthy, just hacks.
>>
>> Did you see this in the MariaDB 10.4 plans?
>>
>>
>>- Python Connector - MariaDB Foundation (Vicentiu)
>>
>> Handlersocket should definitely be a feature of the connector and I really
>> want to help with this!
>>
>> MS and IBM have already done great work to integrate python for analytics
>> workloads with their databases and to overcome the biggest overhead;
>> serialisation.
>>
>> I would love to help MariaDB with the python connector.
>>
>>
>> On 26 May 2018 at 12:19, Roberto Spadim <robe...@spadim.com.br> wrote:
>>
>>> Hi guys!
>>> Any link to a working handler socket python module?
>>> pyhs is old and working only with python2, we need to update the C lib
>>> or use plain python with python3 (i did some changes, don't know if there's
>>> a running job on this)
>>>
>>> --
>>> Roberto Spadim
>>>
>>> ___
>>> 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
>>>
>>>
>> --
> Roberto Spadim
> SPAEmpresarial - Software ERP
> Eng. Automação e Controle
>



-- 
Richard Bensley
github.com/mathnode
___
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

Re: [Maria-discuss] Python 3 Handler Socket

[Richard Bensley]

Hi Roberto,

This is something I played with a few years ago in python 3.4, I had some
success but nothing production worthy, just hacks.

Did you see this in the MariaDB 10.4 plans?


   - Python Connector - MariaDB Foundation (Vicentiu)

Handlersocket should definitely be a feature of the connector and I really
want to help with this!

MS and IBM have already done great work to integrate python for analytics
workloads with their databases and to overcome the biggest overhead;
serialisation.

I would love to help MariaDB with the python connector.


On 26 May 2018 at 12:19, Roberto Spadim  wrote:

> Hi guys!
> Any link to a working handler socket python module?
> pyhs is old and working only with python2, we need to update the C lib or
> use plain python with python3 (i did some changes, don't know if there's a
> running job on this)
>
> --
> Roberto Spadim
>
> ___
> 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

Re: [Maria-discuss] on stored procedures

[Richard Bensley]

> 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
___
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

Re: [Maria-discuss] on stored procedures

[Richard Bensley]

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  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 secur...@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
>
___
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

Re: [Maria-discuss] MariaDB Server 10.3 notes

[Richard Bensley]

With hyper-v becoming free, the arrival of the Linux subsystem, and docker
for windows 10; there isn't much of an excuse to proclaim you are unable to
use the Linux binaries. The Redis and Postgres devs are already rejoicing.
___
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

Re: [Maria-discuss] MariaDB Server 10.3 notes

[Richard Bensley]

Is anyone surprised by the lack of TokuDB support? Percona is primarily an
Oracle MySQL fork . The InnoDB changes in MySQL 8 represent something
entirely different. Good, but different.

I don't think I am being too speculative when I say, I am sure Oracle are
in no hurry to make MySQL a serious contender to Oracle just yet! But
MariaDB could.

Me and many others had hope that TokuDB would be the death of InnoDB in
MariaDB, and the catalyst to a truly amazing open source database.

RocksDB can still come into play later, but it's not going to help users
migrate from other RDBM systems, fix existing "missing" features from
MariaDB, nor is it anything I don't think, existing TokuDB users care
about.

Richard
___
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

Re: [Maria-discuss] New Question: SQL Server replication to Maria DB

[Richard Bensley]

It would be much faster to use bcp to dump the data, and load it into
mariadb using the 'LOAD DATA INFILE' command.

You can use freebcp from the mariadb server to get data from mssql.

Rich
___
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