Persistence solutions for C++ (with a SQL database)?

Question

I'm wondering what kind of persistence solutions are there for C++ with a SQL database? In addition to doing things with custom SQL (and encapsulating the data access to DAOs or something similar), are there some other (more general) solutions?

Like some general libraries or frameworks (something like Hibernate & co for Java and .NET) or something else? (Something that I haven't even thought of can also be welcome to be suggested)

EDIT: Yep, I was searching more for an ORM solution or something similar to handle sql queries and the relationships between tables and objects than for the db engine itself. Thanks for all the answers anyway!

Answer 1

SQLite is great: it's fast, stable, proven, and easy to use and integrate.

There is also Metakit although the learning curve is a bit steep. But I've used it with success in a professional project.