R Observatory: Metrics for odbc version 1.7.0

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

odbc

1.7.0

Connect to ODBC Compatible Databases (using the DBI Interface)

49packages depend

1.6Mdownloads / year

38.6%test coverage

11/13checks pass

Overview

About

Maintained by Hadley WickhamFirst published 2017-02-0530 releasesCRAN page ↗GitHub ↗

A DBI-compatible interface to ODBC databases.

Install

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

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

Development version from r-dbi/odbc. 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-odbc

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

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

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: 5.3 min · r-devel-windows-x86_64

Code health

Yes

Tests · ratio 0.52

38.6%

Coverage · measured lines

100%

Documentation · exports

10

Dependencies · direct

Check history

NOTE2026-05-10
12 OK · 1 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
OK2026-05-02
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
NOTE2026-04-22
12 OK · 2 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-04-18
11 OK · 2 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
NOTE2026-03-10
12 OK · 2 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

READMEYes · 405 wordsVignettesYes · dynamicpkgdown siteNoNEWSYes · 100% structuredCode of conductNoContributing guideNo

Examples that run: 30%
Documented parameters: 80%
Return-value docs: 73%
References docs: 0%

Downloads

1.6M

CRAN downloads in the past year

Rank #272 · ~4.4K/day · ~134.9K/mo

Releases R versions

Daily download trend is not available in this view yet.

147.1K30 days

452.9K90 days

1.6M1 year

Compare downloads with other packages →

Also on10.9K r2u65 autocran18.7K conda_forge260 c2d4u

Repository

GitHub ↗ r-dbi/odbc

413Stars

117Forks

67Open issues

7Open PRs

23Releases

1,361Commits

48Contributors

rdatabaseodbc

1,361 commits · Last activity 2026-07-23 · -0.2% stars, 30d

Stars over time

2025-07-05 · 4012026-07-21 · 413

Repository practices

Upstream repositoryBeta

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

Checks run against github.com/r-dbi/odbc on 2026-08-16.

Continuous integration (1)

GitHub Actions

Reproducibility and dev environment (1)

Makefile

CRAN release process (2)

cran-comments.mdrevdep/

Docs source (1)

README.Rmd

Show all practices

Lint, format, editor (1)

RStudio project

Coverage (2)

Codecov.covrignore

Governance and community (1)

Issue templates

How this is detected·Detection ruleset v1 (2026-07-18)

Dependencies

Declared dependencies

23 external dependencies (excludes base and recommended)

Depends (1)

R >= 4.0.0

Imports (10)

bit64 blob cli DBI hms lifecyclemethodsRcpp rlang vctrs

LinkingTo (1)

Rcpp

Suggests (13)

connectcreds covr DBItest httr2 knitr magrittr paws.common rmarkdown RSQLite snowflakeauth testthat tibble withr

Enhances (0)

none

Dependency license breakdown →

Code & Tests

People & History

People (7)

Maintainer (1)

Hadley Wickham

Author, Maintainer

Authors (4)

Hadley Wickham

Author, Maintainer

Simon Couch

Author · added in 1.6.2

Oliver Gjoneski

Author · added in 1.3.4

Jim Hester

Author

Copyright holders (3)

Google Inc.

Copyright holder · added in 1.1.0

Posit Software, PBC

Copyright holder, Funder · added in 1.4.0

lexicalunit

Copyright holder · added in 1.1.0

Funders (1)

Posit Software, PBC

Copyright holder, Funder · added in 1.4.0

Listed in earlier versions (3)

RStudio

no longer listed · 1.0.0 to 1.0.1

RStudio

no longer listed · 1.1.0 to 1.3.5

Oliver

no longer listed · 1.3.0 to 1.3.3

Package Timeline

30 releases. Pick two to compare their code metrics. R releases are shown for context.

1.7.0Latest
2026-05-09 · current release · diff ↗
R
R 4.6.0 released · 2026-04-24
1.6.4.1
2025-12-24 · diff ↗
1.6.4
2025-12-06 · diff ↗
1.6.3
2025-09-05 · diff ↗
1.6.2
2025-08-29 · diff ↗
R
R 4.5.0 released · 2025-04-11
1.6.1
2025-03-27 · diff ↗
1.6.0
2025-02-28 · diff ↗
1.5.0
2024-06-05 · diff ↗
R
R 4.4.0 released · 2024-04-24
1.4.2
2024-01-23 · diff ↗
1.4.1
2023-12-21 · diff ↗
1.4.0
2023-12-15 · diff ↗
1.3.5
2023-06-29 · diff ↗
R
R 4.3.0 released · 2023-04-21

Show 25 earlier events

1.3.4
2023-01-17 · diff ↗
R
R 4.2.0 released · 2022-04-22
1.3.3
2021-11-30 · diff ↗
R
R 4.1.0 released · 2021-05-18
1.3.2
2021-04-03 · diff ↗
1.3.1
2021-03-16 · diff ↗
1.3.0
2020-10-27 · diff ↗
1.2.3
2020-06-18 · diff ↗
R
R 4.0.0 released · 2020-04-24
1.2.2
2020-01-10 · diff ↗
1.2.1
2019-12-05 · diff ↗
1.2.0
2019-11-28 · diff ↗
R
R 3.6.0 released · 2019-04-26
1.1.6
2018-06-09 · diff ↗
R
R 3.5.0 released · 2018-04-23
1.1.5
2018-01-23 · diff ↗
1.1.4
2018-01-11 · diff ↗
1.1.3
2017-10-05 · diff ↗
1.1.2
2017-10-03 · diff ↗
1.1.1
2017-06-27 · diff ↗
1.1.0
2017-06-23 · diff ↗
R
R 3.4.0 released · 2017-04-21
1.0.1
2017-02-07 · diff ↗
1.0.0
2017-02-05
R
R 3.3.0 released · 2016-05-03

Package metadata

First published: 2017-02-05
Total releases: 30 / 9 yrs
License: MIT + file LICENSE OSI
Minimum R: ≥ 4.0.0
Download size: 359 KB
Installed size: not tracked yet
With dependencies: not tracked yet

Appears in task views

Databases with R

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("odbc")

Format

Wickham, H., Google Inc., Posit Software, PBC, lexicalunit, Couch, S., Gjoneski, O., & Hester, J. (2026). odbc: Connect to ODBC Compatible Databases (using the DBI Interface) (Version 1.7.0) [Computer software]. https://doi.org/10.32614/CRAN.package.odbc

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 odbc version 1.7.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 →