Easier SQL integration with R
Summary
sqlhelper facilitates preparing and executingfiles of SQL code from R.
In particular,sqlhelper does two things. It:
- providesfunctions for preparing and executing files of sql queries; and it
- providesfunctions to manage multiple RDBMS connections.
To do thissqlhelper 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 youdo 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 articlevignette("use-case") describes the setup for a specific motivating case.
Installation
A stable version ofsqlhelper has not yet been released. The current development version is being prepared for submission to CRAN.
Pending acceptance, the future stable version will be available from CRAN:
install.packages("sqlhelper")Alternatively, you can install development versions from github:
# install.packages("devtools")devtools::install_github("majerr/sqlhelper@dev")Getting Started
Basic functionality is described invignette("sqlhelper")
Execution of SQL files is described in detail invignette("execution")
Setup and management of database connections is described invignette("connections")
There are some details about usingsqlhelper within other packages invignette("use_case")
