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]
All associated links for this package
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 27 Oct. 2026.
Previous versions and publish date:
(2026-07-09 06:25), 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

Today's Hot Picks in Authors and Packages

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  
SGB  
Simplicial Generalized Beta Regression
Main properties and regression procedures using a generalization of the Dirichlet distribution calle ...
Download / Learn more Package Citations See dependency  
spanish  
Translate Quantities from Strings to Integer and Back. Misc Functions on Spanish Data
Character vector to numerical translation in Euros from Spanish spelled monetary quantities. Reverse ...
Download / Learn more Package Citations See dependency  
exams2learnr  
Interface for 'exams' Exercises in 'learnr' Tutorials
Automatic generation of quizzes or individual questions for 'learnr' tutorials based on 'R/exams' ex ...
Download / Learn more Package Citations See dependency  
usemodels  
Boilerplate Code for 'Tidymodels' Analyses
Code snippets to fit models using the tidymodels framework can be easily created for a given data se ...
Download / Learn more Package Citations See dependency  

29,218

R Packages

247,686

Dependencies

77,281

Author Associations

29,219

Publication Badges

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