Displaying 20 results from an estimated 1200 matches similar to: "R/S and large datasets - Database access (also Re: SAS and S/R)"
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 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, ...)
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
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
2009 Nov 16
1
How to use SQL code in R
Dear All,
How to use SQL code in R?
Thanks!
[[alternative HTML version deleted]]
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
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
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
2004 Apr 13
4
Need advice on using R with large datasets
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
2006 Feb 26
2
how to change my data to "point data set" in package "SPLANCE"?
Hi!
I want to use the package "SPLANCE" to do Ripley's K analysis
I have a basic question about the package.
I try to find how to do it, but I cannot.
I hope you can help me.
I donot know how to change my data form to "point data set".
my data form is:
> qumo[1:5,]
code species dbh x y tag status branch
223 10312 QUMO 54.5 7.83 44.80 10306 alive
2000 Nov 15
1
RODBC
I saw in the R-digest a thread about RODBC.
1) I think that this package is *extremely* valuable : it fulfills a need
quite important in the case of iterative (e. g. periodic) analyses. No need to
periodically return to your data and re-dumping them ...
2) The current version has a serious bug if your datasets has missing numeric
values. M. Lapsley, the original author, is aware of it, but has
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
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 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
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
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
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
2009 Oct 20
1
RPgSQL installation problem
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
2003 Feb 11
4
postgres
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
2003 Apr 16
1
unable to load package 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 /path/to/package.tar.gz (as