Open source libraries for abstracting database access in C++?

Question

I'm looking for options for abstracting database server details away from my application (in c++), I'd like to write my code to be independent of the actual database backend. I know MySQL has a nice library, but I don't want to be tied to a single database implementation. Are there good options for this?

Answer 1

many apps use odbc (via unixODBC for instance), there's also otl. on windows you could use ado.net from managed c++ or the old ado com interfaces...

Answer 2

SOCI is good. Supports multiple databases, works well, modern C++ style API, works with boost.

Answer 3

Qt provides a database abstraction layer. See: http://doc.trolltech.com/4.6/qsqldatabase.html.

Answer 4

libodbc++ provides a pretty good API. Also the big guys Qt (see Kyle Lutz' answer) & wxWidgets have db abstraction layers, so it may be a good idea to use them if you plan to use/you're already using any other parts of those frameworks.