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?
2
Database Programming library/API?
Started by nuclear123, Jun 02 2012 08:06 PM
7 replies to this topic
Sponsor:
#2 Members - Reputation: 285
Posted 02 June 2012 - 09:27 PM
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 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.
Edited by taby, 02 June 2012 - 09:30 PM.
#4 Members - Reputation: 123
Posted 03 June 2012 - 12:52 AM
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.
#5 Members - Reputation: 2440
Posted 03 June 2012 - 04:35 AM
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.
Edited by Laval B, 03 June 2012 - 04:45 AM.
We think in generalities, but we live in details.
Alfred North Whitehead
#8 Members - Reputation: 285
Posted 03 June 2012 - 12:04 PM
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
Edited by taby, 03 June 2012 - 12:17 PM.
