Databases using R The latest

on YouTube ↗19m

" summary

Overview of concrete tools and outcomes for doing most data wrangling inside databases: uses DBI/odbc + dbplyr against BigQuery with a 640,000-row Austin 3-1-1 table, shows top-10 query returning 10 rows, reduces 41,000 points to 484 raster cells with dbplot's db_compute_raster, draws tiles in leaflet, stores encrypted env vars in RStudio Connect, catalogs 61 DBI/dbplyr-dependent packages (87% updated since 2017), and runs modeldb k-means in-database (17 iterations) to cluster and map results.

AI-written summary · about

" chapters (7)

1. 0:00Introduction
2. 0:45Databases in R
3. 4:35Environment variables
4. 6:40Database packages
5. 10:00Data demo
6. 14:40Leaflet
7. 16:45ModelDB

" related talks

• 16mdbcooper: Turn any database into an R or Python packageDavid Robinson · rstudio::conf(2022)
• 47mFun with BIG Data with various databasesDavid Ennis · Dutch PHP Conference 2013
• 18mduckplyr: Tight Integration of duckdb with R and the tidyverseKirill Müller · posit::conf(2023)
• 17mUsing R with Databricks ConnectEdgar Ruiz · posit::conf(2023)
• 58mData Wrangling [for Python or R] Like a Boss With DuckDBHannes Mühleisen · posit::conf(2024)
• 41mAnalyzing Terabytes of Data with Google BigQueryChandramouli Mahadevan · The Fifth Elephant 2013
• 34mData Wrangling with DuckDBWill Angel · PyData Virginia 2025
• 20mGive me the DataColin S Gillespie · posit::conf(2024)