Crandore Hub

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.

Versions across snapshots

VersionRepositoryFileSize
1.1.0 rolling linux/jammy R-4.5 nolock_1.1.0.tar.gz 26.4 KiB
1.1.0 rolling linux/noble R-4.5 nolock_1.1.0.tar.gz 26.5 KiB
1.1.0 rolling source/ R- nolock_1.1.0.tar.gz 5.2 KiB
1.1.0 latest linux/jammy R-4.5 nolock_1.1.0.tar.gz 26.4 KiB
1.1.0 latest linux/noble R-4.5 nolock_1.1.0.tar.gz 26.5 KiB
1.1.0 latest source/ R- nolock_1.1.0.tar.gz 5.2 KiB
1.1.0 2026-04-26 source/ R- nolock_1.1.0.tar.gz 5.2 KiB
1.1.0 2026-04-23 source/ R- nolock_1.1.0.tar.gz 5.2 KiB
1.1.0 2026-04-09 windows/windows R-4.5 nolock_1.1.0.zip 29.4 KiB
1.1.0 2025-04-20 source/ R- nolock_1.1.0.tar.gz 5.2 KiB

Dependencies (latest)

Imports