Skip to content

sqlhelper

Easier 'SQL' Integration

v0.2.2 · Mar 26, 2026 · GPL (>= 3)

Description

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.

Downloads

330

Last 30 days

11793rd

655

Last 90 days

2.1K

Last year

Trend: +110.2% (30d vs prior 30d)

CRAN Check Status

14 OK
Show all 14 flavors
Flavor Status
r-devel-linux-x86_64-debian-clang OK
r-devel-linux-x86_64-debian-gcc OK
r-devel-linux-x86_64-fedora-clang OK
r-devel-linux-x86_64-fedora-gcc OK
r-devel-macos-arm64 OK
r-devel-windows-x86_64 OK
r-oldrel-macos-arm64 OK
r-oldrel-macos-x86_64 OK
r-oldrel-windows-x86_64 OK
r-patched-linux-x86_64 OK
r-release-linux-x86_64 OK
r-release-macos-arm64 OK
r-release-macos-x86_64 OK
r-release-windows-x86_64 OK

Check History

OK 14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 27, 2026
ERROR 13 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Mar 16, 2026
ERROR r-devel-linux-x86_64-fedora-clang

tests

Running ‘testthat.R’ [13s/18s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > library(testthat)
  > library(sqlhelper)
  > 
  > test_check("sqlhelper")
  Saving _problems/test-get_driver-27.R
  Note: method with signature 'DBIOb
...[truncated]...
 '{conn_name}'"))
  
  [ FAIL 1 | WARN 0 | SKIP 3 | PASS 149 ]
  Error:
  ! Test failures.
  Execution halted
  <pool> Checked-out object deleted before being returned.
  <pool> Make sure to `poolReturn()` all objects retrieved with `poolCheckout().`
OK 14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026

Dependency Network

Dependencies Reverse dependencies DBI yaml rappdirs stringr glue pool tibble tidyr purrr sf rlang sqlhelper

Version History

updated 0.2.2 ← 0.2.1 diff Mar 26, 2026
new 0.2.1 Mar 10, 2026