R Observatory: Metrics for sqldf version 0.4-12

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

sqldf

0.4-12Package record

Manipulate R Data Frames Using SQL

24packages dependsuggested by 4

253.5Kdownloads / year

42.4%test coverage

13/13flavors OK

Overview

About

Maintained by G. GrothendieckCRAN page ↗GitHub ↗Issues ↗

The sqldf() function is typically passed a single argument which is an SQL select statement where the table names are ordinary R data frame names. sqldf() transparently sets up a database, imports the data frames into that database, performs the SQL select or other statement and returns the result using a heuristic to determine which class to assign to each column of the returned data frame. The sqldf() or read.csv.sql() functions can also be used to read filtered files into R even if the original files are larger than R itself can handle. 'RSQLite', 'RH2', 'RMySQL' and 'RPostgreSQL' backends are supported.

Changes in 0.4-12

satisfy CRA checks. No code changes.

From inst/NEWS in the release

Install

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

install.packages("sqldf", 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("ggrothendieck/sqldf")

Development version from ggrothendieck/sqldf. 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-sqldf

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

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

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-release-macos-x86_64

Status changes

OK13 OK2026-08-04
NOTE12 OK, 1 NOTE2026-08-01
OK14 OK2026-03-10

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 0.4-12

READMEYes · 7,294 wordsVignettesNoNEWSYes · 33% structured · mentions 0.4-12Citation fileNoWebsitenot declared in DESCRIPTION

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

Also includes 2 demo scripts (run with demo())

How these are measured

Downloads

253.5K

CRAN downloads in the past year

Rank #865 · ~694/day · ~21.1K/mo

Releases R versions

Daily download trend is not available in this view yet.

15.7K30 days

49.8K90 days

253.5K1 year

Compare downloads with other packages →

Also on1.6K r2u77 autocran6.5K conda_forge190 bioconda670 c2d4u

How downloads are counted

Repository

ggrothendieck/sqldf ↗Account: ggrothendieck

252Stars

79Forks

17Open issues

0Open PRs

0Releases

131Commits

8Commit identities

131 commits · Last activity 2026-09-12 · 0% stars, 30d · Default branch at 0.4-14, ahead of CRAN 0.4-12 (checked 2026-10-18)

Responsiveness

How these are sampled

PRs merged (all time): 50%
Median days to close, 50 most recently updated closed issues: 4
Median days to close, 50 most recently updated closed PRs: 548

Stars over time

2025-06-10 · 2492026-07-07 · 252

How these are measured

PracticesBeta

3 development-tooling and community-health practices detected across 2 families in the upstream repository

Checks run against github.com/ggrothendieck/sqldf on 2026-10-18.

Continuous integration (1)

GitHub Actions

CRAN release process (2)

cran-comments.mdCRAN-SUBMISSION

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

Dependencies

Declared dependencies

9 external dependencies (excludes base and recommended)

Installing sqldf adds 18 packages (10 with compiled code, 9.2 MB of source tarballs). Heaviest: RSQLite 4.2 MB, vctrs 1.0 MB, rlang 766 KB.

Depends (4)

R >= 3.1.0gsubfn proto RSQLite

Imports (2)

DBI chron

LinkingTo (0)

none

Suggests (6)

RH2 RMySQL RPostgreSQL svUnittcltkMASS

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

24direct

4indirect

Depends 3 · Imports 21

Suggested by 4

Show all 28 packagesHide all 28 packages

Depends, Imports or LinkingTo, most downloaded first

kangar00 smbinning Clustering RSDA tcpl epicR elfgen healthyR FIESTA Fgmutils FIESTAutils puzzle icesDatsuQC fdq nlive Rprofet ACRER metevalue multimorbidity drugprepr scorecardModelUtils dMrs RareComb OnomasticDiversity

Suggests, most downloaded first

R6causal prqlr DOPE remotePARTS

How these are counted

Code & Tests

People & History

People (1)

G. Grothendieck

Author, Maintainer since 0-1.0 (2007)

Releases (28)

Pick two releases to compare their code metrics.

R
R 4.6.0 released · 2026-04-24
0.4-12Latest
record
2026-01-30 · current release · diff ↗
R
R 4.5.0 released · 2025-04-11
R
R 4.4.0 released · 2024-04-24
R
R 4.3.0 released · 2023-04-21
R
R 4.2.0 released · 2022-04-22
R
R 4.1.0 released · 2021-05-18
R
R 4.0.0 released · 2020-04-24
R
R 3.6.0 released · 2019-04-26
R
R 3.5.0 released · 2018-04-23
0.4-11
record
2017-06-28 · diff ↗
R
R 3.4.0 released · 2017-04-21
R
R 3.3.0 released · 2016-05-03
R
R 3.2.0 released · 2015-04-16
0.4-10
record
2014-11-07 · diff ↗
0.4-9
record
2014-10-27 · diff ↗

Show 37 earlier eventsHide 37 earlier events

R
R 3.1.0 released · 2014-04-10
0.4-7.1
record
2014-03-15 · diff ↗
0.4-7
record
2014-02-22 · diff ↗
R
R 3.0.0 released · 2013-04-03
R
R 2.15.0 released · 2012-03-30
0.4-6.4
record
2012-03-28 · diff ↗
0.4-6.1
record
2011-12-19 · diff ↗
0.4-6
record
2011-12-11 · diff ↗
0.4-5
record
2011-11-22 · diff ↗
0.4-4
record
2011-11-15 · diff ↗
0.4-3
record
2011-11-06 · diff ↗ ·
added 1 export
pattern:.
R
R 2.14.0 released · 2011-10-31
0.4-2
record
2011-08-09 · diff ↗
0.4-1.2
record
2011-07-23 · diff ↗
0.4-1
record
2011-06-29 · diff ↗
0.4-0
record
2011-06-15 · diff ↗
R
R 2.13.0 released · 2011-04-13
R
R 2.12.0 released · 2010-10-15
0.3-5
record
2010-06-05 · diff ↗
R
R 2.11.0 released · 2010-04-22
0.3-4
record
2010-02-14 · diff ↗
0-3.3
record
2010-02-07 · diff ↗
0-3.2
record
2010-02-01 · diff ↗
0-2.1
record
2009-12-28 · diff ↗
0-2.0
record
2009-12-24 · diff ↗
R
R 2.10.0 released · 2009-10-26
0-1.7
record
2009-09-24 · diff ↗
0-1.5
record
2009-06-07 · diff ↗
R
R 2.9.0 released · 2009-04-17
0-1.4
record
2008-12-11 · diff ↗
0-1.2
record
2008-12-10 · diff ↗
R
R 2.8.0 released · 2008-10-20
R
R 2.7.0 released · 2008-04-22
R
R 2.6.0 released · 2007-10-03
0-1.1
record
2007-07-29 · diff ↗
0-1.0
record
2007-07-21
R
R 2.5.0 released · 2007-04-24

Package metadata

First published: 2007-07-21
Total releases: 28 / 19 yrs
License: GPL-2 OSI
Minimum R: ≥ 3.1.0
Download size: 60 KB

Appears in task views

Databases with R High-Performance and Parallel Computing with R

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("sqldf")

Format

Grothendieck, G. (2026). sqldf: Manipulate R Data Frames Using SQL (Version 0.4-12) [Computer software]. https://doi.org/10.32614/CRAN.package.sqldf

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 sqldf version 0.4-12 [Data set]. HJJB, LLC. Data release v2026-10-21. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-21, 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 →