similar to: No subject

Hi all, I tried to install the Rdbi_0.1-2.tar.gz and Rdbi.PgSQL_0.1-2 package. The Rdbi_0.1-2.tar.gz installed fine but the Rdbi.PgSQL_0.1-2 had some problems. The compilation routine tried to find a header called libpq-fe.h but did not find it in the standard locations. I searched through the computer but did not find a file called in this way either. What should I do to successuffly

I appologise sincerly, will not happen again. mr. Ripley: Your suggestions were helpful, thanks. I figured I haven not installed the devel RPMS. >From: Prof Brian Ripley <ripley at stats.ox.ac.uk> >To: listproc at baylor.edu >CC: grass-request at baylor.edu, Miha STAUT <mihastaut at hotmail.com> >Subject: Re: list GRASSLIST: List Message Rejected >Date: Thu, 15 May

Is anyone using R with postgres? I'd like to do so, but cannot seem to find any reasonable explanation of how to do so. Joshua Gramlich Chicago, IL

Hi, I am relatively new at R, but I would like to be able to directly access my MySQL and PostgreSQL databases from R. I have been looking around CRAN and searching through Google, however I am not sure what are the best options. I have seen DBI - not sure how this works Rdbi - not sure how this works Rdbi.PgSQL - can install, but fails on trying to load RODBC - cannot

Hello List, I would like to connect to a postgreSQL database on a remote server and I am wondering what is the best package to do that. I have just installed RpgSQL, RPostgreSQL, Rdbi and RODBC. The handiest to me is RPostgreSQL but I don't see how to connect to a remote server with it. For sure I can connect to remote server with RODBC, but since I am on a Mac OSX 10.6, I have quite

Hi, i found tis message in the archive and have got the same problems ? John, perhaps you have found now a way install RPgSQL for windows2000, or anybody other ? many thanks for advance christian [SNIP] I wonder whether anyone has succeeded in building either the RPgSQL or the Rdbi.PGSQL and Rdbi packages for Windows. If so, would you be willing to share either the binary package(s) or

Dear list members, I wonder whether anyone has succeeded in building either the RPgSQL or the Rdbi.PGSQL and Rdbi packages for Windows. If so, would you be willing to share either the binary package(s) or instructions about how to set up the configure scripts? My preliminary efforts to get things going under Windows 2000 haven't met with much success. Thanks, John

Sorry for the simple question: What is the "standard" package for interfacing with PostGreSQL (most up-to-date)? There appear to be at least three with different names: Rdbi.PgSQL RdbiPgSQL (available as part of BioConductor) RPgSQL (On the home page, no longer maintained in favor or Rdbi) The R and database developer page (http://developer.r-project.org/db/) was last updated in

I have been using RODBC for a while with no complaints (R 2.0.1 patched under WinXP), then I saw a link (http://grass.itc.it/statsgrass/r_and_dbms.html) showing that Rdbi claims to run a query in 5 seconds that takes RODBC 4.3 minutes. That was hard enough for me to believe that I wanted to try some tests myself, but I cannot get Rdbi to connect to my ODBC database. Here is what works for RODBC

I've been putting together a package that defined generic methods for database access. The packages is called "Rdbi." It borrows as much as possible from existing database packages / proposals. I'd like to start a discussion about the proposed interface. Here's what I've come up with so far: # # Rdbi: connectionMethods.R # dbConnect <- function(dbObj, ...)

Hi, Please excuse these questions if they're obvious. I'm new to R. I need to access a Postgres db from R. I'm currently trying RODBC as I spend part of my time on Windows and rdbi.pgsql seems not to support windows at this time. I unzipped the RODBC win binary download into my library directory and tried to load it using library(RODBC) I get the following error: Error in

A consensus seems to emerge : R would excel to exploratory work on small/middle-sized datasets, while SAS would be able to munch much larger datasets. However, I see the "size" problem as a red herring. The objects that have to stay "in core" are usually much smaller than the dataset. For example, for problems involving fixed-effects linear models, you need only some

Hi. Currently, PotgreSQL binary for Cygwin is included in Cygwin's distribution. It is very stable working on my PC. But RMySQL and RPgSQL are not included in R contrib binaries. R's DB access will be faster by using these library than by RODBC? Please tell me whether will be available of RMySQL and RPgSQL in RWin binaries? Thanks. -------------- next part -------------- An HTML

I usually work with R on a windows querying data through RODBC from a postgresql db on a freebsd machine on my offcie lan. Now I have the chance to use R also on a linux gentoo client box and to connect to the same db. I know that I can install the unixodbc stuff and stick to RODBC, BUT my question is: Is there any more 'linuxish' way of querying a postgresql server from a client?

Hi, I am wondering if anyone has had experience w/the R database packages: RMySQL, RODBC, RPgSQL, and/or RmSQL, and if so, if you have any recommendations to make. We have some large tables we would like to store -- something like 5-10 columns by 3.5 mil rows (or maybe 7 mil rows). thanks, Natalie Hawkins Statistical Research Associate FHCRC/Scharp

Olivier Collignon wrote: > I have been doing data analysis/modeling in R, connecting to SQL databases > with RODBC (winXP client with R1.9.0 and win2k SQL server 2000). > > I am now trying to leverage some of the OLAP features to keep the data > intensive tasks on the DB server side and only keep the analytical tasks > within R (optimize use of memory). Is there any package

Hello everybody, Whatever I use as the host address of my PostgreSQL database server, I always get a connection if I'm accessing the database from R on the same machine and none if I'm trying to do so from a remote client. PostgreSQL is running on a windows xp machine as the RDBMS, JDBC, R, DBI package, RODBC package, rJava package and RpgSQL package are installed locally and remotely.

I saw in the R-digest a thread about RODBC. 1) I think that this package is *extremely* valuable : it fulfills a need quite important in the case of iterative (e. g. periodic) analyses. No need to periodically return to your data and re-dumping them ... 2) The current version has a serious bug if your datasets has missing numeric values. M. Lapsley, the original author, is aware of it, but has

one more bit of information about this problem. If I start R as the user "postgres" i dont have the segmentation fault. ---------- Forwarded message ---------- Date: Wed, 5 Feb 2003 19:19:39 -0500 (EST) From: Rafael A. Irizarry <ririzarr at jhsph.edu> Reply-To: rafa at jhu.edu To: "R-Help (E-mail)" <r-help at r-project.org> Subject: rdbi segmentation fault hi! i

I use RODBC and RpgSQL quite a lot to access files stored in another machine under PostgreSQL. Since I am now using files which do not fit into R's memory, I would like to take random samples. What I would like is to issue a query such as SELECT * FROM file WHERE runif > 0.9 with "runif" being a uniformly distributed random number, generated on the fly; but I cannot