Subject: Re: [boost] sqlpp11: SQL for C++
From: Roland Bock (rbock_at_[hidden])
Date: 2013-11-12 03:26:10
On 2013-11-12 07:13, Christof Donat wrote:
> Am Montag, 11. November 2013, 23:16:06 schrieb Roland Bock:
>> I see use cases for printf and regex for instance, where the user
>> provides a textual representation of something at compile time. In those
>> cases, compile time validation of strings is a wonderful tool, and I
>> have highest respect for it.
>> But in the context of sqlpp11 I don't see how or why I should use it?
> When you have SQL with its original syntax in your source code, you can
> copy/paste between your source code and your database tool. That way you can
> develop your queries iteratively. Compile time string parsing then adds
> compile time syntax checks, type safety and a intuitive interface to access
> the columns in the result set by using your library.
>> The library is constructing the query string at runtime. There is no
>> string to be validated at compile time. This is a major difference to
>> most other C++ SQL libraries.
> The huge strength of it is to me, that it provides all that syntax and type
> checking and the intuitive access to the result sets. Its weakness is, that I
> have to translate my queries from SQL syntax to another similar, but not equal
> syntax when interactively working with my SQL tools. That could be resolved by
> adding compile time string parsing on top of your library.
As I wrote to Vicente, personally I wouldn't follow that path. I don't
believe in ct SQL parsing for all but the simplest cases. But I might be
If you have some spare time on your hands and consider such an approach
useful, you should probably give it a try.
Boost list run by bdawes at acm.org, gregod at cs.rpi.edu, cpdaniel at pacbell.net, john at johnmaddock.co.uk