R Observatory: Metrics for nolock version 1.1.0

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

nolock

1.1.0

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

0packages depend

2Kdownloads / year

–test coverage

0/13checks pass

Overview

About

Maintained by Arkadiusz W. PajdaFirst published 2023-09-272 releasesCRAN page ↗

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.

Install

R (CRAN)Ubuntu (r2u)Fedora (COPR)openSUSE (OBS)

install.packages("nolock", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-nolock

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-nolock

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-nolock

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed).

Health

CRAN checks

13NOTE

Failing flavors

NOTE r-devel-linux-x86_64-debian-clang
NOTE r-devel-linux-x86_64-debian-gcc
NOTE r-devel-linux-x86_64-fedora-clang
NOTE r-devel-linux-x86_64-fedora-gcc
NOTE r-devel-windows-x86_64
NOTE r-oldrel-macos-arm64
NOTE r-oldrel-macos-x86_64
NOTE r-oldrel-windows-x86_64
NOTE r-patched-linux-x86_64
NOTE r-release-linux-x86_64
NOTE r-release-macos-arm64
NOTE r-release-macos-x86_64
NOTE r-release-windows-x86_64

Slowest check: 1.0 min · r-oldrel-macos-x86_64

Code health

None

Tests · ratio 0.00

not tracked

Coverage

5

Dependencies · direct

Check history

NOTE2026-03-10
3 OK · 11 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

READMENoVignettesNopkgdown siteNoNEWSNoCode of conductNoContributing guideNo

Examples that run: 100%
Documented parameters: not tracked
Return-value docs: not tracked
References docs: 0%

Downloads

2K

CRAN downloads in the past year

Rank #20,558 · ~6/day · ~171/mo

Releases R versions

Daily download trend is not available in this view yet.

14630 days

54190 days

2K1 year

Compare downloads with other packages →

Also on91 r2u10 autocran

Dependencies

Declared dependencies

4 external dependencies (excludes base and recommended)

Depends (0)

none

Imports (5)

crayon rstudioapiutilsstringr NCmisc

LinkingTo (0)

none

Suggests (0)

none

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Nothing depends on this yet.

Code & Tests

People & History

People (1)

Maintainer (1)

Arkadiusz W. Pajda

Author, Maintainer, Copyright holder

Authors (1)

Arkadiusz W. Pajda

Author, Maintainer, Copyright holder

Copyright holders (1)

Arkadiusz W. Pajda

Author, Maintainer, Copyright holder

Package Timeline

2 releases. Pick two to compare their code metrics. R releases are shown for context.

R
R 4.6.0 released · 2026-04-24
R
R 4.5.0 released · 2025-04-11
R
R 4.4.0 released · 2024-04-24
1.1.0Latest
2023-11-15 · current release · diff ↗
1.0.4
2023-09-27
R
R 4.3.0 released · 2023-04-21

Package metadata

First published: 2023-09-27
Total releases: 2 / 3 yrs
License: GPL-3 OSI
Download size: 5.2 KB
Installed size: not tracked yet
With dependencies: not tracked yet

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("nolock")

Format

Pajda, A. W. (2023). nolock: Append 'WITH (NOLOCK)' to 'SQL' Queries, Get Packages in Active Script (Version 1.1.0) [Computer software]. https://doi.org/10.32614/CRAN.package.nolock

This is what citation() produces when a package has no citation file of its own. If it prints something else, use that.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for nolock version 1.1.0 [Data set]. HJJB, LLC. Data release v2026-08-22. https://doi.org/10.5281/zenodo.21843040

From data release v2026-08-22, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →