Repository files navigation

taoPQ is a lightweight C++ client library for accessing aPostgreSQL➚ database.It has no dependencies beyondlibpq➚, the C application programmer's interface to PostgreSQL.

The library provides support for database connections, transactions, nested transactions, prepared statements, large objects, connection pools, pipeline mode, high-speed bulk data transfer, and more.An extensible traits mechanism is used to convert C++ types into SQL statement parameters, and conversely to convert query results into arbitrary C++ types.The following example shows the basic look and feel of the library.

#include<iostream>#include<tao/pq.hpp>intmain(){// open a connection to the databaseconstauto conn =tao::pq::connection::create("dbname=template1" );// execute statements   conn->execute("DROP TABLE IF EXISTS users" );   conn->execute("CREATE TABLE users ( name TEXT PRIMARY KEY, age INTEGER NOT NULL )" );// prepare statements   conn->prepare("insert_user","INSERT INTO users ( name, age ) VALUES ( $1, $2 )" );   {// begin transactionconstauto tr = conn->transaction();// execute previously prepared statements      tr->execute("insert_user","Daniel",42 );      tr->execute("insert_user","Tom",41 );      tr->execute("insert_user","Jerry",29 );// commit transaction      tr->commit();   }// query dataconstauto users = conn->execute("SELECT name, age FROM users WHERE age >= $1",40 );// iterate and convert resultsfor(constauto& row : users ) {      std::cout << row["name" ].as< std::string >() <<" is"                << row["age" ].as<unsigned >() <<" years old.\n";   }}

• Table of Content
• Requirements
• Installation
• Getting Started
• Connection
• Transaction
• Statement
• Result

For questions and suggestions regarding taoPQ, success or failure stories, and any other kind of feedback, please feel free to open adiscussion, anissue or apull request on GitHub or contact the authors attaocpp(at)icemx.net.

taoPQ is part ofThe Art of C++.

Copyright (c) 2016-2025 Daniel Frey and Dr. Colin Hirsch

taoPQ is certifiedOpen Source➚ software.It islicensed➚ under the terms of theBoost Software License, Version 1.0➚ reproduced here.

Boost Software License - Version 1.0 - August 17th, 2003

Permission is hereby granted, free of charge, to any person or organization obtaining a copy of the software and accompanying documentation covered by this license (the "Software") to use, reproduce, display, distribute, execute, and transmit the Software, and to prepare derivative works of the Software, and to permit third-parties to whom the Software is furnished to do so, all subject to the following:

The copyright notices in the Software and this entire statement, including the above license grant, this restriction and the following disclaimer, must be included in all copies of the Software, in whole or in part, and all derivative works of the Software, unless such copies or derivative works are solely in the form of machine-executable object code generated by a source language processor.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NON-INFRINGEMENT. IN NO EVENT SHALL THE COPYRIGHT HOLDERS OR ANYONE DISTRIBUTING THE SOFTWARE BE LIABLE FOR ANY DAMAGES OR OTHER LIABILITY, WHETHER IN CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.