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 sqlhelper 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.