Boost C++ Libraries

...one of the most highly regarded and expertly designed C++ library projects in the world. — Herb Sutter and Andrei Alexandrescu, C++ Coding Standards

Chapter 1. Boost.MySQL

Ruben Perez

Copyright © 2019-2024 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

Tutorial 1: hello world!

Tutorial 2: going async with C++20 coroutines

Tutorial 3: queries with parameters

Tutorial 4: the static interface

Tutorial 5: UPDATEs, transactions and semicolon-separated queries

Tutorial 6: Connection pools

Tutorial 7: Error handling

Connection establishment
Running queries
The dynamic and the static interfaces
Running INSERT, UPDATE and DELETE statements
Single outstanding async operation per connection
Error handling
Multi-function operations
Connection pools

Connection establishment and termination

Authentication
Connect with database
TLS support
UNIX sockets
Changing the network buffer size limit
Enabling multi-queries
Closing a connection
Reconnection and long-lived connections

Text queries and client-side SQL formatting

Using with_params for simple queries
Common errors and how to fix them
Prepared statements vs. client-side SQL formatting

Prepared statements

The dynamic interface

The static interface

Multi-resultset: stored procedures and multi-queries

Multi-function operations

Connection pools

Going async

Interfacing sync and async code: using connection_pool in sync code

Error handling and available overloads

Advanced client-side SQL query formatting

Formatting queries without executing them
Formatting ranges with sequence
Format specifiers
Extending format_sql
Types with built-in support for SQL formatting

Character sets and collations

Time types: date, datetime and time

The legacy connection class

(Experimental) Pipelines

Benchmarks against the official connectors

Tutorial 1 listing: hello world!
Tutorial 2 listing: going async with C++20 coroutines
Tutorial 3 listing: queries with parameters
Tutorial 4 listing: the static interface
Tutorial 5 listing: UPDATEs, transactions and multi-queries
Tutorial 6 listing: connection pools
Tutorial 7 listing: error handling
INSERTs, last_insert_id() and NULL values
DELETEs and affected_rows()
Prepared statements
Disabling TLS for a connection
Setting TLS options: enabling TLS certificate verification
Metadata
Reading rows in batches with multi-function operations
Callbacks (async functions in C++11)
Stackful coroutines (async functions in C++11)
UNIX sockets
Batch inserts using client-side query formatting
Generic batch inserts with Boost.Describe
Queries with dynamic filters
Dynamic UPDATE queries with PATCH-like semantics
Sourcing a .sql file using multi-queries
(Experimental) Pipelines
A REST API server that uses C++20 coroutines
A C++14 REST API server that uses asio::yield_context