README.md

In bfatemi/sqlsauce: The Secret Sauce for Dishing Data

sqlsauce

Source File Prefix

The prefixes (and potentially an additional subsequent identifier) for the filenames describe their purpose and reason for grouping:

1. Query Functions (e.g. query-*.R)

All functions that have a prefix "query" are functions either (1) import a function from the RODBC package; or (2) are designed to be an intuitive interface between R and SQL

1. Query Help Functions (e.g. query-help_*.R)

All functions with the prefix "query" plus the indentifier "help" are functions that rely on external RODBC functions that retrieve data exploration resources (i.e. data dictionaries, etc.).

1. Connection Functions (e.g. conn-*.R)

All functions that have prefix "conn" are low-level functions that call functions from the package RODBC to open/close/get/set/access connection objects as well as interact with the connection pool.

1. Utility Functions (e.g. utils-*.R)

Functions within files that begin with "utils" are mostly internal utilities. Some of these functions will be extracted and bundled in their own package

bfatemi/sqlsauce documentation built on May 12, 2019, 7:27 p.m.