Package: sqlhelper 0.2.2

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.

Authors:Matthew Roberts [aut, cre, cph]

sqlhelper_0.2.2.tar.gz
sqlhelper_0.2.2.zip(r-4.7)sqlhelper_0.2.2.zip(r-4.6)sqlhelper_0.2.2.zip(r-4.5)
sqlhelper_0.2.2.tgz(r-4.6-any)sqlhelper_0.2.2.tgz(r-4.5-any)
sqlhelper_0.2.2.tar.gz(r-4.7-any)sqlhelper_0.2.2.tar.gz(r-4.6-any)
sqlhelper_0.2.2.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
sqlhelper/json (API)
NEWS

# Install 'sqlhelper' in R:

install.packages('sqlhelper', repos = c('https://majerr.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/majerr/sqlhelper/issues

Pkgdown/docs site:https://majerr.github.io

On CRAN:

5.37 score 3 stars 39 scripts 524 downloads 16 exports 36 dependencies

Last updated from:e79191a22e. Checks:9 OK. Indexed: yes.

Target	Result	Time
linux-devel-x86_64	OK	154
source / vignettes	OK	191
linux-release-x86_64	OK	144
macos-release-arm64	OK	139
macos-oldrel-arm64	OK	176
windows-devel	OK	99
windows-release	OK	224
windows-oldrel	OK	88
wasm-release	OK	135

Exports:config_examples connect connection_info default_conn disconnect get_default_conn_name is_connected live_connection not_connected prepare_sql read_sql run_files run_queries runfiles runqueries set_default_conn_name

Dependencies:class classInt cli cpp11 DBI dplyr e1071 generics glue KernSmooth later lifecycle magrittr MASS pillar pkgconfig pool proxy purrr R6 rappdirs Rcpp rlang s2 sf stringi stringr tibble tidyr tidyselect units utf8 vctrs withr wk yaml

Executing SQL

Rendered fromexecution.Rmdusingknitr::rmarkdownon May 24 2026.

Last update: 2024-01-18
Started: 2024-01-18

Managing Connections

Rendered fromconnections.Rmdusingknitr::rmarkdownon May 24 2026.

Last update: 2024-01-18
Started: 2023-01-12

sqlhelper

Rendered fromsqlhelper.Rmdusingknitr::rmarkdownon May 24 2026.

Last update: 2024-01-18
Started: 2023-01-12

Using sqlhelper in packages

Rendered fromuse_case.Rmdusingknitr::rmarkdownon May 24 2026.

Last update: 2024-01-18
Started: 2024-01-18

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
Examples of yaml configurations for database connections	config_examples
(Re-)Establish connections to databases	connect
Browse available connections	connection_info
Return the default connection	default_conn
Close all connections and remove them from the connections cache	disconnect
Test whether a database is connected	is_connected not_connected
Return the named connection or NULL	live_connection
prepare queries and assemble meta data prior to execution	prepare_sql
Read a sql file and return it's contents as a tibble	read_sql
Read, prepare and execute .SQL files	runfiles run_files
Execute a sequence of SQL queries	runqueries run_queries
Set/get the name of the default connection to use	get_default_conn_name set_default_conn_name