search

datacarpentry / R-ecology-lesson

Data Analysis and Visualization in R for Ecologists
https://datacarpentry.org/R-ecology-lesson/
Other
314 stars 508 forks source link

`src_dbi()` has been superseded/deprecated #818

Closed Aariq closed 4 months ago

Aariq commented 2 years ago

https://github.com/datacarpentry/R-ecology-lesson/blob/ac8b94ee5d1a806a85280093a497cf433e08ba32/05-r-and-databases.Rmd#L110

According to the documentation dbplyr::src_dbi() is superseded and dplyr::src_dbi() is deprecated. Looking at the dbplyr documentation, it looks like the recommended way to do this is with DBI::dbListTables(mammals)

SichongP commented 1 year ago

https://dbi.r-dbi.org/reference/dblisttables

tobyhodges commented 4 months ago

Thanks @Aariq for opening this issue. The lesson underwent a major update and reorganisation when https://github.com/datacarpentry/R-ecology-lesson/pull/887 was merged. One significant change is that the content on interacting with databases has been removed. As this issue relates that content, I will close it. Please open a new issue if you have suggestions for how the updated content could be improved.