[Rd] R-Server remotecontrolled via browser-GUI

[idontwant googeltospyafterme]

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.