Easier SQL integration with R
sqlhelper facilitates preparing and executing files of SQL code from R.
In particular, sqlhelper does two things. It:
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")
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4