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.

Version: 1.1.0
Imports: crayon, rstudioapi, utils, stringr, NCmisc
Published: 2023-11-15
DOI: 10.32614/CRAN.package.nolock
Author: Arkadiusz W. Pajda [aut, cre, cph]
Maintainer: Arkadiusz W. Pajda <arkadiusz.pajda.97 at onet.pl>
License: GPL-3
NeedsCompilation: no
CRAN checks: nolock results

Documentation:

Reference manual: nolock.pdf

Downloads:

Package source: nolock_1.1.0.tar.gz
Windows binaries: r-devel: nolock_1.1.0.zip, r-release: nolock_1.1.0.zip, r-oldrel: nolock_1.1.0.zip
macOS binaries: r-release (arm64): nolock_1.1.0.tgz, r-oldrel (arm64): nolock_1.1.0.tgz, r-release (x86_64): nolock_1.1.0.tgz, r-oldrel (x86_64): nolock_1.1.0.tgz
Old sources: nolock archive

Linking:

Please use the canonical form https://CRAN.R-project.org/package=nolock to link to this page.