Re: [R] R and Data Storage

From: Greg Snow <greg.snow_at_ihc.com>
Date: Tue 04 Oct 2005 - 03:58:26 EST


You might want to look at sqlite (http://www.sqlite.org/). There is already
an R package for accessing these databases and the website shows some GUI interfaces that may be easy enough for tha casual user. Best of all it is small, quick, free, and open source.

Greg Snow, Ph.D.
Statistical Data Center, LDS Hospital
Intermountain Health Care
greg.snow@ihc.com
(801) 408-8111

>>> <rab45+@pitt.edu> 09/30/05 10:26PM >>>
Where I work a lot of people end up using Excel spreadsheets for storing
data. This has limitations and maybe some less than obvious problems. I'd
like to recommend a uniform way for storing and archiving data collected
in the department. Most of the data could be stored in simple csv type files but it would be nice to have something that stores more information
about the variables and units. netcdf seems like overkill (and not easy
for casual users). Same for postgres and mysql databases. Could someone
recommend some system for storing relatively small data sets (50-100 variables, <1000 records) that would be reliable, safe, and easy for people to view and edit their data that works nicely with R and is open
source? Am I asking for the moon?

Rick B.



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide!
http://www.R-project.org/posting-guide.html

R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Tue Oct 04 05:23:28 2005

This archive was generated by hypermail 2.1.8 : Sun 23 Oct 2005 - 18:15:42 EST