similar to: Install problems with RPgSQL

Hi all, I'm trying to install an add-on package for R called RPgSQL. Its role will be to link R with a PostgreSql database. I work on a Linux machine. However, I'm quite a newbie as far as R's concerned, and I don't manage to install the package properly. That's the steps I followed : * downloading the package (archive) * R CMD INSTALL /path/to/package.tar.gz (as

Hi everybody I am trying to install RPsSQL and get the following error message: When I do ./configure form the untarred source directory I get loading cache ./config.cache checking for crypt in -lcrypt... no No crypt function found When I use the Package installer in R I get install.packages("/Users/christiaanpauw/tmp/RPgSQL/", , NULL, type = "source") Warning in

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

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

Congrats on the new release. The new package management tools are great! A couple of quick comments: 1) it might be nice to add an optional "Autoloads:" field to the description (the package does not depend on these other packages, but will autoload them if certain functions are called). 2) on page 3 of the R-exts document, it says to set PKG_* flags in 'Makeconf'; I think

I know this is something R isn't meant to do well but I tried it anyway :) I have this SPSS-datafile (size 31 MB). When I converted it to a R object with read.spss("datafile.sav") I ended up with a .RData-file which was 229 MB big. Is this considered normal? Then I tried to dump that object into a database with RPgSQL-package function db.write.table(object) (Memory ran out first

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, ...)

Hello, Using the RpgSQL package, there must be a way to get the row names into the table automatically. In the example below, I'm trying to get rid of the cbind line, yet have the row names of the data frame populate a column. > bentest = matrix(1:4,2,2) > dimnames(bentest) = list(c('ra','rb'),c('ca','cb')) > bentest ca cb ra 1 3 rb 2 4 >

Dear R-enthusiasts, What a wonderful package R is, many thanks to all you have contributed (I've just started using it)...I have a few questions that I am having some trouble finding the answer to: I am using RPgSQL to grab some data from a postgresql database (about 179 columns and a few thousand rows), and I want to do a lot of pairwise comparison of the rows...(this is yeast genomic

Is there any way of preserving order of ordered factors when storing a table in PostgreSQL? I have been using PostgreSQL and the RPgSQL package to store a large table with answers such as "Strong disagreement", "Strong agreement", "Mild disagreement". "Mild agreement". When reading the table, such answers are turned into factors, apparently in

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

David Meyer wrote: > > Evan Zane Macosko wrote: > > > > Hello everyone. > > > > I am using the RPgSQL package, and am having some trouble using the > > db.execute command. I successfully connect to my database, and issue a > > simple SQL query, like db.execute("Select * from c0000075"), where > > c0000075 is a table in my database. But

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

Dear R-helpers, I'm an absolute beginner using both R and PostgreSQL, but now I have to work with both programs. I need to connect R and my Postgres-database, but every attempt so far has failed (I tried using the RpgSQL package as well as RdbiPgSQL, the first, following this manual (http://code.google.com/p/rpostgresql/) didn't find any drivers for the database (step no. 1) whereas the

The only database access package I see on CRAN is DBI. But is there a PostgreSQL driver for it yet? (where?) There is no sign of an RPgSQL package on CRAN either. What to do? Thanks, Bruce L. -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or

Hello everyone, I would like to get some advices on using R with some really large datasets. I'm using RH9 Linux R 1.8.1 for a research with a lot of numerical data. The datasets total to around 200Mb (shown by memory.size). During my data manipulation, the system memory usage grew to 1.5Gb, and this caused a lot of swapping activities on my 1Gb PC. This is just a small-scale experiment, the

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

Hello, I'm using package RpgSQL. Is there a better way to create a multi-line query/character string? I'm looking for less to type and readability. This is not very readable for large queries: s <- 'create table r.BOD("id" int primary key,"name" varchar(12))' I write a lot of code, so I'm looking to type less than this, but it is more readable from

Hi all. I'm trying to install the packages Rstreams and RPgSQL, but with no success. I did R INSTALL name package but if I try library(Rstreams) I get the following error: Error in library.dynam("Rstreams",pkg,lib): dynamic library 'Rstreams' not found Error in library(Rstreams): .First.lib failed Where did I go wrong? I'm using R 1-1-1 on a Debian GNU/Linux box.

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