BIG DATABASE
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 <madiazl at 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.Bivand at nhh.no http://orcid.org/0000-0003-2392-6140 https://scholar.google.no/citations?user=AWeghB0AAAAJ&hl=en