Package: sqlhelper 0.2.1

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.1.tar.gz
sqlhelper_0.2.1.zip(r-4.5)sqlhelper_0.2.1.zip(r-4.4)sqlhelper_0.2.1.zip(r-4.3)
sqlhelper_0.2.1.tgz(r-4.4-any)sqlhelper_0.2.1.tgz(r-4.3-any)
sqlhelper_0.2.1.tar.gz(r-4.5-noble)sqlhelper_0.2.1.tar.gz(r-4.4-noble)
sqlhelper_0.2.1.tgz(r-4.4-emscripten)sqlhelper_0.2.1.tgz(r-4.3-emscripten)
sqlhelper.pdf |sqlhelper.html
sqlhelper/json (API)
NEWS

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

Peer review:

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

On CRAN:

16 exports 2 stars 1.10 score 37 dependencies 39 scripts 139 downloads

Last updated 8 months agofrom:1b49d2f454. Checks:OK: 7. Indexed: yes.

TargetResultDate
Doc / VignettesOKAug 26 2024
R-4.5-winOKAug 26 2024
R-4.5-linuxOKAug 26 2024
R-4.4-winOKAug 26 2024
R-4.4-macOKAug 26 2024
R-4.3-winOKAug 26 2024
R-4.3-macOKAug 26 2024

Exports:config_examplesconnectconnection_infodefault_conndisconnectget_default_conn_nameis_connectedlive_connectionnot_connectedprepare_sqlread_sqlrun_filesrun_queriesrunfilesrunqueriesset_default_conn_name

Dependencies:classclassIntclicpp11DBIdplyre1071fansigenericsglueKernSmoothlaterlifecyclemagrittrMASSpillarpkgconfigpoolproxypurrrR6rappdirsRcpprlangs2sfstringistringrtibbletidyrtidyselectunitsutf8vctrswithrwkyaml

Executing SQL

Rendered fromexecution.Rmdusingknitr::rmarkdownon Aug 26 2024.

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

Managing Connections

Rendered fromconnections.Rmdusingknitr::rmarkdownon Aug 26 2024.

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

sqlhelper

Rendered fromsqlhelper.Rmdusingknitr::rmarkdownon Aug 26 2024.

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

Using sqlhelper in packages

Rendered fromuse_case.Rmdusingknitr::rmarkdownon Aug 26 2024.

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