Database Programming library/API?

If I recall correctly, OLE DB was replaced by ADODB / ADO.NET. I think the .NET framework has classes available to you.

I always use MySQL Community Edition these days, which has its own C++ library.

Generally, http://www.sqlapi.com/ looks like something you might want to explore. Its last update was from today, so it looks current.

I haven't fully checked, but you might be able to use ODBC.

Check out Valentina DB from Paradigma Software. It is an object-relational columnar db (so it is blazingly fast) that runs on a lot of platforms and supports a lot of different development environments.

Could anyone give any recommendations on a powerfull low-level Database programming library/API i should use? I had originally planned on learning OLE DB....to my knowledge OLE DB is deprecated by MS now. Does anyone unmanaged C++ recommendations?

You could also look at the libraries supplied by your SGBD (assuming you really want low level library). If you are working with Oracle, there is the old C api called OCI and the more recent C++ api called OCCI. PostgresSQL and MySQL also have their C/C++ libraries.

Of course, the code becomes dependent on the SGBD used. With Oracle/OCI a big drawback is that you need the Oracle client installed on the client machine which is rather combersome.

If database portability isn't an issue and your database has a native API, use that - otherwise I'd use ODBC. If you were using MS SQL Server, use ODBC and the SQL Native Client.

HI!

I am not sure, that ADO is a replacement.
It is an other layer of API, it encapsulates OLE DB using components.

Oracle is very good RDBMS, but licencing it would cost a small fortune and requires good DBAs.

HI!

I am not sure, that ADO is a replacement.
It is an other layer of API, it encapsulates OLE DB using components.

Oracle is very good RDBMS, but licencing it would cost a small fortune and requires good DBAs.

You're quite right. Sorry about that.

I was confusing ADODB with ODBC apparently, which are totally different layers like you say: http://en.wikipedia.org/wiki/OLEDB