Subject: Re: [boost] Boost.SQL?
From: Roland Bock (rbock_at_[hidden])
Date: 2010-09-14 11:37:00
On 09/14/2010 05:26 PM, Dominique Devienne wrote:
> On Tue, Sep 14, 2010 at 10:17 AM, Roland Bock<rbock_at_[hidden]> wrote:
>>> 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.
> I don't think you'll be able to do that with Oracle. Oracle's wire
> protocol is proprietary, and it can use different kinds of network
> transport. You *have* to use Oracle OCI on the client side, AFAIK.
> (Jonah Harris has kind of reversed engineered that protocol I think,
> but I don't think you want to get into that).
>> 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.
> Good luck with that ;) --DD
Let me rephrase an earlier reply to you: I know that I won't be able to
do it on my own :-)
The different ways in which database vendors are interpreting SQL and
are offering APIs is rather scary...
Boost list run by bdawes at acm.org, gregod at cs.rpi.edu, cpdaniel at pacbell.net, john at johnmaddock.co.uk