C++ – Good C/C++ connector library for PostgreSQL


My application is a commercial GIS C++ application, and I'm looking for a robust/easy to use connector for Postgresq. (Side note: I also plan to use PostGIS)

Does anyone have any recommendations based on your experience? A plus would be if you have tried out various ones.

I have looked at:

  1. Postgres's C client
  2. pqxx
  3. QSql

Also, does anyone know what's a good admin GUI tool? I see a community list here. But there are so many! I'm developing on Windows, and dont mind paying for commercial tools.
Someone in another Stackoverflow post suggested Maestro.

Best Solution

libpq++ is one provide very good connector for PostgreSQL

SQLAPI++ is a C++ library for accessing multiple SQL databases (Oracle, SQL Server, DB2, Sybase, Informix, InterBase, SQLBase, MySQL, PostgreSQL and ODBC, SQLite).

Abstract Database Connector is a C/C++ library for making connections to several databases (MySQL, mSQL, PostgreSQL, Interbase, Informix, BDE, ODBC). It runs on Linux, UNIX, BeOS, and Windows, and a dynamic driver loader for ELF OSes is under development

Navicat is Nice GUI tool for PostgrSQL