Re: [R] advice requested re: building "good" system (R, SQL db) for handling large datasets

From: Jeffrey Horner <jeff.horner_at_vanderbilt.edu>
Date: Wed, 06 Feb 2008 10:09:29 -0600

Richard Pearson wrote on 02/06/2008 06:25 AM:
> Hi Thomas

[...]
> With databases, one issue that might be relevant is whether you want to
> store data in tables (e.g. one table to store one data.frame) that can
> subsequently be manipulated in the DB, or to store R objects as R
> objects (e.g. as BLOBs). My situation is likely to be the later case,
> and one of my concerns is that many DBs have an upper limit of 2GB on
> BLOBs, and I might potentially have objects that are larger than this.
[...]

I'd be curious as to why you'd want to store and retrieve R objects from a BLOB column in a table. I've often thought about this, but unfortunately neither the DBI package nor the RODBC package support this.

Jeff

-- 
http://biostat.mc.vanderbilt.edu/JeffreyHorner

______________________________________________
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.
Received on Wed 06 Feb 2008 - 16:13:07 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 06 Feb 2008 - 16:30:12 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive