Thanks very much for your reply. We am new to "R" and actually my main interest is making sure that we can develop a R script that can efficiently read/write to the database. Today we generate text files from the database, run R in batch mode on these files and load the text files back into the database. Even though this process works, given the amount of data we expect to have and the forecasting results we expect to see this could be very time consuming.
Our goal is to eliminate this additional I/O of reading/writing to files and would like to read/write from/to the database in order to save time and have a better process architecture. I did read the manual and couldn't make much out of it. I was looking to see if somebody has already done this so that I could use that to Jump start our project. Regards, - Venkatesh Mantha -----Original Message----- From: Robert Baer [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 21, 2007 10:34 AM To: Venkatesh Mantha; [email protected] Subject: Re: [R] Examples on how to READ/WRITE to database using R-Project > We are working on a project on forecast modeling and would like to know if > there are any examples on how to READ/WRITE to a database (e.g. > PostgreSQL) > using R-Project. I do have a sample R Script which takes input as files > from > a directory and writes back output files to a directory. I would like to > convert this script to read from a database and write back the output to > a > database. > - Venkatesh Mantha You probably want to install the RODBC package. Then, library(RODBC) ?RODBC Also, the the relational database section of the R Data Import/Export Manual is worth reading: http://cran.r-project.org/doc/manuals/R-data.html ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
