Repository files navigation

Easier SQL integration with R

sqlhelper facilitates preparing and executingfiles of SQL code from R.

In particular,sqlhelper does two things. It:

1. providesfunctions for preparing and executing files ofsql queries; and it
2. providesfunctions to manage multiple RDBMS connections.

To do thissqlhelper defines a number of functions, many of which are alsoexported 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 haveinherited some legacy SQL, or need some specific functionality offered by yourRDBMS, or simply prefer to write SQL. The articlevignette("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 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")