Hi all, could someone tell me which is the best user-friendly free/open source sql database system to use with R, particularly as a back-end for a data-hungry web page? Thanks in advance. Kind Regards Chibisi [[alternative HTML version deleted]]
sqlite But for a sensible answer, you need to define what you mean by best. Hadley On Tue, Sep 2, 2008 at 8:16 AM, Chibisi Chima-Okereke <chibco at gmail.com> wrote:> Hi all, > > could someone tell me which is the best user-friendly free/open source sql > database system to use with R, particularly as a back-end for a data-hungry > web page? > > Thanks in advance. > > Kind Regards > > Chibisi > > [[alternative HTML version deleted]] > > ______________________________________________ > 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. >-- http://had.co.nz/
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
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