Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Good C/C++ connector library for PostgreSQL [closed]

Tags:

c++

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

EDIT 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.

like image 243
sivabudh Avatar asked Jul 16 '09 15:07

sivabudh

People also ask

Which library will be used to connect PostgreSQL?

libpq is the C application programmer's interface to PostgreSQL. libpq is a set of library functions that allow client programs to pass queries to the PostgreSQL backend server and to receive the results of these queries.

How do I close open PostgreSQL connections?

In PostgreSQL there are two functions we need to take into consideration when talking about cancellation or termination: pg_cancel_backend(pid) : Terminate a query but keep the connection alive. pg_terminate_backend(pid) : Terminate a query and kill the connection.

Does C# work with PostgreSQL?

Npgsql is an open source ADO.NET Data Provider for PostgreSQL, it allows programs written in C#, Visual Basic, F# to access the PostgreSQL database server. It is implemented in 100% C# code, is free and is open source.

2 Answers

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

like image 61
joe Avatar answered Oct 14 '22 05:10

joe

Take a look at SOCI. Is an open source lib under Boost Software License (one of the most non-restrictive licenses at all).

This lib is designed especially for C++ with the idea of generic programming and type safety in mind.

SOCI Site

like image 21
ovanes Avatar answered Oct 14 '22 03:10

ovanes
Sign in to Comment

Related questions

C++ template specialization, calling methods on types that could be pointers or references unambiguously
What is the reason for `std::make_tuple`?
Why does aggregate initialization not work anymore since C++20 if a constructor is explicitly defaulted or deleted?
Can we have a function with multiple return types? (in C++11 and above)
How to programmatically gain root privileges?
How do I use the MinGW gdb debugger to debug a C++ program in Windows?
Weird undefined symbols of static constants inside a struct/class
How to convert a TCHAR array to std::string?
What Is a Curly-Brace Enclosed List If Not an intializer_list?
Game engines: What are scene graphs?
Why constructor is called only once?
What is the difference between static global and non-static global identifier in C++?
Difference between decltype and typeof?
Why can I use operator= but not operator== with C++11 brace-initializers?
Interesting behavior of compiler with namespaces
Why is this function call ambiguous?
What is the purpose of std::scoped_allocator_adaptor?
There seems to be a contradiction in §12.3.2/1 in the C++11 Standard
Column size and row size of a 2D vector in C++
CMake one build directory for multiple projects

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!