Re: [R] SQL Database

2018-07-26 Thread MacQueen, Don via R-help
ight drivers that might be appropriate for centos, but if anyone happens to know, hints are appreciated Harold -Original Message- From: MacQueen, Don [mailto:macque...@llnl.gov] Sent: Thursday, July 26, 2018 11:26 AM To: Doran, Harold ; 'r-help@r-project.org'

Re: [R] SQL Database

2018-07-26 Thread Doran, Harold
ppens to know, hints are appreciated Harold -Original Message- From: MacQueen, Don [mailto:macque...@llnl.gov] Sent: Thursday, July 26, 2018 11:26 AM To: Doran, Harold ; 'r-help@r-project.org' Subject: Re: [R] SQL Database From my point of view, the logic is this: If the exte

Re: [R] SQL Database

2018-07-26 Thread MacQueen, Don via R-help
From my point of view, the logic is this: If the external database is Oracle, use ROracle If the external database is MySQL, use RMySQL and similarly for other databases If there is no R package specific to the database, then you drop back to RODBC or RJDBC. Hopefully you can get the

Re: [R] SQL Database

2018-07-26 Thread Martin Maechler
> Doran, Harold > on Wed, 25 Jul 2018 14:57:13 + writes: > I'm doing some work now to learn which SQL database > package is the most optimal for the task I am working on. Hmm... we would have a problem with optimize() and optim() if this was optimal << more

Re: [R] SQL Database

2018-07-25 Thread Bert Gunter
https://rviews.rstudio.com/2017/10/18/database-queries-with-r/ Cheers, Bert Bert Gunter "The trouble with having an open mind is that people keep coming along and sticking things into it." -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip ) On Wed, Jul 25, 2018 at 7:57 AM,

[R] SQL Database

2018-07-25 Thread Doran, Harold
I'm doing some work now to learn which SQL database package is the most optimal for the task I am working on. There are many packages, and I'm reviewing the documentation on some of them now. I am seeking advice from those of you who might suggest a package to use for the task I am currently