Re: [boost] sqlpp11: SQL for C++

Subject: Re: [boost] sqlpp11: SQL for C++
From: Roland Bock (rbock_at_[hidden])
Date: 2013-11-11 15:52:11

On 2013-11-11 21:22, Rodrigo Madera wrote:
> On Mon, Nov 11, 2013 at 10:53 AM, Roland Bock <rbock_at_[hidden]> wrote:
>
>> On 2013-11-11 11:27, Rodrigo Madera wrote:
>>> Does it support binary transfers over the wire?
>> The library creates template expression trees for the queries. As of
>> now, the tree is serialized and sent to the database connector when you
>> call
>>
>> db.run(query)
>>
>> Result rows are currently to be returned from the connector's result
>> object as const char**, see database_api/api.h.
>>
>> Both, the serialization of the query and the representation of results
>> rows as const char** are part of one possible interface, which happens
>> to work quite well with some databases. Since we have all information in
>> the expression tree, it should be possible to send queries and receive
>> results in different ways.
>>
>> Can you send me links to respective database APIs? Preferably ones that
>> I can experiment with on Ubuntu?
>>
> Roland,
>
> Sorry I didn't see your reply. I even sent a second message without seeing
> this.

No problem :-)
>
> Answering your question on database APIs for bin transfer, I don't know of
> any. I always use top layers, like SOCI. I use it heavily.

OK, got that, but which databases are you using?
>
> If you wish to see details about binary transfer I suppose the SOCI authors
> could give you pointers on those, and maybe the archives for this ML when
> that discussion was going on. Not sure, though.
>
OK, I'll look into. I faintly remember that discussion. It might take
some time though. There is so much feedback to be processed :-)

Regards,

Roland