Re: ROOT and SQL Access

From: Valeriy Onuchin <>
Date: Fri, 11 Feb 2005 21:41:45 +0100

I'd like to mention that we (Masa) are "actively" working on CINT's "extern mechanism". This mechanism allows to "load" C libraries without dictionaries. One of examples is mysqlclient, sqlite, libdb libraries. The following code allows to have native sql interface available from interpreter

extern "/usr/lib/" {

#pragma preprocessor on
#include "mysql/mysql.h"
#pragma preprocessor off


extern "" {

#pragma preprocessor on
#include "sqlite3.h"
#pragma preprocessor off


Regards. Valeriy

 btw, the same trick works for GSL (gnu scientific library) This mechanism is still under developement and is not "stable". I already tested many libs including
libcurl, libiconv, fftw, libgd, libssl, libdb, libldap50, libbfd, libdl, kiss_fft, libesmtp, log4c, etc. (long list)

Philippe Canal wrote:

> Hello,
> We are currently working on improving our support for the SQL interface.
> The support as describe by the link you point to has been available since
> 2000.
> We will be adding a new Oracle plugin to the distribution in the coming
> month.
> We will also been introduce a new interface/class TTreeSQL which will offer
> the same facilities as TTree but using a SQL database as the storage
> backend.
> For information about the code currently available see
> Cheers,
> Philippe.
> -----Original Message-----
> From: []
> On Behalf Of Ivan K. Koga
> Sent: Tuesday, January 25, 2005 7:54 PM
> Cc:
> Subject: [ROOT] ROOT and SQL Access
> Dear all,
> Does anybody knows if ROOT has SQL Access?
> I saw something related in
> and i would
> like to know if it really exists for now and if there are any tutorial
> or help explaining how to use it. I didn't find information about it in
> the user's guide.
> Thank's
> Ivan K. Koga
Received on Fri Feb 11 2005 - 21:41:50 MET

This archive was generated by hypermail 2.2.0 : Tue Jan 02 2007 - 14:45:04 MET