DBI icon indicating copy to clipboard operation
DBI copied to clipboard

suggest update to R-data

Open r2evans opened this issue 2 years ago • 1 comments

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.)

r2evans avatar Oct 08 '21 14:10 r2evans

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?

krlmlr avatar Nov 01 '21 06:11 krlmlr