Chapter 10. The New PostgreSQL C++ API—libpqxx

libpqxx is PostgreSQL's next-generation interface for programs written in C++. From its inception, libpqxx was designed to provide an object-oriented, STL-compatible approach to client-side programming. The author (and contributors) of libpqxx have done a remarkable job of creating a rich and familiar framework for accessing PostgreSQL servers from a program written in STL style. As you explore libpqxx, you'll find well-designed classes that transform libpq objects into STL-compatible containers. You can use standard STL iterators and algorithms to walk through command results and, using transactors<> (described later in this chapter), you can create objects that encapsulate database interaction into simple objects.

If you're a seasoned C++ programmer, you'll find that libpqxx feels very natural. If you're new to C++, libpqxx is a great place to start.