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...