[R-sig-Geo] BIG DATABASE

[Roger Bivand]

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