From simon.urbanek at r-project.org  Mon Feb 18 14:57:45 2013
From: simon.urbanek at r-project.org (Simon Urbanek)
Date: Mon, 18 Feb 2013 08:57:45 -0500
Subject: [Rd] Passing R code from webpage
In-Reply-To: <1361186683328-4658909.post@n4.nabble.com>
References: <1361058494221-4658800.post@n4.nabble.com>
	<CAANJ-wek4j+ab=1_0quUGgrnBrf+kRMocFpTodRNCqAFrJEXHQ@mail.gmail.com>
	<BLU166-W35CDC0CE9CC52759F67450BEF40@phx.gbl>
	<1361186683328-4658909.post@n4.nabble.com>
Message-ID: <676B15E0-CD6B-4E9C-8A29-D2A8EA1699A3@r-project.org>

On Feb 18, 2013, at 6:24 AM, Matevz Pavlic wrote:

> Hi, 
> 
> i think all of this i kinda complicated, even though in all the packages
> authors  are saying that "minimum code is required". 
> I mean, i am not an IT engineer , but i have created quite some webpages, so
> i have some knowledge of HTML5, CSS, C# (limited), and also work quite a lot
> with R and still installing R to run as a webserver seems to be too
> complicated. 

Not at all - R has a built-in webserver (it's used for the help pages), so if you install R, you're done with that part. Rook gives you a wrapper for that.

The problem is it doesn't scale, so if you're happy with one-user solution then you can use R without anything. If you need something that scales, then you need something else -- and for Windows you're a bit out of luck, because the lack of fork+COW on Windows (BTW cygwin doesn't help there, either) paired with the fact that R is not thread-safe means it's quite hard to get scalability on Windows involving R. The best bet on Windows are server solutions that keep a pool of individual R instances as workers but I'm not aware of any off the top of my head (I recall some Java solutions way back when Java was hip and I have it on my ToDo list for Rserve but it's not there yet).


> I have look in all packages i can imaggine, Rook, ggoleVis, Shiny....but in
> all i get the problem when i want to connect to a MS SQL database.
> 

That shouldn't really matter - as long as you can connect from any R session, you will be able to connect through R from the webserver.


> This is the workflow that i'd like to achieve : 
> 1.) in webrowser connect to MS SQL database

I assume you mean from the R script? Otherwise you'll have to shove the data across (not impossible but why not connect from R?).


> 2.) do some R statistics and plots
> 3.) show that in web browser.
> 
> 
> I am pretty sure it can be very complicated, but it just seems so.
> 
> any help (still) greatly appreciated.
> 
> BTW: I HAVE posted in R-help, but no responses were given.
> m
> 
> regards, m
> 
> 
> 
> --
> View this message in context: http://r.789695.n4.nabble.com/Passing-R-code-from-webpage-tp4658800p4658909.html
> Sent from the R devel mailing list archive at Nabble.com.
> 
> ______________________________________________
> R-devel at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel
> 
> 



[Rd] Passing R code from webpage
Simon Urbanek