Other packages > Find by keyword >

nolock  

Append 'WITH (NOLOCK)' to 'SQL' Queries, Get Packages in Active Script
View on CRAN: Click here


Download and install nolock package within the R console
Install from CRAN:
install.packages("nolock")

Install from Github:
library("remotes")
install_github("cran/nolock")

Install by package version:
library("remotes")
install_version("nolock", "1.1.0")



Attach the package and use:
library("nolock")
Maintained by
Arkadiusz W. Pajda
[Scholar Profile | Author Map]
First Published: 2023-09-27
Latest Update: 2023-11-15
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.
How to cite:
Arkadiusz W. Pajda (2023). nolock: Append 'WITH (NOLOCK)' to 'SQL' Queries, Get Packages in Active Script. R package version 1.1.0, https://cran.r-project.org/web/packages/nolock. Accessed 06 Apr. 2025.
Previous versions and publish date:
1.0.4 (2023-09-27 10:50)
Other packages that cited nolock R package
View nolock citation profile
Other R packages that nolock depends, imports, suggests or enhances
Complete documentation for nolock
Functions, R codes and Examples using the nolock R package
Some associated functions: libr_called . libr_unused . libr_used . nolock . 
Some associated R codes: libr_called.R . libr_unused.R . libr_used.R . nolock.R .  Full nolock package functions and examples
Downloads during the last 30 days
03/0703/0803/0903/1003/1103/1203/1303/1403/1503/1603/1703/1803/1903/2003/2103/2203/2303/2403/2503/2603/2703/2803/2903/3003/3104/0104/0204/0304/04Downloads for nolock02468101214TrendBars

Today's Hot Picks in Authors and Packages

listarrays  
A Toolbox for Working with R Arrays in a Functional Programming Style
A toolbox for R arrays. Flexibly split, bind, reshape, modify, subset and name arrays. ...
Download / Learn more Package Citations See dependency  
ider  
Various Methods for Estimating Intrinsic Dimension
An implementation of various methods for estimating intrinsic dimension of vector-valued dataset or ...
Download / Learn more Package Citations See dependency  
danstat  
R Client for the Statistics Denmark Databank API
The purpose of the package is to enable an R function interface into the Statistics Denmark Databank ...
Download / Learn more Package Citations See dependency  
r2resize  
In-Text Resize for Images, Tables and Fancy Resize Containers in 'shiny', 'rmarkdown' and 'quarto' Documents
Automatic resizing toolbar for containers, images and tables. Various resizable or expandable contai ...
Download / Learn more Package Citations See dependency  
FuzzyQ  
Fuzzy Quantification of Common and Rare Species
Fuzzy clustering of species in an ecological community as common or rare based on their abundance a ...
Download / Learn more Package Citations See dependency  
spCP  
Spatially Varying Change Points
Implements a spatially varying change point model with unique intercepts, slopes, variance intercep ...
Download / Learn more Package Citations See dependency  

23,990

R Packages

207,311

Dependencies

64,809

Author Associations

23,991

Publication Badges

© Copyright since 2022. All right reserved, rpkg.net.  Based in Cambridge, Massachusetts, USA