R Observatory: Metrics for RSQLite version 3.53.3

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

RSQLite

3.53.3

SQLite Interface for R

118packages dependsuggested by 148

2.7Mdownloads / year

28.8%test coverage

13/13flavors OK

Overview

About

Maintained by Kirill MüllerCRAN page ↗GitHub ↗Website ↗Issues ↗Declared funder: R Consortium

Embeds the SQLite database engine in R and provides an interface compliant with the DBI package. The source for the SQLite engine and for various extensions is included. System libraries will never be consulted because this package relies on static linking for the plugins it includes; this also ensures a consistent experience across all installations. Optionally, when libcurl is available at build time, an experimental HTTP/HTTPS virtual file system (VFS) can be enabled to allow read-only access to remote immutable SQLite database files via URIs.

Changes in 3.53.3

Features

Upgrade bundled SQLite to 3.53.3 (#761).

Bug fixes

Restore C90 and C17 compatibility of the bundled HTTP VFS sources (http.c), fixing builds with stricter system compilers (@davidrsch, #750).

From NEWS.md in the release

Install

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

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

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

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("r-dbi/RSQLite")

Development version from r-dbi/RSQLite. Installs pak first if it is not already available.

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

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

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

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: 9.8 min · r-oldrel-windows-x86_64

Status changes

OK13 OK2026-09-24
ERROR12 OK, 1 ERROR2026-09-11
OK13 OK2026-09-09
ERROR12 OK, 1 ERROR2026-09-06
OK13 OK2026-08-26

Show 7 earlier changesHide 7 earlier changes

ERROR12 OK, 1 ERROR2026-08-24
OK13 OK2026-08-05
NOTE12 OK, 1 NOTE2026-08-01
OK13 OK2026-06-06
ERROR12 OK, 1 ERROR2026-06-01
OK13 OK2026-05-02
NOTE12 OK, 2 NOTE2026-03-10

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 3.53.3

READMEYes · 521 wordsVignettesYes · 1 · dynamicNEWSYes · 100% structured · mentions 3.53.3Citation fileNoWebsiteYes · pkgdown

Help pages: 27 (13 internal)includes a package overview page
Examples that run: 100%12 run in a plain check (1 of them under a condition)
Exported functions with examples: 53%
Documented parameters: 82%
Return-value docs: 47%
Help pages citing references: 4%

Vignettes (1)

RSQLite HTML

How these are measured

Downloads

2.7M

CRAN downloads in the past year

Rank #221 · ~7.4K/day · ~223.6K/mo

Releases R versions

Daily download trend is not available in this view yet.

188.2K30 days

636.1K90 days

2.7M1 year

Compare downloads with other packages →

Also on42.2K r2u201 autocran401.6K conda_forge1.6K c2d4u

How downloads are counted

Repository

r-dbi/rsqlite ↗Organization: r-dbi

342Stars

82Forks

28Open issues

15Open PRs

54Releases

3,586Commits

57Commit identities

rsqlite3database

License file reads as LGPL-2.1 · 3,586 commits · Last activity 2026-10-11 · +0.3% stars, 30d · Default branch at 3.53.3.9015, ahead of CRAN 3.53.3 (checked 2026-10-11)

Responsiveness

How these are sampled

PRs merged (all time): 88%
Median days to close, 50 most recently updated closed issues: 25
Median days to close, 50 most recently updated closed PRs: 0

Stars over time

2025-09-27 · 3322026-09-25 · 342

How these are measured

PracticesBeta

15 development-tooling and community-health practices detected across 7 families in the upstream repository

Checks run against github.com/r-dbi/rsqlite on 2026-10-11.

Continuous integration (2)

GitHub ActionsR CMD check workflow

The R CMD check workflow runs on Linux and Windows

Governance and community (3)

Code of conductContributing guideIssue templates

Docs source (4)

README.Rmdpkgdown

GitHub Pages site last deployed 2026-09-27 · The repository has a site deploy workflow

pkgdown site last built 2026-07-16

Coverage (1)

Coverage reporting (Codecov)

Show all practicesHide 3 practices

Reproducibility and dev environment (2)

data-raw/Gitpod

CRAN release process (2)

cran-comments.mdrevdep/

Lint, format, editor (1)

RStudio project

How this is detected·Detection ruleset v3 (2026-09-26)

AI coding toolsBeta

This repository shows signs of AI coding tools.

GitHub Copilotfirst seen 2026-02-21
Pull request: opened by its own account
Commits: 1 by its own account
Claude Codefirst seen 2026-05-16
Pull request it wrote: opened by a project member
Commits: 8 by its own account · at least 52 crediting it in the message

Models named in its commits

Claude Opus 515 commits · Aug to Sep 2026
Claude Opus 4.86 commits · Jun 2026
Claude Opus 5.52 commits · Sep 2026
Claude Fable 51 commit · Aug 2026

Counts are commits, not lines of code. Commits by a tool's accounts count once across all of its accounts. Commits crediting it are the largest count among its credit lines, a minimum.How this is detected·Detection ruleset v4 (updated 2026-09-27)

Dependencies

Declared dependencies

22 external dependencies (excludes base and recommended)

Installing RSQLite adds 14 packages (8 with compiled code, 4.2 MB of source tarballs). Heaviest: vctrs 1.0 MB, rlang 766 KB, DBI 727 KB.

Depends (1)

R >= 3.1.0

Imports (7)

bit64 blob DBI memoisemethodspkgconfig rlang

LinkingTo (1)

cpp11

Suggests (15)

callr cli DBItest decor gert gh hms httpuv knitr magrittr rmarkdown rvest testthat withr xml2

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

118direct

67indirect

Depends 8 · Imports 110

Suggested by 148

Show the 48 most downloaded dependentsHide the 48 most downloaded dependents

Depends, Imports or LinkingTo, most downloaded first

and 70 more dependents and 148 packages that suggest it on CRAN ↗

How these are counted

Code & Tests

People & History

People (11)

Kirill Müller

Author, Maintainer since 1.1 (2016) · added in 1.1

Seth Falcon

Author · added in 0.11.2

David A. James

Author

Hadley Wickham

Author · added in 1.1

Liam Healy

Contributor · added in 1.1