nolock
Append 'WITH (NOLOCK)' to 'SQL' Queries, Get Packages in Active Script
Description
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.
Downloads
210
Last 30 days
21339th
531
Last 90 days
2.1K
Last year
Trend: +50% (30d vs prior 30d)
9
Last 30 days
23
Last 90 days
95
Last year
Trend: -35.7% (30d vs prior 30d)
3
Last 7 days
8
Last 30 days
0
All-time
autoCRAN-only: this name is served only by autoCRAN, so the count is exact.
CRAN Check Status
Show all 13 flavors
| Flavor | Status |
|---|---|
| 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 | NOTE |
Check details (13 non-OK)
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
'libr_called.R' 'libr_unused.R' 'libr_used.R'
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
'libr_called.R' 'libr_unused.R' 'libr_used.R'
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
'libr_called.R' 'libr_unused.R' 'libr_used.R'
Check History
NOTE 3 OK · 11 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
'libr_called.R' 'libr_unused.R' 'libr_used.R'
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
‘libr_called.R’ ‘libr_unused.R’ ‘libr_used.R’
DESCRIPTION meta-information
Missing dependency on R >= 4.1.0 because package code uses the pipe
|> or function shorthand \(...) syntax added in R 4.1.0.
File(s) using such syntax:
'libr_called.R' 'libr_unused.R' 'libr_used.R'