[R] How do people use Sweave / R / Databases

[Duncan Murdoch]

On 29/01/2010 2:55 PM, Tobias Verbeke wrote:
> Duncan Murdoch wrote:
> > On 29/01/2010 2:28 PM, Paul wrote:
> >> I'm currently using r scripts in sweave to grab some data via ODBC, 
> >> process it then generate some tables.  I'd like to be able to give 
> >> someone the files and let them reproduce what I've done.  Is there 
> >> some way to store the data that is gathered by ODBC so that the second 
> >> person can recreate the work without the database (apart from just 
> >> writing it to a file or into the document)
> > 
> > 
> > What I've done in a case like that is to store the data in a .Rdata file 
> > using save(), then have the Sweave code call load() to load it at the 
> > beginning of the script.
> > There's also the cacheSweave package (and I think another one whose name 
> > I can't remember) 
>
> The weaver package on Bioconductor?
> http://bioconductor.org/packages/release/bioc/html/weaver.html
>   

Yes, that's it.  Thanks!

Duncan Murdoch
> Best,
> Tobias
>
> > to cache the value of some code blocks; you might be 
> > able to bundle up the document with the cache to send to someone who 
> > doesn't want to re-run the retrieval code.
> > 
> > Duncan Murdoch
> > 
> > ______________________________________________
> > R-help at r-project.org 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.
> > 
> > 
>