Hello,

Giovanni Piero Deretta wrote:

>> What do you guys think of this potential Boost library proposal
>> http://www.yorel.be/boost/libs/rdb/doc/html/index.html ?

> FWIW, I think it is completely orthogonal to what SOCI does:

Yes. I can even imagine this to be used together with SOCI.
For example, instead of:

sql << "select a from b where c = $1", into(x), use(y);

one could do:

sql << WHATEVER_TEMPLATE_SQL_BUILDER_TRICKS_HERE, into(x), use(y);

In other words, the only distinctive thing that they do is the query 
composition.

> Unfortunately, IMHO, the promise of static type checking of queries is
> just a chimera

Fully agreed. That is why it was never attempted in SOCI.

> Finally I do not think that copying SQL  is really the best way to
> implement syntactic sugar for a relational interface (IMO it is ugly
> and verbose).

Fully agreed.

Note also that SQL itself is only a fraction of one can do with the 
database. I find myself using complete anonymous PL/SQL blocks with 
private variables, exception handling and related stuff. SOCI fills my 
needs, because it is SQL-agnostic and it does not limit the query 
language in any way - whatever language the target server supports, it 
can be used (therefore I find it to be a big advantage).
The rdb library focuses on composing relational SQL queries and it will 
never allow to anything more involving. It seems to be a very complex 
tool for very simple projects and as such I think (my humble opinion, of 
course) that it solves the wrong problem.

Regards,

-- 
Maciej Sobczak * www.msobczak.com * www.inspirel.com

------------------------------------------------------------------------------
Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
http://p.sf.net/sfu/devconf
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users

Reply via email to