R Observatory: Metrics for mdbr version 0.4.0

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

mdbr

0.4.0Package record

Work with Microsoft Access Files

0packages depend

4.6Kdownloads / year

50.3%test coverage

13/13flavors OK

Overview

About

Maintained by Kiernan NichollsCRAN page ↗GitHub ↗Website ↗Issues ↗

Work with Microsoft Access '.mdb' and '.accdb' files using the open source 'MDB Tools' library https://github.com/mdbtools/mdbtools/. The library is compiled and bundled with the package, so no external installation is required. Provides high-level helpers for reading tables, exporting to CSV or JSON, inspecting table definitions, and running SQL queries. Also exposes a full read-only 'DBI' interface for use with standard database workflows.

Changes in 0.4.0

Breaking changes

Binary and OLE fields are now returned as list columns of raw vectors instead of character strings (#18).
Empty text values are now returned as "" instead of NA. Only NULL values become NA (#18).
mdb_example() now returns the bundled Northwind database (nwind.mdb). The nycflights13 example file has been removed (#18).

New features

New mdb_stream_table() opens a table as a DBI result that can be read in batches with DBI::dbFetch(), keeping memory use bounded for large tables. dbReadTable() and read_mdb() now read through the same cursor. SQL queries sent with dbSendQuery() are still read in full (#18, @meztez).

Show all changes in 0.4.0Hide the rest of the changes in 0.4.0

Bug fixes

dbFetch() now advances through dbSendQuery() results across successive calls, and dbHasCompleted() reports completion correctly (#18).
dbFetch() accepts n = 0 and returns a zero-row data frame with the correct column types. dbIsValid() is now FALSE after dbClearResult() (#18).

From NEWS.md in the release

Install

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

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

Development version from k5cents/mdbr. 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-mdbr

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

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

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

Status changes

OK13 OK2026-08-05
NOTE12 OK, 1 NOTE2026-08-01
OK13 OK2026-07-19
WARNING12 OK, 1 WARNING2026-07-16
OK13 OK2026-05-29

Show 2 earlier changesHide 2 earlier changes

ERROR11 OK, 2 ERROR2026-05-24
OK14 OK2026-03-10

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 0.4.0

READMEYes · 199 wordsVignettesNoNEWSYes · 100% structured · mentions 0.4.0Citation fileNoWebsiteYes · pkgdown

Help pages: 19 (1 internal)
Examples that run: 82%14 run in a plain check · 3 never run
Exported functions with examples: 100%
Documented parameters: 96%
Return-value docs: 100%
Help pages citing references: 0%

How these are measured

Downloads

4.6K

CRAN downloads in the past year

Rank #6,195 · ~12/day · ~380/mo

Releases R versions

Daily download trend is not available in this view yet.

50330 days

1.4K90 days

4.6K1 year

Compare downloads with other packages →

Also on183 r2u3 autocran

How downloads are counted

Repository

k5cents/mdbr ↗Account: k5cents

14Stars

2Forks

0Open issues

0Open PRs

2Releases

155Commits

4Commit identities

mdbmicrosoft-access

License file reads as GPL-3.0 · 155 commits · Last activity 2026-09-26 · 0% stars, 30d · Default branch at 0.4.0.9000, ahead of CRAN 0.4.0 (checked 2026-10-22)

Responsiveness

How these are sampled

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

Stars over time

2024-09-04 · 122026-07-07 · 14

How these are measured

PracticesBeta

12 development-tooling and community-health practices detected across 6 families in the upstream repository

Checks run against github.com/k5cents/mdbr on 2026-10-22.

Continuous integration (2)

GitHub ActionsR CMD check workflow

The R CMD check workflow runs on Linux, macOS and Windows, and on R-devel

Governance and community (4)

Code of conductContributing guideIssue templatesSupport guide

Docs source (3)

README.Rmd

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

Coverage (1)

Coverage reporting

Show all practicesHide 2 practices

CRAN release process (1)

cran-comments.md

Lint, format, editor (1)

RStudio project

How this is detected·Detection ruleset v4 (2026-10-20)

AI coding toolsBeta

This repository shows signs of AI coding tools.

Claude Codefirst seen 2026-05-22
Commits: at least 23 crediting it in the message

Models named in its commits

Claude Sonnet 4.617 commits · May to Jul 2026
Claude Opus 5.56 commits · Sep 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

6 external dependencies (excludes base and recommended)

Installing mdbr adds 12 packages (8 with compiled code, 5.7 MB of source tarballs). Heaviest: jsonlite 1.0 MB, vctrs 1.0 MB, rlang 766 KB.

Depends (0)

none

Imports (6)

DBI lifecyclemethodstibbleutilsjsonlite

LinkingTo (0)

none

Suggests (2)

readr testthat

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Nothing depends on this yet.

How these are counted

Code & Tests

People & History

People (2)

Kiernan Nicholls

Bruno Tremblay

Contributor · added in 0.3.0

DBI interface and bundled mdbtools source

Releases (6)

Pick two releases to compare their code metrics.

0.4.0Latest
record
2026-09-26 · current release · diff ↗ ·
added 1 export
mdb_stream_table
0.3.2
record
2026-05-28 · diff ↗
0.3.1
record
2026-05-28 · diff ↗
0.3.0
record
2026-05-23 · diff ↗ ·
added 11 exports
mdb, mdb_array, mdb_count, mdb_export, mdb_header, mdb_hexdump, mdb_json, mdb_prop, mdb_queries, mdb_sql, mdb_ver
R
R 4.6.0 released · 2026-04-24
R
R 4.5.0 released · 2025-04-11
R
R 4.4.0 released · 2024-04-24
0.2.1
record
2024-03-12 · diff ↗
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
0.1.2
record
2020-11-09
R
R 4.0.0 released · 2020-04-24

Package metadata

First published: 2020-11-09
Total releases: 6 / 6 yrs
License: GPL-3 | LGPL-2 OSI · relicensed from GPL-3 in 0.3.0
Download size: 1.2 MB

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("mdbr")

Format

Nicholls, K., & Tremblay, B. (2026). mdbr: Work with Microsoft Access Files (Version 0.4.0) [Computer software]. https://doi.org/10.32614/CRAN.package.mdbr

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

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