Easier SQL integration with R
sqlhelper facilitates preparing and executing files of SQL code from R.
In particular, sqlhelper does two things. It:
- provides functions for preparing and executing files of sql queries; and it
- provides functions to manage multiple RDBMS connections.
To do this sqlhelper defines a number of functions, many of which are also
exported for convenience.
There are, of course, many excellent ways to interact with a database from R,
often not involving SQL at all (e.g. dbplyr);
sqlhelper is for the times when you do want to use SQL - perhaps you have
inherited some legacy SQL, or need some specific functionality offered by your
RDBMS, or simply prefer to write SQL. The article vignette("use-case")
describes the setup for a specific motivating case.
The current stable version is available from CRAN:
install.packages("sqlhelper")You can the install development version from github:
# install.packages("devtools")
devtools::install_github("majerr/sqlhelper@dev")Basic functionality is described in vignette("sqlhelper")
Execution of SQL files is described in detail in vignette("execution")
Setup and management of database connections is described in
vignette("connections")
There are some details about using sqlhelper within other packages in vignette("use_case")
