Displaying 20 results from an estimated 3000 matches similar to: "R and PostGresQL"
2007 Feb 05
1
RdbiPgSQL in R 2.4.1
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, :
‘RdbiPgSQL’ is not a valid package – installed <
2011 Jun 28
2
connecting R and PostgreSQL
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
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
2010 Oct 20
1
how to connect to a remote PostgreSQL database from R on mac osx
Hello List,
I would like to connect to a postgreSQL database on a remote server and I am wondering what is the best package to do that. I have just installed RpgSQL, RPostgreSQL, Rdbi and RODBC.
The handiest to me is RPostgreSQL but I don't see how to connect to a remote server with it. For sure I can connect to remote server with RODBC, but since I am on a Mac OSX 10.6, I have quite
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
2006 Mar 02
1
Curious subsetting behavior
I have a simple vector, called tmp that I want to subset based on another
vector called vec. Everything works as expected except for below where the
subsetting returns something other than the original data. Any ideas?
> vec <- c(1,2,3,4,5,59,60,27,32,21)
> tmp
[1] 1.0 1.1 2.0 2.1 2.2 3.0 3.1 4.0 5.0 5.1 6.0 7.0 8.0 8.1
9.0
[16] 9.1 9.2 10.0 10.1 11.0 12.0 13.0 14.0
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, ...)
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
2002 Oct 07
2
PostgreSQL & DBI or ???
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
2008 Oct 03
1
3D scatter, groups, RdbiPgSQL...
hello,
I wish to create some 3d scatter diagrams visualising different grouped
data set by a given field in the database. I tried the scatterplot3d
package, as well as the plot3d and scatter3d functions (both within the
rgl resp. Rcmdr package). My first question is, whether is it possibe to
group data in the scatterplot3d and plot3d, because I did not succeed to
use the groups = ...
2009 Sep 13
2
zoo plot: yearly marks on X-Axis
On Sun, 2009-07-26 at 13:17 +0200, Poersching wrote:
> stvienna wiener schrieb:
> > Hi all,
> >
> > I am plotting a financial time series, but I need a more detailed X-Axis.
> >
> > Example:
> > x <- zoo(rnorm(1:6000), as.Date("1992-11-11")+c(1:6000))
> > plot(x)
> >
> > The X-Axis is labeled "1995", "2000"
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 Mar 12
2
RODBC, IODBC and Mac OS X
Dear All,
As some of you in the archive, i am experiencing problems in using
RODBC with IODBC on Mac OS X Panther.
I am currrently facing two problems.
The first one is apparently linked with IODBC (according to returned R
error message) although testing the database access from IODBC manager
seems to work fine.
The second is by far more radical, R purely and simply reports an error
,
2009 Sep 11
1
format (?) problems with data imported from postgres
Good day,
I read some data from a PostgreSQL database by a following script:
library(Rdbi)
library(RdbiPgSQL)
# conn becomes an object which contains the DB connection:
conn <- dbConnect(PgSQL(), host="localhost", dbname="BVS",
user="postgres", password = "*******")
query_duj_kal <- dbSendQuery(conn, "select zdroj as well, cas as date,
fe2,
2004 Jan 09
1
R and Postgresql (DBI)
Hi,
I'm running Debian (Sid), Postgres (7.3.4) and
R (1.8.1).
I get the following error when I tri to use DBI
>library("DBI")
> p <- dbDriver("PostgreSQL")
Error in do.call(as.character(drvName), list(...)) :
couldn't find function "PostgreSQL"
Is there any other package I need in order to
interface between R and Postgres ?
2005 Jan 13
2
R, postgresql, windows & bsd
I usually work with R on a windows querying data through RODBC from a postgresql
db on a freebsd machine on my offcie lan.
Now I have the chance to use R also on a linux gentoo client box and to
connect to the same db.
I know that I can install the unixodbc stuff and stick to RODBC, BUT my
question is:
Is there any more 'linuxish' way of querying a postgresql server from a
client?
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
2010 Jun 27
2
Ways to work with R and Postgres
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
2010 Mar 06
2
memory error in for loop
hi,
I have been attempting to run this script and am getting some strange
results. The script connects to a database and retrieves a series of
tables, using sequential sql statements. I have tested all of the sql
statements in the PostGreSQL terminal and they all return the desired
results. I place each table into a list and run a FOR loop for 'i' in
the list. The script generates