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

Jeffrey Horner jeff.horner at vanderbilt.edu
Wed Feb 6 17:09:29 CET 2008


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



More information about the R-help mailing list