[R] Seeking pointers to help

[Sean Davis]

On 1/14/05 19:34, "Donna-n-Doug Finner" <stonehusky at gmail.com> wrote:

> Noob alert....
> I've been through most of the available documentation at a fairly high
> level - if I've missed the obvious, just point me in the right
> direction.
> 
> What I'd like to build:
> Windows XP system (actually, I'd prever a *nix but must use Win).
> Backend data stored in MySQL db
> Front end user interface built using PHP/HTML running on Apache.
> 
> User builds a select via the web front end.
> User selects a canned analysis or graph for the data set.
> System grabs the data, passes the data to R, magic happens, graphs displayed.
> User isn't exposed to the R-GUI.
> 
> Is this kind of design possible?
> Without going into detail, how would this kind of system be
> structured?  What keywords can I look up that fill in the blanks?  Are
> there any samples of this type of system I can see and/or use?
> Is there another way I should be thinking about this kind of design?
> 
> Additional wrinkle - we may need to substitute Excel as the raw data
> source.  I've been playing with converting XL files to tab sep var
> files and had some level of luck.  I haven't given the ODBC method a
> try yet since that was a 'not' recommended method.
> 
> I'm sure I'll have more to follow.  This tool looks pretty neat.
> Thanks in advance for any tips or pointers.
> 
> Doug
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
> 
It sounds like you are early in the design process?  Have you looked at
PostgreSQL and Pl/R?

You can simply pipe the data to R in batch mode, write the graphs generated
by R to temporary files, and then use those in your generated HTML.  There
are numerous posts about running R in batch mode.  As for using R with PHP,
someone else will have to comment about specifics.

Sean