Chapter 1. Boost.MySQL

Boost C++ Libraries

Chapter 1. Boost.MySQL

Ruben Perez

Copyright © 2019-2023 Ruben Perez

Distributed under the Boost Software License, Version 1.0. (See accompanying file LICENSE_1_0.txt or copy at http://www.boost.org/LICENSE_1_0.txt)

Table of Contents

Introduction

Integrating Boost.MySQL into your project

Header-only mode
Separate compilation mode

Connection objects
Connection establishment
Text queries and prepared statements
The dynamic and the static interfaces
Resultsets
Prepared statements
Error handling
Asynchronous functions
Multi-function operations

The dynamic interface

The static interface

Text queries

Prepared statements

Multi-resultset: stored procedures and multi-queries

Multi-function operations

Going async

UNIX sockets and other stream types

Error handling and available overloads

Handshake parameters

Reconnecting a MySQL connection

Character sets

Time types: date, datetime and time

Async functions using callbacks
Async functions using futures
Async functions using stackful coroutines
Async functions using C++20 coroutines
Timeouts
Using prepared statements with the dynamic interface (C++11)
Using prepared statements with the static interface (C++14)
Using stored procedures with the dynamic interface (C++11)
Using stored procedures with the static interface (C++14)
Metadata
UNIX sockets
Setting SSL options
Using multi-queries to source a .sql file

Building and running the tests