Re: ROOT and SQL Access

Hi,
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/libmysqlclient.so" {

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

extern "libsqlite3.so" {

#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
>
> http://root.cern.ch/root/html/NET_Index.html
>
> Cheers,
> Philippe.
>
> -----Original Message-----
> From: owner-roottalk_at_pcroot.cern.ch [mailto:owner-roottalk_at_pcroot.cern.ch]
> On Behalf Of Ivan K. Koga
> Sent: Tuesday, January 25, 2005 7:54 PM
> Cc: roottalk_at_pcroot.cern.ch
> Subject: [ROOT] ROOT and SQL Access
>
> Dear all,
> Does anybody knows if ROOT has SQL Access?
> I saw something related in
> http://root.cern.ch/root/R2000/Html/newfeatures/index.htm 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