Re: [boost] SOCI 2.2.0 - The C++ Database Access Library

From: Mateusz Loskot (mateusz_at_[hidden])
Date: 2006-12-07 19:26:15

Peter Dimov wrote:
> Beman Dawes wrote:
>> Nicola Musatti wrote:
> 
> [...]
> 
>>>> In other words, in order to do this:
>>>>
>>>> Session sql(oracle, "some params");
>>>>
>>>> you need to #include "soci.h" (for Session and other independent
>>>> stuff) and "soci-oracle.h" (so that you see oracle as the name of
>>>> the singleton factory).
>>> As I said I think that even this can and should be done away with.
>> I'm also concerned, although I want to understand more before
>> absolutely saying that the approach should be changed.
> 
> I haven't followed the thread in detail, so apologies if this was already 
> covered, but FWIW, when I had to design a db layer, I used
> 
> Connection conn = createConnection( "mysql://user:password_at_host/database" );
> 
> The advantage of this approach is that the URL-like thing can come from a 
> configuration file, so you don't need to recompile to change the backend. In 
> a typical scenario, createConnection would need to look for 
> backend_mysql.dll/.so unless the support for the 'mysql' backend has been 
> statically linked. 

Peter,

Personally, I like it pretty much.
It would also make a try to unify connection strings for all backends.

I will vote on it when we start deeper analysis of all these great
ideas of new features.

Cheers
-- 
Mateusz Loskot
http://mateusz.loskot.net