search for: 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 /...

...nstall 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 install.packages("/Users/christiaanpauw/tmp/RPgSQL/", , NULL, : argument 'lib' is missing: using '/Users/christiaanpauw/Library/R/2.8/library' * Installing *source* package 'RPgSQL' ... creating cache ./confi...

If you have had problems with the latest configure script in RPgSQL, please try the version attached to this message. Let me know if you have any problems. Thanks. Tim -- Timothy H. Keitt National Center for Ecological Analysis and Synthesis 735 State Street, Suite 300, Santa Barbara, CA 93101 Phone: 805-892-2519, FAX: 805-892-2510 http://www.nceas.ucsb.edu/~k...

If you have had problems with the latest configure script in RPgSQL, please try the version attached to this message. Let me know if you have any problems. Thanks. Tim -- Timothy H. Keitt National Center for Ecological Analysis and Synthesis 735 State Street, Suite 300, Santa Barbara, CA 93101 Phone: 805-892-2519, FAX: 805-892-2510 http://www.nceas.ucsb.edu/~k...

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 attachment was scrubbed... URL: https://stat.e...

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 instructions about how to set...

...n'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 time I tried to convert SPSS-file into a R-object so I was quite prepared for the database manouvre ; I increased the size of swap (working with linux) to 2500 MB) The process kept going and going and getting bigger and bigger. After 6 h...

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

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 when I try to fetch from the >...

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

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

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 microarray data for those who care) I get to the database: > db.connect(dbname="yeast") and grab the first two...

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 second doesn't work with R version 2.13). Could someone please be so kind to either provide a step-by-step instruction o...

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 "[un]subscribe" (in the "body...

...ry usage at all times. Another thought is to use a 64-bit machine (AMD64). I find there is a pre-compiled R for Fedora Linux on AMD64. Anyone knows whether this version of R runs as 64-bit? If so, then will R be able to go beyond the 32-bit 4Gb memory limit? Also, from the manual, I find that the RPgSQL package (for PostgreSQL database) supports a feature "proxy data frame". Does anyone have experience with this? Can "proxy data frame" handle memory efficiently for very large datasets? Say, if I have a 6Gb database table defined as a proxy data frame, will R & RPgSQL be abl...

Hi, I post this message to the general r-help list hoping anyone within a wider range have suggestions: There are three ways to integration R and postgres, especially on 64bit Microsoft windows Platform, 1. via RODBC package, which has 32 bit and 64 bit version for windows 2. via RPostgres interface, which only has 32bit version currently 3. via plr for Greenplum, which only supports a

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 reverse alphabetical order. If I reorde...

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 2001, it appears. The R Import-export manual addresses RPgSQL, but not the other flavors mentioned above. I am sure I have missed some key page sta...

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

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