Reece Hart wrote:
On Tue, 2006-11-07 at 00:22 -0800, Joe Conway wrote:
I think you want this:
http://bioconductor.org/packages/1.9/bioc/html/RdbiPgSQL.html
The bioconductor project is now maintaining RdbiPgSQL. I think many
people also use RODBC to connect R with Postgres.
I almost sent you
On Tue, 2006-11-07 at 00:22 -0800, Joe Conway wrote:
I think you want this:
http://bioconductor.org/packages/1.9/bioc/html/RdbiPgSQL.html
The bioconductor project is now maintaining RdbiPgSQL. I think many
people also use RODBC to connect R with Postgres.
Joe-
I almost
I use RODBC which is available from http://cran.r-project.org/
I'm not sure if this will do what you want, or whether it has
the features of Rdbi you need, but it gets the job done for me.
I can open a "channel", execute a SQL statement (typically a Select)
and read the results back into a R dataf
Reece Hart wrote:
I'd like to get R to talk to postgresql, but my head's spinning among a
web of broken links, way outdated web pages, project deprecation
announcements and a terrible signal:link ratio.
Rdbi and RdbiPgSQL seem to be the answer, despite both being apparently
defunct projects.
I assume you've seen pl/R?
http://www.joeconway.com/plr/
On Mon, 6 Nov 2006, Reece Hart wrote:
I'd like to get R to talk to postgresql, but my head's spinning among a
web of broken links, way outdated web pages, project deprecation
announcements and a terrible signal:link ratio.
Rdbi and Rdbi
On Monday 06 November 2006 07:38 pm, Reece Hart wrote:
> On Mon, 2006-11-06 at 19:13 -0800, Adrian Klaver wrote:
> > You might want to take a look at PL/R a procedural language for R in
> > Postgres.
> > http://www.joeconway.com/plr/
>
> PL/R is indeed neat, but I want to go the other way: within R
On Mon, 2006-11-06 at 19:13 -0800, Adrian Klaver wrote:
You might want to take a look at PL/R a procedural language for R in Postgres.
http://www.joeconway.com/plr/
PL/R is indeed neat, but I want to go the other way: within R, fetch data from postgres and manipulate it (plot, histo
On Monday 06 November 2006 04:58 pm, Reece Hart wrote:
> I'd like to get R to talk to postgresql, but my head's spinning among a
> web of broken links, way outdated web pages, project deprecation
> announcements and a terrible signal:link ratio.
>
> Rdbi and RdbiPgSQL seem to be the answer, despite
I'd like to get R to talk to postgresql, but my head's spinning among a web of broken links, way outdated web pages, project deprecation announcements and a terrible signal:link ratio.
Rdbi and RdbiPgSQL seem to be the answer, despite both being apparently defunct projects.
What is the Right
