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
  • We use all three of them!