Connecting to a database

• {DBI} = generic SQL interface
• Specific package for your DBMS ({RPostgres}, {RMariaDB}, {duckdb}, etc)
• {odbc} if no specific package available

con <- DBI::dbConnect(duckdb::duckdb())

• When using duckdb in a project

con <- DBI::dbConnect(duckdb::duckdb(), dbdir = "duckdb")