Re: [boost] [SQL-Connectivity] Is Boost interested in CppDB?

Subject: Re: [boost] [SQL-Connectivity] Is Boost interested in CppDB?
From: Artyom (artyomtnk_at_[hidden])
Date: 2010-12-16 00:46:25

----- Original Message ----
> From: Boris Schaeling <boris_at_[hidden]>
> On Wed, 15 Dec 2010 08:06:21 +0100, Artyom <artyomtnk_at_[hidden]> wrote:
> 
> Hi  Artyom,
> 
> > [...]I hadn't used OTL too much and studied it too deep but,  as first shot:
> > 
> > CppDB supports MySQL, Sqlite3 and PostgreSQL  natively and not via ODBC 
only.
> 
> that's true - on Unix it requires setting  up an ODBC infrastructure for these 
>databases.
> This might be a K.O. criterium  for developers. But then altogether the library 
>supports
> so many databases and  is actively maintained for such a long time that I would 
>regard
> it as a strong  competitor to any Boost database library.

I would recommend to stay away from ODBC unless you have to. ODBC drivers are 
usually total
crap (sorry) - during testing CppDB and ODBC I had found so many flaws that I 
understand
that ODBC is generally very bad way to go.

The reason for this is very simple - ODBC API is overcomplicated, so
writing a driver is very complex thing as a result too many drivers have very 
poor
quality.

As I mentioned Sqlite3 driver hadn't managed transactions, MS SQL/FreeTDS ODBC 
Driver for
Linux does not support Unicode. And so on.

So if you can avoid ODBC do it - its concept is great but the reality is not so.

Artyom