R devel - Sep 2007 - R-Server remotecontrolled via browser-GUI

dear r-community,

currently i have a workflow as following:
data in online-MYSQL-database via .csv into R for analysis, results
back to mysql.
generating graphics for reports also.

that's ok, but i need some process-optimization.

i'd like to run r directly on the webserver. analysis should work
automatically, after the appropriate r-script was selected in a
browser-gui for R.

until know after collecting some information, i think the best
approach to reach that goal is:
* using mod_R / RApache to run multiple instances of r on the server,
* build a website that will serve as frontend/gui for r either with
html/php or some ajax-framework,
* connect R to the database with one of the available db-packages to
fetch the survey-data
* put the r-scripts for analysis somewhere on the server
* use cairo for generation of the images
* and see what happens...

i would like to know, if my construction seems good to you, if you
have other recommendations or constructive critics and what you think
about the effort for configuring mod_R/RAPACHE, cairo and the
db-package for r.

thanks a lot in advance for your help!

cheers,

josuah r.

Have you read section 4 of the FAQ?  If not, that would be a good place
to start.

-- 
Gregory (Greg) L. Snow Ph.D.
Statistical Data Center
Intermountain Healthcare
greg.snow at intermountainmail.org
(801) 408-8111
 
 
> -----Original Message-----
> From: r-devel-bounces at r-project.org 
> [mailto:r-devel-bounces at r-project.org] On Behalf Of idontwant 
> googeltospyafterme
> Sent: Friday, September 28, 2007 8:33 AM
> To: r-devel at r-project.org
> Subject: [Rd] R-Server remotecontrolled via browser-GUI
> 
> dear r-community,
> 
> currently i have a workflow as following:
> data in online-MYSQL-database via .csv into R for analysis, 
> results back to mysql.
> generating graphics for reports also.
> 
> that's ok, but i need some process-optimization.
> 
> i'd like to run r directly on the webserver. analysis should 
> work automatically, after the appropriate r-script was 
> selected in a browser-gui for R.
> 
> until know after collecting some information, i think the 
> best approach to reach that goal is:
> * using mod_R / RApache to run multiple instances of r on the server,
> * build a website that will serve as frontend/gui for r 
> either with html/php or some ajax-framework,
> * connect R to the database with one of the available 
> db-packages to fetch the survey-data
> * put the r-scripts for analysis somewhere on the server
> * use cairo for generation of the images
> * and see what happens...
> 
> i would like to know, if my construction seems good to you, 
> if you have other recommendations or constructive critics and 
> what you think about the effort for configuring 
> mod_R/RAPACHE, cairo and the db-package for r.
> 
> thanks a lot in advance for your help!
> 
> cheers,
> 
> josuah r.
> 
> ______________________________________________
> R-devel at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel
>

Hi Josuah

RWebServices might be a different approach. It allows R functions and
methods to be deployed as SOAP-based web services, and relies on an
underlying Java architecture that uses JMS to separate the web services
front end from a collection of R workers (on different machines). This
seems more scalable than putting the R workers on the same machine as
the Apache server.

Entry point here:

http://bioconductor.org/packages/2.0/bioc/html/RWebServices.html

There is quite a learning curve and technology commitment associated
with this, so not the best solution for providing light-weight
web access to R.

Martin

"idontwant googeltospyafterme" <googel.vs.privacy at
googlemail.com> writes:
> dear r-community,
>
> currently i have a workflow as following:
> data in online-MYSQL-database via .csv into R for analysis, results
> back to mysql.
> generating graphics for reports also.
>
> that's ok, but i need some process-optimization.
>
> i'd like to run r directly on the webserver. analysis should work
> automatically, after the appropriate r-script was selected in a
> browser-gui for R.
>
> until know after collecting some information, i think the best
> approach to reach that goal is:
> * using mod_R / RApache to run multiple instances of r on the server,
> * build a website that will serve as frontend/gui for r either with
> html/php or some ajax-framework,
> * connect R to the database with one of the available db-packages to
> fetch the survey-data
> * put the r-scripts for analysis somewhere on the server
> * use cairo for generation of the images
> * and see what happens...
>
> i would like to know, if my construction seems good to you, if you
> have other recommendations or constructive critics and what you think
> about the effort for configuring mod_R/RAPACHE, cairo and the
> db-package for r.
>
> thanks a lot in advance for your help!
>
> cheers,
>
> josuah r.
>
> ______________________________________________
> R-devel at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel
-- 
Martin Morgan
Bioconductor / Computational Biology
http://bioconductor.org

idontwant googeltospyafterme wrote on 09/28/2007 09:33
AM:
> dear r-community,
> 
> currently i have a workflow as following:
> data in online-MYSQL-database via .csv into R for analysis, results
> back to mysql.
> generating graphics for reports also.
> 
> that's ok, but i need some process-optimization.
> 
> i'd like to run r directly on the webserver. analysis should work
> automatically, after the appropriate r-script was selected in a
> browser-gui for R.
> 
> until know after collecting some information, i think the best
> approach to reach that goal is:
> * using mod_R / RApache to run multiple instances of r on the server,
> * build a website that will serve as frontend/gui for r either with
> html/php or some ajax-framework,
> * connect R to the database with one of the available db-packages to
> fetch the survey-data
> * put the r-scripts for analysis somewhere on the server
> * use cairo for generation of the images
> * and see what happens...
> 
> i would like to know, if my construction seems good to you, if you
> have other recommendations or constructive critics and what you think
> about the effort for configuring mod_R/RAPACHE, cairo and the
> db-package for r.
Hi Josuah,

I'm planning on releasing the 1.0 version of rapache sometime after the 
relase of R 2.6.0. Work's been really busy around here, so I haven't had
time to finish up the last of the documentation and packaging.

After that, I hope to have time to provide recommendations on how to use 
rapache in various situations. Expect to see progress here:

http://biostat.mc.vanderbilt.edu/rapache

near the middle of October.

Jeff
-- 
http://biostat.mc.vanderbilt.edu/JeffreyHorner

hi jeff,
i have read your paper from 2005 and your rapache solution sounds
good. i was wondering if u did sth about the state problem... you
should put a changelog on your website. what changes will come with
1.0?
and what is brew exactly for? it is like a tuned "cat", mixing
r-output and text, right?
so if i build a gui, brew could generate the html. but i dont'have to
use brew, do i? what are the advantages of using brew with rapache?

what do you think of openstatserver btw?

i think there are lots of interesting and promising approaches around
in R-community.
but as with all OSS, same here. many people working on slightly
different solutions for the same problem. and none of the solutions is
feature complete, some are not even actively developed and only a few
are to be seen as stable or beyond beta stadium.
well, i work almost only with OSS, so i got used to it :-)
it's just difficult to navigate thru the possibilities without
spending too much time on recherche.

have a nice day,

Josuah

hi jeff,
i have read your paper from 2005 and your rapache solution sounds
good. i was wondering if u did sth about the state problem... you
should put a changelog on your website. what changes will come with
1.0?
and what is brew exactly for? it is like a tuned "cat", mixing
r-output and text, right?
so if i build a gui, brew could generate the html. but i dont'have to
use brew, do i? what are the advantages of using brew with rapache?

what do you think of openstatserver btw?

i think there are lots of interesting and promising approaches around
in R-community.
but as with all OSS, same here. many people working on slightly
different solutions for the same problem. and none of the solutions is
feature complete, some are not even actively developed and only a few
are to be seen as stable or beyond beta stadium.
well, i work almost only with OSS, so i got used to it :-)
it's just difficult to navigate thru the possibilities without
spending too much time on recherche.

have a nice day,

Josuah