Which DBMS to use?

Tue, Nov 19, 2002 12:18 PM #

I'm currently trying to do analysis on a 565k record database of
Philadelphia's property assessments. I read the Data Import/Export .pdf and
am still conflicted about which DBMS I should use to maintain reliability
and ensure I don't crash while trying to do my calculations.

Should I go with PostgreSQL for the option of Proxy Data Frames or should I
go with MySQL for the "lean and mean" approach? Note that'd I'd be using it
on a Windows 98 OS.

Any input would be much appreciated and thank you in advance.

-Brian Cole
  Staff Researcher
  Center for the Study of Economics


-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://stat.ethz.ch/pipermail/r-help/attachments/20021119/7d899f83/attachment.html

Brian Ripley

Tue, Nov 19, 2002 1:38 PM #

I think we only currently have the options of RMySQL and RODBC under
Windows.

On Tue, 19 Nov 2002, Brian Cole wrote:

Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272860 (secr)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._