Databases using R

At RStudio, we are working to make it as easy as possible to work with databases in R. This work focuses on three key areas:

1. RStudio products

  • The new RStudio Connections Pane makes it possible to easily connect to a variety of data sources, and explore the objects and data inside the connection
  • To RStudio commercial customers, we offer RStudio Professional ODBC Drivers, these are data connectors that help you connect to some of the most popular databases.

2. Use best-in-class packages

Build and/or document how to use packages such as: dplyr, DBI, odbc, keyring and pool

3. Promote best practices

This website is the main channel to provide support in this area. RStudio is also working through other delivery channels, like upcoming webinars and in-person training at rstudio::conf 2018

Read more →



Latest Announcements

Background and recommendations on choosing between ODBC and JDBC, and between swtching from RODBC to odbc. Link: https://db.rstudio.com/best-practices/select-interface/
Read more →
RStudio makes it easy to access and analyze your data with R. RStudio Professional Drivers are ODBC data connectors that help you connect to some of the most popular databases. Link: https://github.com/rstudio/webinars/tree/master/51-introducing-drivers
Read more →

dbplot is now on CRAN

Leverages dplyr to process the calculations of a plot inside a database. This package provides helper functions that abstract the work at three levels: outputs a ggplot, outputs the calculations, outputs the formula needed to calculate bins.
Read more →
Materials from the Databases using R presentation at ODSC West. Link: https://github.com/edgararuiz/odsc-2017
Read more →