Connecting to databases requires boilerplate code to specify connection parameters and to set up sessions properly with the DBMS. This package provides a simple tool to fill two purposes: abstracting connection details, including secret credentials, out of your source code and managing configuration for frequently-used database connections in a persistent and flexible way, while minimizing requirements on the runtime environment.
You can install the current version of srcr from CRAN. Development versions are hosted on GitHub, and can be installed with:
require(devtools)
install_githubpackages('baileych/srcr')This is a basic example which shows you how to solve a common problem:
library(srcr)
db <- srcr(basenames = 'my_project_config',
allow_post_connect = c('sql', 'fun'))