similar to: new RMySQL and new maintainer

For those R user's who don't subscribe to R-sig-db and are having troubles with the latest RMySQL binary on CRAN, please read the email thread at the end of this message. RMySQL 0.7-2 does work with MySQL 5.1, however the CRAN binary is linked against the 5.0 version. Best, Jeff -------- Original Message -------- Subject: Re: [R-sig-DB] Problems with RMySQL and MySQL server version

Dear R users, RMySQL 0.7-2 is now available on CRAN: http://cran.r-project.org/web/packages/RMySQL/index.html From the NEWS file: * New maintainer is Jeffrey Horner <jeff.horner at vanderbilt.edu>. * We no longer distribute libmysql.dll. This library is now found either by reading the MYSQL_HOME environment variable or by reading the windows registry entries. * Removed dependence

Dear R users, RMySQL 0.7-2 is now available on CRAN: http://cran.r-project.org/web/packages/RMySQL/index.html From the NEWS file: * New maintainer is Jeffrey Horner <jeff.horner at vanderbilt.edu>. * We no longer distribute libmysql.dll. This library is now found either by reading the MYSQL_HOME environment variable or by reading the windows registry entries. * Removed dependence

Hi, Can somebody advice on weird mysqlWriteTable bug. > mysqlWriteTable(conn, 'comparison',design2, row.names = F, overwrite=T) Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"condition"

I am having trouble loading RMySQL after installing it. I have looked at archived r-help files and it seems many people have had issues, but I didn't find my specific issue. I also went to the webpage at Vanderbilt (http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL) and followed the instructions as best I understood them: - I created a file called Renviron.site under

Dear R users, RMySQL 0.7-3 has been released. Expect it to hit the CRAN mirrors shortly, but in the mean time please get it here: http://biostat.mc.vanderbilt.edu/RMySQL From the NEWS file: Version 0.7-3 * Added mysqlClientLibraryVersions() which returns the compiled and loaded client library versions as a vector. * RMySQL will now check for MySQL minor version consistency and throw

Dear R users, RMySQL 0.7-3 has been released. Expect it to hit the CRAN mirrors shortly, but in the mean time please get it here: http://biostat.mc.vanderbilt.edu/RMySQL From the NEWS file: Version 0.7-3 * Added mysqlClientLibraryVersions() which returns the compiled and loaded client library versions as a vector. * RMySQL will now check for MySQL minor version consistency and throw

I'm currently working on embedding R into the Apache2 webserver (with some positive results...), but I'm struggling to identify the best way to expose the apache data and functions to R. A couple of thoughts: In light of the recent discussion on "S3/S4 classes performance comparson", I'm leaning toward implementing the interface with S3 style classes. I appreciate

What ? ------ We are pleased to announce version 0.0.6 of littler What's new ? ------------ This version includes a bug fix or two as well as a number of small enhancements to the documentation. For OS X and the r/R confusion, our recommended suggestion is to call configure using either the --program-suffix=X or --program-prefix=Y option to have the binary and manual

What is it? ----------- mod_R is a project dedicated to embedding the R interpreter inside the Apache 2.0 (and beyond) web server for the purpose of writing web applications in R. It's composed of three parts: mod_R: the Apache 2.0 module that implements the glue to load the R interpreter. RApache: the R package that provides the API for programming web applications

What is it? ----------- mod_R is a project dedicated to embedding the R interpreter inside the Apache 2.0 (and beyond) web server for the purpose of writing web applications in R. It's composed of three parts: mod_R: the Apache 2.0 module that implements the glue to load the R interpreter. RApache: the R package that provides the API for programming web applications

Hi, Is this sufficient? if (.Machine$sizeof.pointer==4){ cat('32\n') } else { cat('64\n') } Or is it better to test something in R.version, say os? I'd like to use this to specify appropriate linker arguments when building the RMySQL windows package. Jeff -- http://biostat.mc.vanderbilt.edu/JeffreyHorner

I have a 64 bit machine running 64 bit windows 7 pro, 64 bit MySQL, and 64 bit R 2.11.1. I have also installed RTools for 64 bit windows for this version of R (archive name is oldWin64toolchain.zip; the install path for its contents is C:\RTools, if that matters). I can open up a commandline window and invoke any of the programs in both bin directories (both added to the system path). There are

Hi, I've been tracking down a memory leak in an rApache application, http://data.vanderbilt.edu/rapache/bbplot. The code was deployed in 2007 and has survived numerous upgrades of both R and rApache (including upgrades and bugs in RMySQL). It's written in such a way so that web crawlers will download every possible URL the app will create. It's not a high-traffic app, but just about

I am trying to install RMySQL on OpenSolaris and need to pass some options to configure. Tried the 3 recommended ways of doing it and nothing works, configure cannot find the headers and the libs. I ran configure manually and that worked fine ./configure CC=cc CFLAGS="-dalign -KPIC -xlic_lib=sunperf" LDFLAGS="-L/usr/sfw/lib

What ? ====== littler - Provides hash-bang (#!) capability for R (www.r-project.org) Why ? ===== GNU R, a language and environment for statistical computing and graphics, provides a wonderful system for 'programming with data' as well as interactive exploratory analysis, often involving graphs. Sometimes, however, simple scripts are desired. While GNU R can be used

Hi everyone, I am trying to install the RMySQL package under windows xp. I've got the MySQL installed on the computer (MySQL server 5.1). I went through the steps presented on the webpage http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL and googled around and still can't find the answer. With the command readRegistry("SOFTWARE\\MySQL AB", hive="HLM", maxdepth=2) I

Hello, I updated the RMySQL (and DBI) package but, since, it doesn't run anymore. I followed the advices given here http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL but with no success. I also copied the libMySQL.dll in the bin directory of R. Also no good result. The error message (in french sorry) is just below. It seems there is a problem with the registry key but I'm not good

I am facing issues while installing RMySQL package on windows(32 bit) installation of R-Project. I am getting the following warning messages. Warning messages: 1: running command 'C:/PROGRA~1/R/R-213~1.2/bin/i386/R CMD INSTALL -l "C:/Program Files/R/R-2.13.2/library" D:\DOCUME~1\nagga002\LOCALS~1\Temp\RtmpLZndlE/downloaded_packages/RMySQL_0.9-3.tar.gz' had status 1 2: In

Jeff, the tip on http://stat.bell-labs.com/RS-DBI/download/index.html (at the bottom of the page) may help. Trond Rafoss -----Opprinnelig melding----- Fra: Jeff Lee [mailto:JLee at acamllc.com] Sendt: 10. desember 2003 23:34 Til: 'r-help at stat.math.ethz.ch' Emne: [R] How to start RMySQL I am a newbie in R and want to use MySQL database. Here is what I have and done. R 1.8.0 mysql