Re: MySQL ASIO library

From: Richard Hodges (hodges.r_at_[hidden])
Date: 2020-03-04 17:35:28

On Wed, 4 Mar 2020 at 17:48, Kostas Savvidis via Boost <
boost_at_[hidden]> wrote:

>
>
> > On Mar 4, 2020, at 16:24, Ruben Perez via Boost <boost_at_[hidden]>
> wrote:
> >
> > Just to clarify, this is *not* a wrapper around the MySQL C API, it is an
> > implementation of the MySQL protocol based in ASIO.
>
> I would like to know if your software also manages the network protocol
> complexities?
> 1) Can one can talk to a server over a unix pipe or only over IP network?
>

>From looking at the code, it seems that the MySQL protocol will work on any
asio stream type, including posix streams (pipes). Setting up the stream is
a (simple) Asio concern. The communication over that stream is a mysql
concern.

> 2) In all DBI systems I have seen,
> example code starts with creating a connection object and then nobody
> explains to the
> casual user like me what is supposed to happen if the connection to the
> database is to be maintained over hours or days. Does your library  manage
> this or are we still supposed to write all the connection checking and
> reconnection code manually?
>

Asio streams do not auto-reconnect. I would imagine that if you need this,
it would be logic you have to implement over the top of this library.

In practice, using the auto-reconnect feature of the mysql C library is
problematic for anything other than the simplest of operations. Reconnected
connections forget any state they contained.

>
> Thanks,
> Kostas
>
>
> ============================================================================================
> Institute of Nuclear and Particle Physics
> NCSR Demokritos
> https://github.com/kotika/random <https://github.com/kotika/random>
> https://mixmax.hepforge.org <https://mixmax.hepforge.org/>
>
> _______________________________________________
> Unsubscribe & other changes:
> http://lists.boost.org/mailman/listinfo.cgi/boost
>

-- 
Richard Hodges
hodges.r_at_[hidden]
office: [phone]
home: [phone]
mobile: [phone]