Re: [R-sig-Geo] BIG DATABASE

2018-05-25 Thread Javier Moreira
Thanks so much! El vie., 25 may. 2018 9:51, Roger Bivand escribió: > On Fri, 25 May 2018, Javier Moreira wrote: > > > Can I use this answer to ask exactly for what it's mentioned. > > R and Postgis mostly for Easter files. > > Can you point books, online courses, tutorials, GitHub pages, anythin

Re: [R-sig-Geo] BIG DATABASE

2018-05-25 Thread Roger Bivand
On Fri, 25 May 2018, Javier Moreira wrote: Can I use this answer to ask exactly for what it's mentioned. R and Postgis mostly for Easter files. Can you point books, online courses, tutorials, GitHub pages, anything, to better understand this? I had been struggling to find info. For rpostgis, s

Re: [R-sig-Geo] BIG DATABASE

2018-05-25 Thread Javier Moreira
Can I use this answer to ask exactly for what it's mentioned. R and Postgis mostly for Easter files. Can you point books, online courses, tutorials, GitHub pages, anything, to better understand this? I had been struggling to find info. Thanks! El vie., 25 may. 2018 1:35, Tom Philippi escribió:

Re: [R-sig-Geo] BIG DATABASE

2018-05-24 Thread Tom Philippi
What Roger said (as always). Note that if you use tidyverse and magrittr, dplyr and tidyverse tools work well with databases via DBI. sqldf also works with multiple SQL database backends if you're an ol dog like me and don't use tidyverse much. Also, since this is r-sig-*GEO*, note that postgreS

Re: [R-sig-Geo] BIG DATABASE

2018-05-24 Thread 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.

Re: [R-sig-Geo] BIG DATABASE

2018-05-24 Thread Yaya Bamba
Elisa Rose , I just wan to use some variables from a database that is huge, without loading it, for my computer doesn't have much memory capacity. 2018-05-24 11:45 GMT+00:00 Yaya Bamba : > Thanks to all of you. I will try with the package RMySQL and see. > > 2018-05-24 11:33 GMT+00:00 Andres Di

Re: [R-sig-Geo] BIG DATABASE

2018-05-24 Thread Yaya Bamba
Thanks to all of you. I will try with the package RMySQL and see. 2018-05-24 11:33 GMT+00:00 Andres Diaz Loaiza : > 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 d

Re: [R-sig-Geo] BIG DATABASE

2018-05-24 Thread Andres Diaz Loaiza
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 [[

[R-sig-Geo] BIG DATABASE

2018-05-24 Thread Yaya Bamba
Hello, Is it possible with R to work on a big database without loading it? If yes, how can I do do it? Thanks. -- Yaya BAMBA Elève Ingénieur Statisticien Economiste (ISE) Ecole Nationale Supérieure de Statistique et d'Economie Appliquée (ENSEA), Abidjan (Côte d'Ivoire) Tél: +225 87 89 76 89