Published The first stable release PGFE 2 (Postgres Frontend), advanced and multifunction driver (client API) for PostgreSQL written in C ++ and simplifying work with PostgreSQL in projects on C ++. Project code extends under the APACHE 2.0 license. The assembly requires a compiler with the support of the C ++ 17 standard.
Main features:
- connection in blocking and non-blocking modes.
- Prepared statement with positional and named parameters.
- Extended error handling using exceptions and error codes sqlstate .
- support for calling functions and procedures.
- Support dynamic SQL queries.
- Ability to convert extensible data types at the transmission stage between the client and the server (for example, conversion between PostgreSQL arrays and STL containers).
- Support for the conveyor regime of requests (Pipeline), which makes it possible to significantly accelerate the execution of a large number of small record operations (INSERT / UPDATE / DELETE) due to the sending of the next query without waiting for the result of the previous one.
- Support Large Objects for streaming access to large data sets.
- Support operation copy To copy data between the DBD file.
- The ability to separate SQL queries from C ++ code on the client side.
- Providing a simple and reliable pool of compounds suitable for use in multi-threaded applications.
/Media reports.