sql

Goin' to Carolina in my mind (or on my hard drive)

Out-of-memory processing of North Carolina's voter file with DuckDB and Apache Arrow

Oh, I'm sure it's probably nothing

How we do (or don't) think about null values and why the polyglot push makes it all the more important

Workflows for querying databases via R

Simple, self-contained, reproducible examples are a common part of good software documentation. However, in the spirit of brevity, these examples often do not demonstrate the most sustainable or flexible workflows for integrating software tools into large projects.

Embedding column-name contracts in data pipelines with dbt

dbt supercharges SQL with Jinja templating, macros, and testing -- all of which can be customized to enforce controlled vocabularies and their implied contracts on a data model

Generating SQL with {dbplyr} and sqlfluff

Using the tidyverse's expressive data wrangling vocabulary as a preprocessor for elegant SQL scripts. *(Image source [techdaily.ca](https://techdaily.ca))*