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.
| Version: |
1.1.0 |
| Imports: |
crayon, rstudioapi, utils, stringr, NCmisc |
| Published: |
2023-11-15 |
| Author: |
Arkadiusz W. Pajda [aut, cre, cph] |
| Maintainer: |
Arkadiusz W. Pajda <arkadiusz.pajda.97 at onet.pl> |
| License: |
GPL-3 |
| NeedsCompilation: |
no |
| CRAN checks: |
nolock results |
Documentation:
Downloads:
Linking:
Please use the canonical form
https://CRAN.R-project.org/package=nolock
to link to this page.