Re: [boost] SQL library with full embedded SQL-syntax

From: Thorsten Ottosen (thorsten.ottosen_at_[hidden])
Date: 2007-03-16 03:55:54

Jeff Garland wrote:
> Maciej Sobczak wrote:
> 
>>Hi,
>>
>>Jeff Garland wrote:
>>
>>
>>>Well, I'll be brutally honest -- I don't think I would go that 
>>>direction.  We didn't pick a database project last year because a 
>>>majority of the mentors agreed that the 'dsl-based' approach was more of 
>>>a toy than reality.  The main reason for this is that in 'real-world' 
>>>applications queries are often dynamic and must be built at run-time.  
>>
>>The other reason is that in 'real-world' you might want to call stored 
>>procedures instead of manually glued pieces of ad-hoc SQL queries, in 
>>which case the support in the area of query composition is probably not 
>>very useful anyway.
> 
> 
> True, but I wouldn't recommend it since it's inherently non-portable.

Portability is another reason to go away from sql queries as strings.

-Thorsten