Free SQL Database with R

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

Chibisi

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
    analysed
    using R? Or shall it be a webpage with an interactive R GUI? What
    else?

    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.

    Cheers,
    Felix