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

On 2013-11-12 09:39, Dominique Devienne wrote:

On Mon, Nov 11, 2013 at 9:31 PM, Roland Bock wrote:

...

...

...

There is a library (Metaparse) which supports creating a string-based interface for libraries which is processed at compile-time. It could be used to provide a string-based interface. Metaparse requires const char[N] arguments, right? That would be a rather atypical case for using a query interface, I'd say. Personally I have never used queries without variable parameters except in examples

On 11/11/13 13:35, Abel Sinkovics wrote: like the one above.

Do you mean that you "inline" the variable parameters values in the query text as opposed to using "placeholders" which you later "bind" with actual values? I meant that real life queries are not as simple as the case discussed above. If that's the case, that's a big no-no on some RDBMS's like Oracle for performance reason (you need to reparse and replan, i.e, "recompile" the query and find again the optimal query execution plan), w/o even getting into SQL injections, etc... A SQL DB API w/o support for prepared queries which you can reuse with different bind values would be ineffective IMHO. Similarly, if you cannot bind array of values to limit round-trips to the DB (if supported; SQLite has no array interface for example), you can never achieve maximum possible performance.

My $0.02 :). --DD

Thanks for the input. Prepared queries are in fact not supported. I'll read up on them and report back. Regards, Roland