mariadb support about userver HOT 8 CLOSED

Related to the #14

from userver.

Related to the #14

from userver.

MariaDB does support an async API, and that it does also support bulk transactions in the C connector.

https://kb-mirror.mariadb.com/kb/en/non-blocking-client-library/

from userver.

There is https://github.com/mariadb-corporation/mariadb-connector-c which supports async operation, but it's LGPL licensed, so we can't vendor it, right?

from userver.

... but it's LGPL licensed, so we can't vendor it, right?

Sadly it's LGPL 2.1 licensed, so we can't even link it dynamically. Seems to me that we are out of luck here @apolukhin

from userver.

@itrofimow looks like you wanna implement mysql specific driver. Why did you decide to implement a specific driver instead of the most common odbc driver that can be used across dbms? For example, one odbc driver with small modifications can be used with mysql, oracle, ibm db and mssql.

from userver.

Honestly i just didn't think about ODBC at all at the time, that's mostly it)

Right now i also see a couple of points against that:

1. It gets very complicated and time consuming to test the driver against many database implementations - infrastructure isn't quite there (for example i'll have to sneak some ugly bash into testsuite to support 3 different MySQL and friends installations).
2. With MySQL being potentially very popular it makes sense to have an optimized driver for that DB specifically
3. Maintaining general purpose ODBC implementation might quickly become overwhelming with all the potential issues coming from interaction with different DB backends, for which i likely just won't have enough time/will

from userver.

We just merged MySQL/MariaDB driver

from userver.