[FIXED] What is your favorite cross-platform solution to access multiple different databases (MySQL, Oracle...) in C/C++?

Issue

I am writing a simple C++ application which might be installed on Linux or Windows, and which will connect to a database. I want my application to be compatible at least with Oracle and MySQL (or PostgreSQL).

Which C or C++ library would you recommend to handle the database queries: I am open to any library, whether it's very thin (just execute SQL queries) or very fat (a whole object persistence layer, clustering, etc.).

One library per answer, please. A little description (pros & cons) would be great. Thanks a lot.

Solution

I enjoy using SOCI, it's very C++ like. When it comes to performance with respect to Oracle database, it's comparable with native OCI. It provides backend to some RDBMS:

• Oracle
• PostgreSQL
• MySQL

And some more in the CVS repository.

It's fairly simple to use, the documentation is thorough and rationale is pretty clear. It supports connection pooling, has nice extensible way of converting between datatypes.

Answered By - Anonymous

Answer Checked By - Robin (PHPFixing Admin)