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

On 2013-11-11 21:22, Rodrigo Madera wrote:

On Mon, Nov 11, 2013 at 10:53 AM, Roland Bock 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