----- Original Message ----
From: Boris Schaeling <boris@highscore.de> On Wed, 15 Dec 2010 08:06:21 +0100, Artyom <artyomtnk@yahoo.com> 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