Re: Presenting BoostServerTech chat

From: Klemens Morgenstern (klemensdavidmorgenstern_at_[hidden])
Date: 2023-09-07 15:38:08

> The example I have in mind is an actual database server (not client) which
> uses Boost.Asio to handle SELECT, UPDATE, CREATE TABLE sql statements, etc.
>
> The challenges posed by a database server are quite general and will apply
> to many applications, and I would guess that any developer considering
> using Boost.Asio for handling asynchronous I/O operations will have
> questions along the lines of:
>
>    - How should I handle longer requests that are delegated to a thread
>    pool, especially with respect to resource contention? E.g. An UPDATE query
>    to table A should lock table A so that asynchronous SELECT queries on A
>    don't read inconsistent data.
>

Why would asio be a good idea for anything but the IO in a database server?