An updated version of the Enterprise-ready Dashboards is now available. Here are the highlights: Includes dashboard design principles Introduces the r2d3 package for the visualizations Provides two new D3 visualizations that can be copied and easily integrated with other Shiny apps Better handling of the base query using dplyr and shiny::reactive() Adds an example for handling values for Shiny inputs using the set_names() function. Provides a new, and single, GitHub repo to download all of the cde and material from one location.
Read more →
The new version of bigrquery is now available on CRAN. Here are some highlights: The low-level API provides thin wrappers over the underlying REST API. In this version, all the low-level functions start with bq_, and mostly have the form bq_noun_verb(). This level of abstraction is most appropriate if you’re familiar with the REST API and you want do something not supported in the higher-level APIs. The DBI interface wraps the low-level API and makes working with BigQuery like working with any other database system.
Read more →
Background and recommendations to work with non-default schemas inside databases: Link to article
Read more →
The video and materials are now available for the latest “R and Databases” webinar, presented by RStudio: https://www.rstudio.com/resources/videos/best-practices-for-working-with-databases-webinar/
Read more →
RStudio is organizing a webinar titled: Best Practices for Working with Databases. It will be next Wednesday, March 28th, at 11AM EDT. Register here
Read more →
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 tidyverse.org.
Read more →
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 →