On 09/14/2010 04:36 PM, Torri, Stephen CIV NSWCDD, W15 wrote:
I am interested in a SQL library. Making the sql statements should be pretty straight forward. How do you plan on Making SQL statements is pretty straight forward, if you do something like
string query = string("select * from my_table where id>1000 and first_name='") + name + "'"; But this construction is prone to errors, and the interpretation of the results as well. How can you determine, if the first item in a result_set is in fact the first_name that you expected? Therefore, the building of SQL statements is what I am concentrating on. Also as was pointed out by Dominique (and in earlier discussions on this list), various vendors support various dialects of SQL. This could turn the generation of queries into a major headache ;-)
dealing with communicating with the SQL server? I have used two methods before. First is how a web server does it by sending SQL commands to a IP address / hostname for the database server. Second is using the database server's API and linking against a library. Obviously the first is more portable.
I am not sure about this yet. As of now, the project is not much more than a prototype (although we have started to migrate code already). Currently I am using libpqxx (a C++ wrapper for libpq) which connects via TCP. It might be a good idea to create a second library which provides a unified communication interface for a variety of vendors and and use that as basis for the stuff I am currently working on. Regards, Roland