The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]dogado.de.

sqlhelper

Easier SQL integration with R

Summary

sqlhelper facilitates preparing and executing files of SQL code from R.

In particular, sqlhelper does two things. It:

  1. provides functions for preparing and executing files of sql queries; and it
  2. 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.

Installation

A stable version of sqlhelper 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 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")

R-CMD-check codecov

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.
Health stats visible at Monitor.