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

[Tobias Verbeke]

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

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