[R] Friendly way to link R - MySQL and non-(R and Mysql) users ?

[Gabor Grothendieck]

Simplest would be to use the select.list() R command:

xnames <- select.list(colnames(iris))

For a prettier and more functional approach the gWidgets package provides
a layer over a number of lower level packages for creating GUI front
ends in R.
http://wiener.math.csi.cuny.edu/pmg/gWidgets

Other R GUI projects are listed here:
http://www.sciviews.org/_rgui/

On Nov 20, 2007 10:12 AM, Ptit_Bleu <ptit_bleu at yahoo.fr> wrote:
>
> Thanks to your help, I managed to link R and a Mysql Database, send queries,
> plot the results and put everything in a pdf document (with Sweave).
>
> My co-workers find the job not bad but they would like to have a friendly
> interface to send queries and see the graphs (the pdf document is not
> necessary).
> Something like this coul be a good starting point :
>
> ---------------------------------------
> |  Name of the X columns : ___           |
> |  Name of the Y colums   : ___           |
> |  Send query Y/N           : ___           |
> ---------------------------------------
>
> I read some posts about this topic but all need a server (if I read well).
> I'd just want to use it on a local machine.
> Is there a way to realize such an interface and to link it directly to an
> R-script (which will send the query to MySQL and will plot the result of the
> query) ?
>
> Thanks for your help,
> Ptit Bleu.
>
> --
> View this message in context: http://www.nabble.com/Friendly-way-to--link-R---MySQL-and-non-%28R-and-Mysql%29-users---tf4844081.html#a13858847
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>