The first stable release of Pgfe 2 (PostGres FrontEnd), an advanced and feature rich driver (client API) for PostgreSQL written in C++ and making it easier to work with PostgreSQL in C++ projects, has been published. The project code is distributed under the Apache 2.0 license. Build requires a compiler that supports the C++17 standard.
Key features:
- Connection in blocking and non-blocking modes.
- Processing of prepared statements with positional and named parameters.
- Advanced error handling using exceptions and SQLSTATE error codes.
- Support for calling functions and procedures.
- Support for dynamic construction of SQL queries.
- Ability to convert extensible data types during transfer between client and server (for example, conversions between PostgreSQL arrays and STL containers).
- Support for pipeline requests (pipeline), which can significantly speed up the execution of a large number of small write operations (INSERT / UPDATE / DELETE) by sending the next request without waiting for the result of the previous one.
- Large Objects support for streaming access to large datasets.
- Support for the COPY operation to copy data between a file from the DBMS.
- Ability to separate SQL queries from C++ code on the client side.
- Providing a simple and reliable connection pool suitable for use in multi-threaded applications.
Source: opennet.ru