nolock

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

CRAN Package

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.

  • Version1.1.0
  • R versionunknown
  • LicenseGPL-3
  • Needs compilation?No
  • Last release11/15/2023

Team


Insights

Last 30 days

This package has been downloaded 173 times in the last 30 days. Enough downloads to make a small wave in the niche community. The curiosity is spreading! The following heatmap shows the distribution of downloads per day. Yesterday, it was downloaded 12 times.

Sun
Mon
Tue
Wed
Thu
Fri
Sat
0 downloadsMar 2, 2025
0 downloadsMar 3, 2025
10 downloadsMar 4, 2025
6 downloadsMar 5, 2025
5 downloadsMar 6, 2025
3 downloadsMar 7, 2025
4 downloadsMar 8, 2025
9 downloadsMar 9, 2025
4 downloadsMar 10, 2025
9 downloadsMar 11, 2025
6 downloadsMar 12, 2025
2 downloadsMar 13, 2025
3 downloadsMar 14, 2025
6 downloadsMar 15, 2025
3 downloadsMar 16, 2025
3 downloadsMar 17, 2025
12 downloadsMar 18, 2025
1 downloadsMar 19, 2025
10 downloadsMar 20, 2025
6 downloadsMar 21, 2025
5 downloadsMar 22, 2025
7 downloadsMar 23, 2025
13 downloadsMar 24, 2025
6 downloadsMar 25, 2025
3 downloadsMar 26, 2025
4 downloadsMar 27, 2025
6 downloadsMar 28, 2025
1 downloadsMar 29, 2025
6 downloadsMar 30, 2025
3 downloadsMar 31, 2025
5 downloadsApr 1, 2025
12 downloadsApr 2, 2025
0 downloadsApr 3, 2025
0 downloadsApr 4, 2025
0 downloadsApr 5, 2025
1
13

The following line graph shows the downloads per day. You can hover over the graph to see the exact number of downloads per day.

Last 365 days

This package has been downloaded 2,096 times in the last 365 days. Consider this 'mid-tier influencer' status—if it were a TikTok, it would get a nod from nieces and nephews. The day with the most downloads was Sep 11, 2024 with 26 downloads.

The following line graph shows the downloads per day. You can hover over the graph to see the exact number of downloads per day.

Data provided by CRAN


Binaries


Dependencies

  • Imports4 packages