hothorn at statistik.uni-dortmund.de
Tue Oct 5 11:49:28 CEST 1999
> 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
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
> sqlload(channel,dataset) # the reverse
> sqlquery(channel,query) -> dataframe or matrix ?
Well, thats the question!
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
More information about the R-help