Re: [R] creating a database

From: <elw_at_stderr.org>
Date: Tue, 18 Dec 2007 19:33:57 -0600 (CST)

> Can a simple matrix be used for this or would it be better and more
> efficient to create an external database to hold the data. If so,
> should the database be created using C and how would I do this (seeing
> as that I have never programmed in C)?

You don't want to be down at the C level, most likely: it would be much more straightforward and programmer-efficient to use one of the available bindings to one of the available open-source databases.

R has useful / usable bindings to postgresql, sqlite, and mysql, among many others.

These are, however, more generally useful when you reach the point that you simply can't manage the volume of your data in R objects or in data frames. [And, well, you can go a LONG way with intelligently named R objects. :-)]

--elijah



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 19 Dec 2007 - 01:36:04 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 19 Dec 2007 - 03:30:19 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.