similar to: Why not available of RMySQL and RPgSQL in RWin binaries?

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

Hello. I try to create stat sever by IIS 4.0 + ASP + VBScript with R for Win on NT Sever 4.0 SP6a. However VBScript denied redirection input of R script. Do Rwin developers have a plan to add a following function by adding an argument of command line? rterm --script 'r script path & file name' -------------- next part -------------- An HTML attachment was scrubbed... URL:

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/~keitt/ -------------- next part

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/~keitt/ -------------- next part

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

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

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

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

Hello. Is NN for R for Win available? It seemes that there's no NN package in contributed ones. -------------- next part -------------- An HTML attachment was scrubbed... URL: https://stat.ethz.ch/pipermail/r-help/attachments/20010310/6a58939c/attachment.html

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

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

Hi All: Package TSERIES is stated to depend on MVA. However, there is no MVA package to be found under the list of package sources. Best wishes, ANDREW tseries: Package for time series analysis Package for time series analysis with emphasis on non-linear and non-stationary modelling Version: 0.7-6 Depends: ts, mva, quadprog Date: 2001-08-27 Author: Compiled by Adrian

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

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