Combe, Colin
2005-Jan-21 09:58 UTC
[R] 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 properly. I installed DBI from a zip file and rDBI from bioconductor. Any clues as to where i'm going wrong? thanks, colin [[alternative HTML version deleted]]
Dear all, Could someone please make me know if there is a nice script editor available under Mac, similar to Crimson, that offers R syntax highlighting (and pairs of parentheses underlining) ? Thanks in advance, Jacques VESLOT Cirad
You could look at http://www.r-project.org/GUI/projects/Editors.html for a list of text editors offering, at least, syntax highlighting of R code. For Mac (OS X), it seems you have the choice between SubEthaEdit, BlueFish and Jedit,... plus the code editor included in JGR (see: http://stats.math.uni-augsburg.de/JGR/). Best, Philippe Grosjean ..............................................<?}))><........ ) ) ) ) ) ( ( ( ( ( Prof. Philippe Grosjean ) ) ) ) ) ( ( ( ( ( Numerical Ecology of Aquatic Systems ) ) ) ) ) Mons-Hainaut University, Pentagone (3D08) ( ( ( ( ( Academie Universitaire Wallonie-Bruxelles ) ) ) ) ) 8, av du Champ de Mars, 7000 Mons, Belgium ( ( ( ( ( ) ) ) ) ) phone: + 32.65.37.34.97, fax: + 32.65.37.30.54 ( ( ( ( ( email: Philippe.Grosjean at umh.ac.be ) ) ) ) ) ( ( ( ( ( web: http://www.umh.ac.be/~econum ) ) ) ) ) http://www.sciviews.org ( ( ( ( ( .............................................................. Jacques VESLOT wrote:> Dear all, > > Could someone please make me know if there is a nice script editor available > under Mac, similar to Crimson, that offers R syntax highlighting (and pairs > of parentheses underlining) ? > > Thanks in advance, > > Jacques VESLOT > Cirad > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html > >
Consider using ESS and xemacs or emacs. You get syntax highlighting, auto-indent, command auto-complete, transcripts for your session, integrated help, and the tools of one of the most powerful text editors on the planet. The learning curve is a bit steep, but if you use R much, it is worth it. Sean On Jan 21, 2005, at 5:35 AM, Jacques VESLOT wrote:> Dear all, > > Could someone please make me know if there is a nice script editor > available > under Mac, similar to Crimson, that offers R syntax highlighting (and > pairs > of parentheses underlining) ? > > Thanks in advance, > > Jacques VESLOT > Cirad > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! > http://www.R-project.org/posting-guide.html
Sean Davis
2005-Jan-21 11:45 UTC
[R] functions not found after installing DBI/RDBI packages
Colin, Rdbi provides generic methods for working with databases. It requires a driver for a specific database, as well. Therefore, you will need to download and install RdbiPgSQL, also. Sean On Jan 21, 2005, at 4:58 AM, Combe, Colin wrote:> 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 bioconductor. > > Any clues as to where i'm going wrong? > > thanks, > colin > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! > http://www.R-project.org/posting-guide.html
Combe, Colin
2005-Jan-24 11:13 UTC
[R] functions not found after installing DBI/RDBI packages
hi - thanks for the response, I've changed to using the ODBC driver and MySQL as i didn't want to be tied to using linux, and it seems there is no easily installable version of the postgres driver for windows. cheers, colin -----Original Message----- From: Sean Davis [mailto:sdavis2@mail.nih.gov] Sent: Fri 21/01/2005 11:45 To: Combe, Colin Cc: r-help@stat.math.ethz.ch Subject: Re: [R] functions not found after installing DBI/RDBI packages Colin, Rdbi provides generic methods for working with databases. It requires a driver for a specific database, as well. Therefore, you will need to download and install RdbiPgSQL, also. Sean On Jan 21, 2005, at 4:58 AM, Combe, Colin wrote:> 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 bioconductor. > > Any clues as to where i'm going wrong? > > thanks, > colin > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! > http://www.R-project.org/posting-guide.html[[alternative HTML version deleted]]