R Observatory: Metrics for SQRL version 1.0.3

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

SQRL

1.0.3Package record

Enhances Interaction with 'ODBC' Databases

0packages depend

4.6Kdownloads / year

–test coverage

13/13flavors OK

Overview

About

Maintained by Mike LeeCRAN page ↗

Provides simple and powerful interfaces that facilitate interaction with 'ODBC' data sources. Each data source gets its own unique and dedicated interface, wrapped around 'RODBC'. Communication settings are remembered between queries, and are managed silently in the background. The interfaces support multi-statement 'SQL' scripts, which can be parameterised via metaprogramming structures and embedded 'R' expressions.

Install

R (CRAN)Ubuntu (r2u)Fedora (COPR)openSUSE (OBS)

install.packages("SQRL", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-sqrl

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled. We list this channel from recorded r2u download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-SQRL

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-SQRL

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed). We list this channel from recorded autoCRAN download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

Health

CRAN checks

13OK

CRAN check page ↗

Slowest check: 1.4 min · r-oldrel-macos-x86_64

Status changes

OK13 OK2026-08-05
NOTE12 OK, 1 NOTE2026-08-01
OK12 OK2026-04-25
NOTE12 OK, 2 NOTE2026-03-10

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 1.0.3

READMENoVignettesYes · 1 · staticNEWSNoCitation fileNoWebsitenot declared in DESCRIPTION

Help pages: 10includes a package overview page
Examples that run: 89%8 run in a plain check · 1 never run
Exported functions with examples: 89%
Documented parameters: not tracked
Return-value docs: not tracked
Help pages citing references: 0%

Vignettes (1)

SQRL Features and Usage PDF

How these are measured

Downloads

4.6K

CRAN downloads in the past year

Rank #6,985 · ~13/day · ~382/mo

Releases R versions

Daily download trend is not available in this view yet.

49330 days

1.2K90 days

4.6K1 year

Compare downloads with other packages →

Also on101 r2u10 autocran82 c2d4u

How downloads are counted

Dependencies

Declared dependencies

1 external dependency (excludes base and recommended)

Installing SQRL adds 1 package (1 with compiled code, 920 KB of source tarballs). Heaviest: RODBC 920 KB.

Depends (1)

R >= 3.3.0

Imports (1)

RODBC

LinkingTo (0)

none

Suggests (2)

toolsutils

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Nothing depends on this yet.

How these are counted

Code & Tests

People & History

People (1)

Mike Lee

Author, Maintainer since 0.1.0 (2017)

Releases (21)

Pick two releases to compare their code metrics.

R
R 4.6.0 released · 2026-04-24
1.0.3Latest
record
2026-04-21 · current release · diff ↗
R
R 4.5.0 released · 2025-04-11
R
R 4.4.0 released · 2024-04-24
1.0.2
record
2023-12-03 · diff ↗
R
R 4.3.0 released · 2023-04-21
1.0.1
record
2022-09-20 · diff ↗
R
R 4.2.0 released · 2022-04-22
1.0.0
record
2021-09-30 · diff ↗
R
R 4.1.0 released · 2021-05-18
0.8.0
record
2021-03-07 · diff ↗
0.7.4
record
2020-11-22 · diff ↗
0.7.3
record
2020-08-27 · diff ↗
0.7.2
record
2020-05-14 · diff ↗
R
R 4.0.0 released · 2020-04-24
0.7.1
record
2020-03-14 · diff ↗

Show 15 earlier eventsHide 15 earlier events

0.7.0
record
2019-11-07 · diff ↗
0.6.3
record
2019-07-08 · diff ↗
R
R 3.6.0 released · 2019-04-26
0.6.2
record
2019-02-14 · diff ↗
0.6.1
record
2019-02-01 · diff ↗
0.6.0
record
2019-01-31 · diff ↗
0.5.0
record
2018-10-12 · diff ↗
0.4.0
record
2018-06-03 · diff ↗
R
R 3.5.0 released · 2018-04-23
0.3.0
record
2018-04-16 · diff ↗
0.2.1
record
2018-03-10 · diff ↗
0.2.0
record
2018-03-08 · diff ↗
0.1.1
record
2018-01-08 · diff ↗
0.1.0
record
2017-11-12
R
R 3.4.0 released · 2017-04-21

Package metadata

First published: 2017-11-12
Total releases: 21 / 9 yrs
License: GPL-3 OSI
Minimum R: ≥ 3.3.0
Download size: 224 KB

Appears in task views

Databases with R

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("SQRL")

Format

Lee, M. (2026). SQRL: Enhances Interaction with 'ODBC' Databases (Version 1.0.3) [Computer software]. https://doi.org/10.32614/CRAN.package.SQRL

This package has no citation file, so citation() returns this entry built from DESCRIPTION.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for SQRL version 1.0.3 [Data set]. HJJB, LLC. Data release v2026-10-18. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-18, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →