[R] RMySQL crashes R
Niels Steen Krogh
nielssteenkrogh at hotmail.com
Thu May 15 13:34:12 CEST 2003
I havn't tried your mysql-approach, but have with no problems used
a very different approach to connect R and mysql (and other
databases)
I use the folowing setup (everything opensource with no licensing
costs):
- Linux Redhat 8.0
- Zope 2.6.1 (www.zope.org)
- RSessionDA, RSOAP and rpy (find via www.google.com)
- R1.6.2 with SESSION package (SESSION package is included in the RSESSIONDA
download)
- Mysql 3.23.52 (included in Redhat 8.0 distr.)
In this setup R and Mysql are webservices connected via Zopes
python-based technology.
This approach makes it very easy to distribute the use of R and
mysql since the userinterface is the web. And the approach also
makes it very easy to svitch from mysql to postgresql or Oracle as
the backend database.
I you want to try this solution before you start building please
send me a mail, and I shall open my router for a short while.
I also have a few screenshots showing integration to Excel from R
(via zope) here. The text is in danish, but the pictures should be
selfexplanatory:
http://www.zug.dk/Members/Nielssteenkrogh/1049270051696377330/view
Regards
Niels
Cand. Polit.
Niels Steen Krogh
Solsortvej 44
2000 F.
Tlf: 3888 8613
ZiteLab / EmpoweR youR data
_________________________________________________________________
Få Hotmail på mobilen http://www.msn.dk/mobile
More information about the R-help
mailing list