Need help with taopq?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

taocpp
175 Stars 31 Forks Boost Software License 1.0 768 Commits 1 Opened issues

Description

C++ client library for PostgreSQL

Services available

!
?

Need anything else?

Contributors list

Welcome to taoPQ

Windows CI macOS CI Linux CI
clang-analyze clang-tidy Sanitizer Code Coverage

taoPQ is a lightweight C++ client library for accessing a PostgreSQL➚ database. It has no dependencies beyond

libpq
, the C application programmer's interface to PostgreSQL.

Introduction

The library provides support for database connections, transactions, nested transactions, prepared statements, large objects, connection pools, 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 
#include 

int main() { // open a connection to the database const auto 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 transaction const auto 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 data const auto users = conn->execute( "SELECT name, age FROM users WHERE age >= $1", 40 );

// iterate and convert results for( const auto& row : users ) { std::cout << row[ "name" ].as< std::string >() << " is " << row[ "age" ].as< unsigned >() << " years old.\n"; } }

Documentation

Contact

Join us on Discord

For questions and suggestions regarding taoPQ, success or failure stories, and any other kind of feedback, please feel free to join our Discord➚ server, open a discussion, an issue or a pull request on GitHub or contact the authors at

taocpp(at)icemx.net
.

The Art of C++

taoPQ is part of The Art of C++.

colinh d-frey uilianries

License

Open Source Initiative

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

taoPQ is certified Open Source➚ software. It is licensed➚ under the terms of the Boost 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.

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.