Displaying 20 results from an estimated 4000 matches similar to: "RMySQL vs. Rdbi"
2003 Feb 06
0
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 <- dbConnect(PgSQL(), dbname = "PGA")
tmp <- "create table test ( expid int, name varchar(128));"
2003 Feb 06
1
rdbi segmentation fault (fwd)
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
2002 Dec 10
0
RPgSQL, Rdbi.PGSQL, and Rdbi for Windows?
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
2002 Apr 25
1
Rdbi package and PgSQL
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
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing
2005 Feb 22
1
Rdbi and ODBC
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
2003 Nov 10
0
Rdbi/RdbiPgSQL updates
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 export to PostgreSQL
- added make.names() to polish column names for R usage
2005 Jan 21
5
functions not found after installing DBI/RDBI packages
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
2002 Sep 13
1
R and database access
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
2003 May 11
2
libpq-fe.h ???
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
2003 May 15
0
Re: list GRASSLIST: List Message Rejected
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
2004 Aug 29
1
R and PostGresQL
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 Mar 19
3
generic database access methods
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, ...)
2003 Oct 30
0
Release of Bioconductor 1.3
The Bioconductor core group would like to announce the 1.3 release of
the Bioconductor software. There are many new packages as well as
several major upgrades and fixes in older packages, and users are
encouraged to check them out. Release 1.3 is intended to be operated
with R version 1.8.X, which can be obtained at CRAN
(http://cran.r-project.org/)
-- WHAT FEATURES DOES THIS RELEASE PROVIDE?
2003 Oct 30
0
Release of Bioconductor 1.3
The Bioconductor core group would like to announce the 1.3 release of
the Bioconductor software. There are many new packages as well as
several major upgrades and fixes in older packages, and users are
encouraged to check them out. Release 1.3 is intended to be operated
with R version 1.8.X, which can be obtained at CRAN
(http://cran.r-project.org/)
-- WHAT FEATURES DOES THIS RELEASE PROVIDE?
2003 Feb 11
1
RPgSQL W2K
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
2001 Nov 27
2
R/S and large datasets - Database access (also Re: SAS and S/R)
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
2005 Mar 14
1
using postgresql with R/RODBC
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
2002 Jul 29
2
Database-conversion
Dear R-Users,
I store my data in an Postgres-table.
I can connect with Rdbi.PgSQL, that is no the problem.
The problem is the NA-Values. No-data-values are coded as -9999 in the
table.
But when I extrct them with any SELECT-statement, the -9999-values are
treated as normal vectors.
How can I tell R not to fetch the datasets containig -9999-values?
thanks for your help
stephan
--
Linux: the
2012 Mar 13
1
sunflower plot, making vectors?
I'm having a bit of trouble finding and understanding the correct function to
make numeric vectors to feed the sunflowerplot function. I have 33k points
to show and I want to do better than the standard scatter plot.
I gather that I need two vectors (x and y) of the same count containing the
"center" value of each bin.
FYI - I have two pieces of data:
1 - x axis - time in days of
1999 Sep 08
1
No subject
Hallo,
I'm looking for a "sunflower" plot. I noticed the
Splus function "p.sunflowers" (Andreas Ruckstuhl, Werner Stahel, Martin
Maechler, Tim Hesterberg) don't work... If its not available I would port
this function...
Thanks for 1 answer
P
***************************************************************************
P.Malewski Tel.: 0531 500965
Maschplatz 8