Boost logo

Boost :

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

> 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
> <>
> <>
> _______________________________________________
> Unsubscribe & other changes:

Richard Hodges
office: +442032898513
home: +376841522
mobile: +376380212

Boost list run by bdawes at, gregod at, cpdaniel at, john at