The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.

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
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.

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.