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

We are excited to announce that tidypredict version 0.2.0 is now on CRAN. This version adds support for ranger() models. tidypredict parses a fitted R model object, and returns a formula in ‘Tidy Eval’ code that calculates the predictions.
Read more →
We are very excited to announce that dbplyr 1.2.0 is now available on CRAN! The full announcement was posted in
Read more →
Background and recommendations on choosing between ODBC and JDBC, and between swtching from RODBC to odbc. Link:
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:
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:
Read more →