Package: nolock 1.1.0

nolock: Append 'WITH (NOLOCK)' to 'SQL' Queries, Get Packages in Active Script

Provides a suite of tools that can assist in enhancing the processing efficiency of 'SQL' and 'R' scripts. - The 'libr_unused()' retrieves a vector of package names that are called within an 'R' script but are never actually used in the script. - The 'libr_used()' retrieves a vector of package names actively utilized within an 'R' script; packages loaded using 'library()' but not actually used in the script will not be included. - The 'libr_called()' retrieves a vector of all package names which are called within an 'R' script. - 'nolock()' appends 'WITH (nolock)' to all tables in 'SQL' queries. This facilitates reading from databases in scenarios where non-blocking reads are preferable, such as in high-transaction environments.

Authors:Arkadiusz W. Pajda [aut, cre, cph]

nolock_1.1.0.tar.gz
nolock_1.1.0.zip(r-4.7-any)nolock_1.1.0.zip(r-4.6-any)nolock_1.1.0.zip(r-4.5-any)
nolock_1.1.0.tgz(r-4.6-any)nolock_1.1.0.tgz(r-4.5-any)
nolock_1.1.0.tar.gz(r-4.7-any)nolock_1.1.0.tar.gz(r-4.6-any)
nolock_1.1.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION
card.svg |card.png
nolock/json (API)

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

On CRAN:

Conda:

This package does not link to any Github/Gitlab/R-forge repository. No issue tracker or development information is available.

1.00 score 1 scripts 263 downloads 4 exports 11 dependencies

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

TargetResultTimeFilesSyslog
linux-develOK126
source / vignettesOK134
linux-releaseOK101
macos-releaseOK168
macos-oldrelOK222
windows-develOK58
windows-releaseOK63
windows-oldrelOK102
wasm-releaseOK85

Exports:libr_calledlibr_unusedlibr_usednolock

Dependencies:clicrayongluelifecyclemagrittrNCmiscrlangrstudioapistringistringrvctrs