DBI
DBI copied to clipboard
suggest update to R-data
The current https://cran.r-project.org/doc/manuals/r-devel/R-data.html chapter 4.3 R interface packages mentions DBI
but the information is well out-of-date:
All except RODBC are tied to one DBMS, but there has been a proposal for a unified ‘front-end’ package DBI (https://developer.r-project.org/db/) in conjunction with a ‘back-end’, the most developed of which is RMySQL.
It's certainly minor, but (1) the first portion is now wrong with the presence of odbc
, and (2) I think the focus on RMySQL
, while it may be historically correct, may not need to be focused as much anymore. (The section on RODBC
is a lot more DBMS-agnostic, for comparison.)
(It may also be nice to throw a bone at parameterized queries in the examples, too, even if just a demo without conversation. It's such an under-utilized feature, if StackOverflow questions are a good indicator, that this is just one more place to make the introduction.)
Thanks, good idea. Should this also point to the databases CRAN task view at https://cran.r-project.org/web/views/Databases.html? Would you like to help?