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-Server remotecontrolled via browser-GUI
5 messages · idontwant googeltospyafterme, Greg Snow, Martin Morgan +2 more
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
In response to Martin's suggestion, if you DID want a fairly simple way to provide light-weight web access to R, Rpad would be a good choice. I actually run SQL Server 2005, Apache, and R/Rpad on the same server, but the usage is very light in terms of number of users. It was pretty quick to set up and making a new Rpad page is really easy. HTH, Roger -----Original Message----- From: r-devel-bounces at r-project.org [mailto:r-devel-bounces at r-project.org] On Behalf Of Martin Morgan Sent: Friday, September 28, 2007 11:28 AM To: idontwant googeltospyafterme Cc: r-devel at r-project.org Subject: Re: [Rd] R-Server remotecontrolled via browser-GUI 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 ______________________________________________ R-devel at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-devel ********************************************************************** * This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No right to confidential or privileged treatment of this message is waived or lost by any error in transmission. If you have received this message in error, please immediately notify the sender by e-mail, delete the message and all copies from your system and destroy any hard copies. You must not, directly or indirectly, use, disclose, distribute, print or copy any part of this message if you are not the intended recipient.
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