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
DOI: 10.32614/CRAN.package.sqlhelper
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


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


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


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