Asynchronous client library for PostgreSQL, protocol v3.
When developing software we deal a lot with external network resources. Most of them can be accessed through an asynchronous interface, so we don't have to block to wait for a request to finish. The lack of modern C++ asynchronous interface was the reason for writing this library.
pg_async is an unofficial PostreSQL database asynchronous client library written in modern C++ (std=c++11) on top of boost::asio library used for asynchronous network input-output.
- Asynchronous operations
- Connection pooling
- Database aliases
- Standard container-compliant resultset interface
- Execution of prepared statements
- Multiple result sets for simple query mode
- Data row extraction to tuples
- Flexible datatype conversion
- Compile-time statement parameter types binding and checking
- Extensible datatypes input-output system
- TCP or UNIX socket connection
#include<tip/db/pg.hpp>usingnamespacetip::db::pg;// Register conntionsdb_service::add_connection("main=user@localhost:5432[the_database]");db_service::add_connection("logs=user@localhost:5432[logs_db]");// Run the servicedb_service::run();// Will block the thread// Execute queriesdb_service::begin(// Start a transaction"main"_db,// Database alias [](transaction_ptr tran)// Function to be run inside a transaction {query( tran,// Transaction handle"select * from pg_catalog.pg_type"// SQL statement ) ([](transaction_ptr tran, resultset res,bool complete)// Query results handler {for (auto field_desc : res.row_description()) {// Iterate the field descriptions std::cout << field_desc.name <<"\t"; } std::cout <<"\n";for (auto row : res) {// Iterate the resultsetint a, b; row.to(std::tie(a, b));// Extract query result row to a tuplefor (auto field : row) {// Iterate the fields of the row std::cout << field.coalesce("null" ) <<"\t"; } } }, [](db_errorconst& error)// Query error handler { }); }, [](db_error cosnt& error)// Function to be called in case of a transaction error { });For more information please see accompanying doxygen documentation.
git clone git@github.com:zmij/pg_async.gitcd pg_asyncmkdir buildcd buildcmake ..make install