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'))
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.