On Thu, 24 May 2018, Yaya Bamba wrote:
Thanks to all of you. I will try with the package RMySQL and see.
Maybe look more generally through the packages depending on and importing
from DBI (https://cran.r-project.org/package=DBI) to see what is available
- there are many more than RMySQL.
and use the Official Statistics and HPC Task Views:
https://cran.r-project.org/view=OfficialStatistics
https://cran.r-project.org/view=HighPerformanceComputing
to see how typical workflows (not necessarily DB-based) can be handled.
The HPC TV has a section on large memory and out-of-memory approaches. If
your data are spatial in raster format, the raster package provides some
out-of-memory functionality. In sf, spatial vector data may be read from
databases too.
Roger
2018-05-24 11:33 GMT+00:00 Andres Diaz Loaiza <madi...@gmail.com>:
Hello Yaya,
Many years ago I work with a database in MySQL connected to R through the
package RMySQL​. The data was stored in the MySQL and I was connecting and
using the data from R
you should have a look in:
https://cran.r-project.org/web/packages/RMySQL/index.html
Cheers,
Andres
--
Roger Bivand
Department of Economics, Norwegian School of Economics,
Helleveien 30, N-5045 Bergen, Norway.
voice: +47 55 95 93 55; e-mail: roger.biv...@nhh.no
http://orcid.org/0000-0003-2392-6140
https://scholar.google.no/citations?user=AWeghB0AAAAJ&hl=en
_______________________________________________
R-sig-Geo mailing list
R-sig-Geo@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-geo