cppcms-users

[Cppcms-users] Does CppDB use native database driver or ODBC-like layerss?

[CN <cn...@gr...>]

Hi!

CppDB's connection pool feature attracts me.

"Support as many RDBMSs as possible via cppdb-odbc bridge" is quoted from

http://cppcms.sourceforge.net/sql/cppdb/intro.html

I heard that ODBC is slow. For windowz, configuring ODBC is also hugely  
painful.

Does CppDB directly uses DBMS native drivers or indirectly?
Take PostgreSQL as an example, does CppDB directly call libpq functions or  
indirectly call them through some ODBC layers? If CppDB depends on ODBC,  
does CppDB suffer from performance issue?

Regards,
CN

Re: [Cppcms-users] Does CppDB use native database driver or ODBC-like layerss?

[Artyom <art...@ya...>]

> From: CN <cn...@gr...>
> 
> Hi!
> 
> CppDB's connection pool feature attracts me.
> 
> "Support as many  RDBMSs as possible via cppdb-odbc bridge" is quoted  from
> 
> http://cppcms.sourceforge.net/sql/cppdb/intro.html
> 
> I heard  that ODBC is slow. For windowz, configuring ODBC is also hugely  
> painful.
> 
> Does CppDB directly uses DBMS native drivers or  indirectly?
> Take PostgreSQL as an example, does CppDB directly call libpq  functions or  
> indirectly call them through some ODBC layers? If CppDB  depends on ODBC,  
> does CppDB suffer from performance  issue?
> 

Yes CppDB provides, native drivers: 

See: http://cppcms.sourceforge.net/sql/cppdb/backendref.html

ODBC should be used only for RDBMSs that do not have native drivers.

CppDB supports following native drivers: MySQL, Sqlite3, PostgreSQL

Artyom