search for: joeconway

Hello, I've been using R embedded in PL/R (R procedural language handler for PostgreSQL, http://www.joeconway.com/plr/) very successfully for several months now. A sincere "thank you" goes to the R development team for such a great product. I have a question I'm hoping someone here can help me with. In order to get the required functionality out of PL/R, I've had to resort to using s...

Hello list, I've been trying to get the PostgreSQL PL/R library to compile on windows (http://www.joeconway.com/plr/). The author of this library says the problem is likely because the distributed R.dll isn't compiled as a shared dll. Is this the case? If so, is there any way to compile it such that it is shared? If that's not the case, than maybe someone on this list has a better understandi...

Hi R-helpers Has anyone had any experience doing CGI or Servlets or using an httpd server in R? Context: we are interested in running dynamic demographic calculations on the internet (life tables, and such) in response to form submissions. I might do simple cgi to get started, but loading in data each time seems like it would be quite, quite slow. I have looked at Rserv, but I am most

Dear R-users, I am faced with the problem of analyzing a huge dataset (+ 2 million records, +150 variables) which does not fit into memory. I would like to know if there are pre-packaged tools (in the spirit of Insigthful I-Miner, for instance) aimed at subsampling or splitting the dataset into data-frameable subdatasets, applying functions record-wise, etc. Thank you very much for your

In case anyone is interested, here is a link to an online article written by someone in the Postgres community, covering PL/R: see (cover): http://www.varlena.com/varlena/GeneralBits/66.php and follow to (article): http://www.varlena.com/varlena/GeneralBits/Tidbits/bernier/art_66/graphingWithR.html PL/R is a procedural language handler for PostgreSQL, that allows Postgres functions to be

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

...unning Fedora Cora 1. So far, I have suceeded in setting up PostgreSQL and R as a shared library - unfortunately I have not been able to link these two spheres by adding the PostgreSQL add-on PL/R due to some mysterious probs. I thoroughly followed the setup instructions for PL/R (see http://www.joeconway.com/plr/doc/plr-install.html) and arrived at being able to register PL/R with PostgreSQL properly and even to create PL/R-specific functions. >But< whenever trying to invoke these functions, I end up with a single exception, even for simple ones which are just supposed to return the previous...

We have a setup in which we use PHP (with Geeklog as a CMS) as a front end to MySQL. We plan to use R for offering user driven and automated statistical analysis of some of the data we obtain. We'll be using the R interface to the MySQL database from omegahat (www.omegahat.org) for getting the data out of the database, but we were wondering if somebody tackled the problem of how to integrate

I'm sorry if this is too off-topic--feel free to ignore. I am interested in using pl/R, an amazing "plugin" for the postgresql database. As is typical of these types of applications, pl/R needs to link against a shared library. However, it appears that the MacOS R binary does not build a static (.so) shared library. Is there an accepted, general way (read, a way that works)

I'm sorry if this is too off-topic--feel free to ignore. I am interested in using pl/R, an amazing "plugin" for the postgresql database. As is typical of these types of applications, pl/R needs to link against a shared library. However, it appears that the MacOS R binary does not build a static (.so) shared library. Is there an accepted, general way (read, a way that works)

Friends I am starting on a (section of the) project where I need to build a matrix with on the order of 5 million rows and 200 columns I am wondering if I can stay in R. I need to do rollapply type operations on the columns, including some that will be functions of (windows of) two columns. I have been looking at the ff and bigmemory packages but am not sure that they will do. Before I get

Hi - I am new to RandomForest and want to be able to predict for a set of values outside of R. So for example, if I create the model in R and want to get the prediction for an observation in a database, is there a way I can get the algorithm for the trees and final prediction for this model printed out in R that I can directly implement in SQL? Or is the only way to do this is to use a wrapper

I've been studying some of the code and I'm still a little shakey on the proper method for returning a data.frame from a C function (which is my ultimate goal here). I've started some code that I've "stolen" from the archives and I'm running into crashes, etc. I've been trying to gleen some insight from the src/main/scan.c file and didn't find many comments in

Hello, The procedure for creating an import library (Rdll.lib) that is documented in gnuwin32/README.packages works fine using the i386 architecture, but it doesn't seem to work under x64. Specifically, the procedure is: pexports R.dll > R.exp lib /def:R.exp /out:Rdll.lib /machine:X86 R.dll There are two issues under x64: 1. Older version of pexports crash when applied to an x64 R.dll.

Hello All, I am new to R. I am trying to process this huge data set of matrix containing four columns, say x1, x2, x3, x4 and n number of rows. I want to aggregate the matrix by x1 and perform statistic based on columns x2, x3, x4. I tried aggregate function but it gave me memory allocation error (which I am not surprised), so I ended up performing a for loop based on x1 and

Hello, I've been struggling with a problem for the past several weeks, trying to get PL/R (R procedural language handler for PostgreSQL, http://www.joeconway.com/plr/) to work on Red Hat 9. In brief, R dumps core during the embedded library initialization, while in Rf_regcomp(), working on on Rprofile. Below I've included the important parts of a backtrace: Program received signal SIGSEGV, Segmentation fault. 0x420b655c in re_compile_fastmap_ite...

Hi I am using R as a back-end to some CGI scripts, written in Perl. My platform is Suse Linux 8.2, Apache 1.3.7. So the CGI script takes some form parameters, opens a pipe to an R process, loads up some Bioconductor libraries, executes some R commands and takes the ouput and creates a web page. It is all very neat and works well. I am trying to make my cgi scripts quicker and it turns out

Hi all, Using R a as a real-time application called by Php for a website, I would like to run one R process only, which would manage user connections. For the time each user who asks for an analysis causes a new R process to start, which is not suitable in prevision of many users. R needs about 30 seconds to run the script which makes the analysis. The problem is that this waiting time is n

I was debugging a problem reported to me regarding PL/R, and found that I can duplicate it using only R sources. It might be characterized as possibly a misuse of the findFun() function, but I leave that for the R devel experts to decide. The below results are all with R-2.5.1 (I can't seem to download r-patched at the moment, but didn't see anything in the 2.5.1-patched release

Hola! Este mail llegó a r-help hoy, yo lo mandó también a esta lista. Es interesante con competiciones de predicción/clasificación! ¿Alguien que quiere cooperar? Kjetil ---------- Forwarded message ---------- From: Kjetil Halvorsen <kjetilbrinchmannhalvorsen@gmail.com> Date: Fri, Jan 29, 2010 at 12:19 Subject: Fwd: [R] Classification of supernovae - a challenge To: Kjetil Halvorsen