Skip to content

boostorg/mysql

This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.

Folders and files

NameName
Last commit message
Last commit date

Latest commit

acd1f09 · Oct 8, 2024
Sep 6, 2024
Jun 20, 2024
May 16, 2024
Oct 3, 2024
Sep 26, 2024
Oct 7, 2024
Dec 31, 2022
Oct 8, 2024
Sep 6, 2024
Jun 8, 2024
Dec 20, 2023
Jul 24, 2024
Jun 23, 2023
Sep 6, 2024
Mar 7, 2024
Jul 11, 2024
Apr 20, 2020
Jul 8, 2024
Aug 19, 2024
Feb 23, 2023

Repository files navigation

Boost.MySQL

Branch Windows/Linux Build OSX build Coverage Documentation
master Build Status Build Status codecov Docs for master
develop Build Status Build Status codecov Docs for develop

Boost.MySQL is a C++11 client for MySQL and MariaDB database servers, based on Boost.Asio. Boost.MySQL is part of Boost.

Breaking changes in Boost 1.85

Boost.MySQL now requires linking with Boost.Charconv, which is a compiled library. If you're getting link errors, link your executable to the Boost::charconv CMake target. No C++ code changes are required.

Feedback

Do you have any suggestion? Would you like to share a bad or good experience while using the library? Please comment on this issue.

Why another MySQL C++ client?

  • It is fully compatible with Boost.Asio and integrates well with any other library in the Boost.Asio ecosystem (like Boost.Beast).
  • It supports Boost.Asio's universal asynchronous model, which means you can go asynchronous using callbacks, futures or coroutines (including C++20 coroutines).
  • It is written in C++11 and takes advantage of it.
  • It is header only.

Using the library

To use this library, you need:

  • Boost 1.82 or higher (Boost.MySQL doesn't work with standalone Asio).
  • A C++11 capable compiler.
  • OpenSSL.

The library is header-only, but it depends on other Boost header-only libraries and on OpenSSL. To use the library, install Boost the way you would normally do (e.g. via b2 install), and create a CMakeLists.txt like this (replace main by your executable name and main.cpp by your list of source files):

project(boost_mysql_example LANGUAGES CXX)

find_package(Boost REQUIRED COMPONENTS charconv)
find_package(Threads REQUIRED)
find_package(OpenSSL REQUIRED)

add_executable(main main.cpp)
target_link_libraries(main PRIVATE Boost::charconv Threads::Threads OpenSSL::Crypto OpenSSL::SSL)

Tested with

Boost.MySQL has been tested with the following compilers:

  • gcc 5 to 14.
  • clang 3.6 to 18.
  • msvc 14.1, 14.2 and 14.3.

And with the following databases:

  • MySQL v5.7.41.
  • MySQL v8.4.1.
  • MariaDB v11.4.2.

Features

  • Text queries (execution of text SQL queries and data retrieval). MySQL refers to this as the "text protocol", as all information is passed using text (as opposed to prepared statements, see below).
  • Prepared statements. MySQL refers to this as the "binary protocol", as the result of executing a prepared statement is sent in binary format rather than in text.
  • Stored procedures.
  • Authentication methods (authentication plugins): mysql_native_password and caching_sha2_password. These are the default methods in MySQL 5 and MySQL 8, respectively.
  • Encrypted connections (TLS).
  • TCP and UNIX socket transports.
  • (Experimental) connection pools.
  • (Experimental) friendly client-side generated SQL.