On Wed, Sep 30, 2009 at 2:52 AM, Paschal Mushubi <[email protected]> wrote: > What do you guys think of this potential Boost library proposal > http://www.yorel.be/boost/libs/rdb/doc/html/index.html ? > > It is an approach quite different from that of SOCI. More like Microsoft > LINQ. >
FWIW, I think it is completely orthogonal to what SOCI does: it is just pretty syntatic sugar for SQL (or any relational model). Unfortunately, IMHO, the promise of static type checking of queries is just a chimera, as you can't really check against the real DB schema at compile time as you can still get (the equivalent of) type failures at runtime. What I think would be really great is type-checking at (prepared) query construction time, both against the db schema and against the local variable types. This way, once a query has been constructed successfully, you are guaranteed that it will not fail because columns do not exist or because the remote types are not convertible to the local types. IIRC, last time I tried it, SOCI wasn't capable of this. Also I do not know if this is really feasible with the current db APIs. 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). Just my 0.02€, -- gpd ------------------------------------------------------------------------------ Come build with us! The BlackBerry® 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-12, 2009. Register now! http://p.sf.net/sfu/devconf _______________________________________________ Soci-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/soci-users
