CRAN/E | nolock

nolock

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

Installation

About

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.

Key Metrics

Version 1.1.0
Published 2023-11-15 329 days ago
Needs compilation? no
License GPL-3
CRAN checks nolock results

Downloads

Yesterday 3 0%
Last 7 days 26 -41%
Last 30 days 172 +5%
Last 90 days 515 +1%
Last 365 days 2.254 +1582%

Maintainer

Maintainer

Arkadiusz W. Pajda

Authors

Arkadiusz W. Pajda

aut / cre / cph

Material

Reference manual
Package source

macOS

r-release

arm64

r-oldrel

arm64

r-release

x86_64

r-oldrel

x86_64

Windows

r-devel

x86_64

r-release

x86_64

r-oldrel

x86_64

Old Sources

nolock archive

Imports

crayon
rstudioapi
utils
stringr
NCmisc