[R] SQL implementations (was: Are you experienced in SAS and R ...)

Duncan Temple Lang duncan at research.bell-labs.com
Sat Nov 24 00:18:51 CET 2001

Douglas Bates wrote:
> PostgreSQL is extensible.  You can define your own functions using SQL
> or PL/PGSQL or Perl or Python.  You can also define new data types.

And indeed, the REmbeddedPostgres package allows one to use R
functions directly in Postgres.  While we have also done this in MySQL
it is not in any way supported by MySQL and requires some
modifications to the system. For Postgres, this is a straightforward
extension that follows the Postgres documentation!  Similarly, we may
well be able to use data types in R as elements in Postgres tables in
the future.

Personally, I think that as this sort of embedding within
sophisticated and well-tuned database management systems becomes more
secure and stable, we will be able to handle significantly larger
datasets with R code.

The reason that I bring this to the attention of the r-help now is
that if one thinks this facility is promising, one doesn't want to
commit to MySQL now and then convert subsequently.



Duncan Temple Lang                duncan at research.bell-labs.com
Bell Labs, Lucent Technologies    office: (908)582-3217
700 Mountain Avenue, Room 2C-259  fax:    (908)582-3340
Murray Hill, NJ  07974-2070       
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch

More information about the R-help mailing list