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

From: Jeffrey Horner <>
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.



______________________________________________ mailing list
PLEASE do read the posting guide
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 Please read the posting guide before posting to the list.

list of date sections of archive