I'm not sure that this is the right forum for this question, but if it is not, I trust that the forum owners will redirect it appropriately.
I'm looking for a pre-existing C++ API for accessing a database, rather than having to write my own. Presently we are using an SQLite database, but I don't want to write the application with SQLite-specific calls, because at some point we might want to change to MySQL or Postgres or perhaps even a commercial product.
Within the FreeBSD ports system, I see databases/dbconnect , but from what I can see from taking a quick look at it, databases/dbconnect is not totally portable. I might be mistaken, it doesn't seem to be well documented.
I stumbled across a commercial product called SQLAPI++, but the source code costs $249 and I don't know if it is worth anything. You can download a binary test version for nothing, which claims to work on FreeBSD 8; I can't get the test program to run on FreeBSD10, it depends on a version of libstdc++.so that does not exist on this system.
That the test version claims to work on FreeBSD 8, but not on FreeBSD10, makes me suspect that the product is not being actively maintained, that the "lifetime support" that they promise for the cost of two licenses might be provided by people who are dead, or serving a life sentence in a California prison for first-degree murder, or otherwise not available when you need them.
Which is not to say that I require lifetime support, I don't, I just want a well-behaved and well-documented portable C++ API for database access. What do you recommend? As always, thank you in advance for any and all replies.
I'm looking for a pre-existing C++ API for accessing a database, rather than having to write my own. Presently we are using an SQLite database, but I don't want to write the application with SQLite-specific calls, because at some point we might want to change to MySQL or Postgres or perhaps even a commercial product.
Within the FreeBSD ports system, I see databases/dbconnect , but from what I can see from taking a quick look at it, databases/dbconnect is not totally portable. I might be mistaken, it doesn't seem to be well documented.
I stumbled across a commercial product called SQLAPI++, but the source code costs $249 and I don't know if it is worth anything. You can download a binary test version for nothing, which claims to work on FreeBSD 8; I can't get the test program to run on FreeBSD10, it depends on a version of libstdc++.so that does not exist on this system.
That the test version claims to work on FreeBSD 8, but not on FreeBSD10, makes me suspect that the product is not being actively maintained, that the "lifetime support" that they promise for the cost of two licenses might be provided by people who are dead, or serving a life sentence in a California prison for first-degree murder, or otherwise not available when you need them.
Which is not to say that I require lifetime support, I don't, I just want a well-behaved and well-documented portable C++ API for database access. What do you recommend? As always, thank you in advance for any and all replies.
Last edited by a moderator: