sqlhelper: Easier 'SQL' Integration

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.

Version: 0.2.1
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
Published: 2024-01-21
Author: Matthew Roberts [aut, cre, cph]
Maintainer: Matthew Roberts <matthew at zsmr.uk>
BugReports: https://github.com/majerr/sqlhelper/issues
License: GPL (≥ 3)
URL: https://majerr.github.io/sqlhelper/dev/, https://github.com/majerr/sqlhelper/
NeedsCompilation: no
Materials: README NEWS
CRAN checks: sqlhelper results

Documentation:

Reference manual: sqlhelper.pdf
Vignettes: Managing Connections
Executing SQL
sqlhelper
Using sqlhelper in packages

Downloads:

Package source: sqlhelper_0.2.1.tar.gz
Windows binaries: r-devel: sqlhelper_0.2.1.zip, r-release: sqlhelper_0.2.1.zip, r-oldrel: sqlhelper_0.2.1.zip
macOS binaries: r-release (arm64): sqlhelper_0.2.1.tgz, r-oldrel (arm64): sqlhelper_0.2.1.tgz, r-release (x86_64): sqlhelper_0.2.1.tgz, r-oldrel (x86_64): sqlhelper_0.2.1.tgz

Linking:

Please use the canonical form https://CRAN.R-project.org/package=sqlhelper to link to this page.