[R] SQL-Interface

[Torsten Hothorn]

> 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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._