R Observatory: Metrics for sqliteutils version 0.1.0

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

sqliteutils

0.1.0

Utility Functions for 'SQLite'

0packages depend

2.1Kdownloads / year

100.0%test coverage

11/13checks pass

Overview

About

Maintained by Bruno CrotmanFirst published 2021-09-211 releasesCRAN page ↗

A tool for working with 'SQLite' databases. 'SQLite' has some idiosyncrasies and limitations that impose some hurdles to the R developer who is using this database as a repository. For instance, 'SQLite' doesn't have a date type and 'sqliteutils' has some functions to deal with that.

Install

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

install.packages("sqliteutils", 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-sqliteutils

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled.

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-sqliteutils

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-sqliteutils

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed).

Health

CRAN checks

2NOTE11OK

Failing flavors

NOTE r-devel-linux-x86_64-fedora-clang
NOTE r-devel-linux-x86_64-fedora-gcc

Slowest check: 54 s · r-devel-windows-x86_64

Code health

Yes

Tests · ratio 1.16

100.0%

Coverage · measured lines

67%

Documentation · exports

5

Dependencies · direct

Check history

NOTE2026-06-09
11 OK · 2 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-06-08
10 OK · 2 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
NOTE2026-03-10
12 OK · 2 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

READMEYes · 135 wordsVignettesNopkgdown siteNoNEWSNoCode of conductNoContributing guideNo

Examples that run: 100%
Documented parameters: 100%
Return-value docs: 100%
References docs: 0%

Downloads

2.1K

CRAN downloads in the past year

Rank #21,750 · ~6/day · ~172/mo

Releases R versions

Daily download trend is not available in this view yet.

9730 days

50290 days

2.1K1 year

Compare downloads with other packages →

Also on102 r2u9 autocran

Dependencies

Declared dependencies

6 external dependencies (excludes base and recommended)

Depends (0)

none

Imports (5)

RSQLite DBI dplyr dbplyr magrittr

LinkingTo (0)

none

Suggests (1)

testthat

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Nothing depends on this yet.

Code & Tests

People & History

People (1)

Maintainer (1)

Bruno Crotman

Author, Maintainer

Authors (1)

Bruno Crotman

Author, Maintainer

Package Timeline

1 release. R releases are shown for context.

R
R 4.6.0 released · 2026-04-24
0.1.0Latest
2026-03-10 · current release
R
R 4.5.0 released · 2025-04-11

Package metadata

First published: 2021-09-21
Total releases: 1 / 5 yrs
License: MIT + file LICENSE OSI
Download size: 6.7 KB
Installed size: not tracked yet
With dependencies: not tracked yet

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("sqliteutils")

Format

Crotman, B. (2021). sqliteutils: Utility Functions for 'SQLite' (Version 0.1.0) [Computer software]. https://doi.org/10.32614/CRAN.package.sqliteutils

This is what citation() produces when a package has no citation file of its own. If it prints something else, use that.

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 sqliteutils version 0.1.0 [Data set]. HJJB, LLC. Data release v2026-08-18. https://doi.org/10.5281/zenodo.21843040

From data release v2026-08-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 →