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.