Chapter 1 Prerequisites

For anyone interested in using this book you will need the following packages and tools to follow along.

  • RPostgresql
  • DBI
  • Your own PostgreSQL database
  • Remote access to your database

The RPostgreSQL and DBI package can be installed from CRAN or Github:

install.packages("RPostgreSQL")
install.packages("DBI")
devtools::install_git('https://github.com/r-dbi/DBI.git')
devtools::install_git('https://github.com/cran/RPostgreSQL.git)

Notes on using SQL syntax in RPostgreSQL

To successfully query data in PostgreSQL the following caveats may be necessary. This is especially the case if someone has created column names that are unique and odd in some form or fashion.

  • use backslahes  to escape the quotes “” that are necessary when querying data.
  • use quotes “” around camel back title cases e.g. “Medu” or “Fedu”