duckplyr

DuckDB is a popular and powerful “in-process SQL OLAP database management system”

It provides APIs in multiple languages, including R, Python, and Julia.

The duckdb R package uses the R Database Interface (DBI). Learn more about using DBI here.

The duckplyr package provides a dplyr interface to DuckDB, making it easy to use DuckDB as a backend for data manipulation with dplyr syntax.