timeseriesdb (version 0.2.1)

createConObj: Conveniently Create Connection Object to PostgreSQL based timeseriesdb

Description

Create a conection object while getting user information from the R session. Also standard db parameters like port and driver are set. Yet flexible information like host or dbname should be added to Sys.setenv environments.

Usage

createConObj(dbuser = Sys.info()["user"],
  dbname = Sys.getenv("TIMESERIESDB_NAME"),
  dbhost = Sys.getenv("TIMESERIESDB_HOST"), passwd, dbport = 5432)

Arguments

dbuser

character username. Defaults to reading username from Sys.info()

dbname

character name of the database, assumes dbname is stored in TIMESERIESDB_NAME.

dbhost

character host address, asssumes dbhost ist stored in TIMESERIESDB_HOST.

passwd

character password is used. No defaults, best way to pass a password is to .rs.askForPassword to hide password entries when using R Studio.

dbport

integer port number defaults to 5432 for postgres