CRAN/E | sqlhelper

sqlhelper

Easier 'SQL' Integration

Installation

About

Execute files of 'SQL' and manage database connections. 'SQL' statements and queries may be interpolated with string literals. Execution of individual statements and queries may be controlled with keywords. Multiple connections may be defined with 'YAML' and accessed by name.

majerr.github.io/sqlhelper/dev/
github.com/majerr/sqlhelper/
Bug report File report

Key Metrics

Version 0.2.1
R ≥ 4.1.0
Published 2024-01-21 103 days ago
Needs compilation? no
License GPL (≥ 3)
CRAN checks sqlhelper results

Downloads

Yesterday 7 0%
Last 7 days 36 -16%
Last 30 days 121 -2%
Last 90 days 340 +19%
Last 365 days 619

Maintainer

Maintainer

Matthew Roberts

matthew@zsmr.uk

Authors

Matthew Roberts

aut / cre / cph

Material

README
NEWS
Reference manual
Package source

Vignettes

Managing Connections
Executing SQL
sqlhelper
Using sqlhelper in packages

macOS

r-release

arm64

r-oldrel

arm64

r-release

x86_64

Windows

r-develnot available

x86_64

r-releasenot available

x86_64

r-oldrelnot available

x86_64

Depends

R ≥ 4.1.0

Imports

DBI
yaml
rappdirs
stringr
glue
pool
methods
tibble
tidyr
purrr ≥ 1.0.0
sf
rlang

Suggests

dplyr
rmarkdown
knitr
testthat ≥ 3.0.0
odbc
RSQLite
RPostgres
RMariaDB
bigrquery
spData