3.7 R Database Packages
DBI
(“Database Interface”): A package to interact with databases (“Database Interface (DBI)”)RSQLite
: Used to create a SQLite database- a DBI-compatible interface which means you primarily use functions defined in the DBI package, so you should always start by loading DBI
bigrquery
: An Interface to Google’s ‘BigQuery’ ‘API’- Also works together with
DBI
- Also works together with
- We use all three of them!