search for: rdbi

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 for my setup: conn <- odbcConnect("xf", "xfl2",...

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

...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 am experiencing the same behaviour explained here: http://finzi.psych.upenn.edu/R/Rhelp02/archive/2482.html (i copied the message below) has anybody found a solution? here is the code that gives me a segmentation fault library(Rdbi) library(Rdbi.PgSQL) conn <-...

I can use the Rdbi package to connect to a PostGreSQL server fine but when I use the dbDisconnect(), I get a segmentation error and it throws me out of R. I'm using RH7.2, R1.4.1, Rdbi 0.1-2, and Rdbi.PgSQL 0.1-2. Anyone else seen anything like this and have an possible answer? Andrew Schuh -.-.-.-.-.-.-.-...

Hi, I would like to be able to use R with a connection to a PostgreSQL database. I am using R 2.0.1 on windows XP. I have tried installing both the DBI and rDBI packages (which is better?) but in either case I run into the same problem - when i try to use either the dbDriver or dbConnect functions i'm told the function couldn't be found. Seems like the packages aren't installing properly. I installed DBI from a zip file and rDBI from bioconduct...

hi! i am experiencing the same behaviour explained here: http://finzi.psych.upenn.edu/R/Rhelp02/archive/2482.html (i copied the message below) has anybody found a solution? here is the code that gives me a segmentation fault library(Rdbi) library(Rdbi.PgSQL) conn <- dbConnect(PgSQL(), dbname = "PGA") tmp <- "create table test ( expid int, name varchar(128));" result <- dbSendQuery(conn,tmp) dbClearResult(result) the last line can be substituted by dbDisconnect(conn) and you get a segmentation...

To get the Rdbi/RdbiPgSQL 1.0.1 interface from BioConductor functional, I would like to suggest some fixes. Find patches and the updated packages here: http://mpa.itc.it/markus/tmp/rdbi/ Changes Rdbi: - fixed load of RdbiPgSQL (wrong name) - fixed dbConnectionInfo() (typo) RdbiPgSQL: - fixed table...

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

...the moment because it seems to have more core functions (i.e. less writing for me to do) but on the other hand, our sysadmin already has MySQL installed, and I hear that it's faster. Of PostGreSQL vs. MySQL, which has the more mature interface with R? Are there any issues with RMySQL or Rdbi.PGSQL (or .MySQL) that I should be aware of and should they influence my decision for MySQL vs. PGSQL vs. the SAS integrated database? My dataset is about 26G, currently split up into files of 260 MB... about 540,000 records with 40 "explanatory" variables, many of which are probably...

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 connect (I cannot find any troubleshooting guides) RPgSQL - can install, but fails on trying to load RMySQL - installation fails (System = Mac OSX 10.2) Which is considered the m...

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, ...) UseMethod("dbConnect&qu...

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

Hi R-users I recently downloaded RdbiPgSQL 1.8.0 and Rdbi 1.8.0 from Bioconductor to be installed under R 2.4.1. When requiring RdbiPgSQL an error message is showed as follows: > require(RdbiPgSQL) Loading required package: RdbiPgSQL Error in library(package, lib.loc = lib.loc, character.only = TRUE, logical = TRUE, :...

...ame, but is an interface to database tables. I see this kind of interface as a way to avoid overloading core memory with data scarcely used. Unfortunately, the said package is now officially orphaned by its developper, which states that he now focuses on the next database access standard : the Rdbi interface, which is currently under development, and which I don't know a thing about. So the question is : do the Rdbi interface offers such a proxy to data still residing in databases ? Or am I barking up the wrong tree and trying to (re-)invent an oversophisticated virtual memory manage...

...eSQL from source, or install RPMS: if the >latter > > did you install _all_ the RPMs? I suspect you don't have the client >files > > installed. On my system (installed from the sources under RH7.3) > > libpq-fe.h is in /usr/local/pgsql/include. > > > > 3) Rdbi/Rdbi.PgSQL are not on CRAN and appear not to be supported, but >in > > any case you would do best to ask the author(s)/maintainer(s) about > > packages, and especially non-CRAN packages. > > > > 4) There is no such thing as R 1.6.2.1, and reports have it that > > R...

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 up the configure scripts? My preliminary efforts to get things going under Windows 2000 haven''t met with much success. Thanks, John [SNIP] [[al...

Hi, I just installed ROracle and RDBI. The connection to the database seems to work also. My problem is when I am selection rows that really exist in the database, it is returning nothing. Where should I look to see what could be my problem? Thank you very much, Mathieu > drv <- dbDriver("Oracle") > summary(dr...

...bivariate normality for both the true value and measurement error. This model allows dependence between measurement errors hence is more flexible. --- ontoTools: Software for working with ontologies (structured vocabularies) and their associations with general data resources. --- Rdbi, RdbiPgSQL: Generic framework for database access in R. Adapted from Rdbi authored by Timothy H. Keitt, with methods for accessing data stored in PostgreSQL tables (Adapted from Rdbi.PgSQL, authored by Timothy H. Keitt) --- SNPtools: Currently an interface to the SNPper data resou...

...bivariate normality for both the true value and measurement error. This model allows dependence between measurement errors hence is more flexible. --- ontoTools: Software for working with ontologies (structured vocabularies) and their associations with general data resources. --- Rdbi, RdbiPgSQL: Generic framework for database access in R. Adapted from Rdbi authored by Timothy H. Keitt, with methods for accessing data stored in PostgreSQL tables (Adapted from Rdbi.PgSQL, authored by Timothy H. Keitt) --- SNPtools: Currently an interface to the SNPper data resou...

...; trying to get the right tools installed. I have found zero coherent > documentation for any of this stuff. Yes, there's the import/export > guide, and that's helpful and all but it doesn't tell me what I need to > do with these files: > > DBI.RPgSQL_0.1-2.tar.gz > Rdbi_0.1-2.tar.gz > Rdbi.PgSQL_0.1-2.tar.gz > > None of these files contains any documentation either. > > ...now, when I go to > > http://rpgsql.sourceforge.net/ > > There's no documentation there either. In fact, there's only a message > saying that this pro...