The first stable release of Pgfe 2 (PostGres FrontEnd) has been published, an advanced and multifunctional driver (client API) for PostgreSQL, written in C++ and simplifying work with PostgreSQL in C++ projects. The project's code is distributed under the Apache 2.0 license. A compiler supporting the C++17 standard is required for building.
Main Features:
- Connection in blocking and non-blocking modes.
- Handling prepared statements with positional and named parameters.
- Enhanced 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 transmission between the client and proxy server (for example, conversions between PostgreSQL arrays and STL containers).
- Support for a pipeline request transmission mode, allowing for a significant acceleration of a large number of minor write operations (INSERT/UPDATE/DELETE) by sending the next request without waiting for the result of the previous one.
- Support for Large Objects for streaming access to large datasets.
- Support for the COPY operation to copy data between a file and the database.
- 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
