Package: nolock 1.1.0
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.
Authors:
nolock_1.1.0.tar.gz
nolock_1.1.0.zip(r-4.5)nolock_1.1.0.zip(r-4.4)nolock_1.1.0.zip(r-4.3)
nolock_1.1.0.tgz(r-4.4-any)nolock_1.1.0.tgz(r-4.3-any)
nolock_1.1.0.tar.gz(r-4.5-noble)nolock_1.1.0.tar.gz(r-4.4-noble)
nolock_1.1.0.tgz(r-4.4-emscripten)nolock_1.1.0.tgz(r-4.3-emscripten)
nolock.pdf |nolock.html✨
nolock/json (API)
| # Install 'nolock' in R: |
| install.packages('nolock', repos = c('https://artllex.r-universe.dev', 'https://cloud.r-project.org')) |
This package does not link to any Github/Gitlab/R-forge repository. No issue tracker or development information is available.
Last updated 1 years agofrom:eba7418051. Checks:OK: 7. Indexed: yes.
| Target | Result | Date |
|---|---|---|
| Doc / Vignettes | OK | Nov 11 2024 |
| R-4.5-win | OK | Nov 11 2024 |
| R-4.5-linux | OK | Nov 11 2024 |
| R-4.4-win | OK | Nov 11 2024 |
| R-4.4-mac | OK | Nov 11 2024 |
| R-4.3-win | OK | Nov 11 2024 |
| R-4.3-mac | OK | Nov 11 2024 |
Exports:libr_calledlibr_unusedlibr_usednolock
Dependencies:clicrayongluelifecyclemagrittrNCmiscrlangrstudioapistringistringrvctrs
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| 'Get Packages Called in the Active 'R' Script' | libr_called |
| 'Get Unused Packages in the Active 'R' Script' | libr_unused |
| 'Get Packages Used in the Active Script' | libr_used |
| 'Append WITH (NOLOCK) to SQL Queries' | nolock |
