[R] Free SQL Database with R
drflxms at googlemail.com
Wed Sep 3 16:36:03 CEST 2008
you might be looking for something like "Rpad"
(http://www.rpad.org/Rpad/). There are some other systems like
SNetscape, Rserve, RSOAP, R.NET.Web as well. Unfortunately I have no
personal experience with these systems so far, so I can't give you any
real advice. I just know them to exist and surfed some testpages.
To me Rpad looks as probably the most feasible system for the task you
describe (and from a cost vs. benefit point of view) . As far as I
understand/remember users need no unusual prerequisites to use Rpad.
For a general overview of GUIs see i.e. http://www.sciviews.org/_rgui/.
According to your latest description of the database associated with the
webpage, SQlite probably will suffice and might be easier to handle than
a whole MySQL server - as Hadley Wickham already proposed in his e-mail.
But this all of course depends on your resources as well (i.e. do you
have access to your own root-server, or just some megabytes of ordinary
Kind regards and greetings from Munich,
Chibisi Chima-Okereke schrieb:
> Dear Felix,
> Thanks for the reply,
> If you haven't already guessed I am new to web programming.
> The sort of webpage I want to build is one that presents quantitative
> information in graphs and charts, that people can interact with, e.g.
> select parts of charts to zoom into, highlight values, click buttons
> to do analysis on the data displayed, so yes some sort of interactive
> GUI. I initially thought of using flash as a front end but I don't
> know any actionscript, so learning that would to a suitable standard
> take alot of extra time, and I think it would be best if everything
> could be done in R as much as possible.
> If I used an RGUI I guess I would be using the playwith package? Do
> the consumers of the website need to have R to consume stuff displayed
> with an RGUI?
> The database itself would just be pretty static just being queried for
> information, unless some analysis was required in which case R would
> query the database do the analysis and write the analysis back to the
> database (I guessing that is the way it would be done), before it gets
> displayed on the web page.
> Kind Regards
> On Wed, Sep 3, 2008 at 11:39 AM, drflxms <drflxms at googlemail.com
> <mailto:drflxms at googlemail.com>> wrote:
> Hello Chibisi,
> I am not shore whether I completely understand your needs: Do you want
> to build a webpage which relies on a content management system
> (cms)? Do
> you want to collect data (i.e. survey) which later on shall be
> using R? Or shall it be a webpage with an interactive R GUI? What
> But personally I would prefer MySQL as backend for websites, as most
> professional (opensource) cms (i.e. typo3, wordpress etc.) are created
> with MySQL in mind.
> There is a good interface between R and MySQL called RMySQL as well. I
> use this on a daily basis, as all my data is stored in a local MySQL
> database (more flexible than always reading in text files - at
> least in
> my opinion).
> Hope this personal view might help a little bit.
> R-help at r-project.org <mailto:R-help at r-project.org> mailing list
> PLEASE do read the posting guide
> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help