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>
License: GPL-3
NeedsCompilation: no
CRAN checks: nolock results


Reference manual: nolock.pdf


Package source: nolock_1.1.0.tar.gz
Windows binaries: r-devel:, r-release:, r-oldrel:
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


Please use the canonical form to link to this page.