Message-ID: <Pine.GSO.4.05.9910051143470.2712-100000@atlas>
Date: 1999-10-05T09:49:28Z
From: Torsten Hothorn
Subject: SQL-Interface
In-Reply-To: <XFMail.991004202732.mlapsley@ndirect.co.uk>
> As it happens I am just in the late stages of writing an ODBC R
> library. The code is inspired by Torston Hothorn's RmSql driver (hope
> you don't mind): most of the C code is now mine, but I used his
> driver as a template and his R code works with only minor changes.
I'm very interested in your work, maybe you could send me the "late stage
version" :-)
In my opinion, the problem is not writing a database-driver in R but the
way to transform data sets in R-"data.frames". We should use the R/S
style data.frames for storing data in R. I'm very interested in a
discussion about that.
> odbcConnect(dsn,user,pwd,host=localhost)->channel # 16 open channels poss
>
> sqlsave(channel,dataset) # save dataset in table 'dataset' creating it if
> necessary
>
> sqlload(channel,dataset) # the reverse
>
> sqlquery(channel,query) -> dataframe or matrix ?
Well, thats the question!
Torsten
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._