R help - Nov 2007 - Friendly way to link R - MySQL and non-(R and Mysql) users ?

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.

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.
>

It's me again (the last message for today - promised).

The following script can be very helpful to me (from
http://bioinf.wehi.edu.au/~wettenhall/RTclTkExamples/editboxes.html) but I'
like to enter several parameters and have a single 'ok' box to validate
all
the entered paramaters.

Anyone can help me to start ?
Thank you,
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#a13911645
Sent from the R help mailing list archive at Nabble.com.