R Observatory: Metrics for db2pq version 0.0.4

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

db2pq

0.0.4Package record

Export Database Tables to 'Parquet'

0packages depend

1.6Kdownloads / year

46.3%test coverage

13/13flavors OK

Overview

About

Maintained by Ian D. GowCRAN page ↗GitHub ↗Website ↗Issues ↗

Tools for exporting 'PostgreSQL' tables to 'Parquet' files, with support for chunked writes, column type overrides, and timezone-aware timestamp handling. Includes functions for maintaining a local 'Parquet' data library sourced from 'WRDS' (Wharton Research Data Services), with update-checking based on table metadata, and archive management utilities for versioning local data files. See Gow and Ding (2024) "Empirical Research in Accounting: Tools and Methods" doi:10.1201/9781003456230.

Changes in 0.0.4

Added first-class WRDS credential helpers: wrds_get_username(), wrds_conninfo(), and wrds_check_credentials().
Added Parquet-first public helpers for schema/table listing and WRDS SQL exports: db_schema_tables(), wrds_get_tables(), db_schema_to_pq(), and wrds_sql_to_pq().
Added pq_data_dir() to inspect or resolve the default Parquet repository directory.
Added rename support to db_to_pq() and wrds_update_pq().
Added pkgdown site configuration and workflow-oriented vignettes.
Added ADBC diagnostics and clearer SSL-related error messages for the optional ADBC PostgreSQL path.

From NEWS.md in the release

Install

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

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

Development version from iangow/db2pqr. 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-db2pq

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

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

Health

CRAN checks

13OK

CRAN check page ↗

Slowest check: 1.4 min · r-oldrel-macos-x86_64

Status changes

OK13 OK2026-08-05
NOTE12 OK, 1 NOTE2026-08-01
OK13 OK2026-06-09
ERROR12 OK, 1 ERROR2026-06-08
OK6 OK2026-06-03

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 0.0.4

READMEYes · 297 wordsVignettes· In the repository, left out of the releaseNEWSYes · 67% structured · mentions 0.0.4Citation fileNoWebsiteYes · pkgdown

Help pages: 23 (1 internal)includes a package overview page
Examples that run: 50%11 run in a plain check · 11 never run
Exported functions with examples: 100%
Documented parameters: 95%
Return-value docs: 100%
Help pages citing references: 0%

How these are measured

Downloads

1.6K

CRAN downloads in the past year

Rank #10,586 · ~4/day · ~133/mo

Releases R versions

Daily download trend is not available in this view yet.

34730 days

96890 days

1.6K1 year

Compare downloads with other packages →

Also on19 r2u

How downloads are counted

Repository

iangow/db2pqr ↗Account: iangow

5Stars

1Forks

1Open issues

0Open PRs

0Releases

72Commits

1Commit identities

72 commits · Last activity 2026-06-02 · 0% stars, 30d

Responsiveness

How these are sampled

PRs merged (all time): not measured
Median days to close, 50 most recently updated closed issues: 50
Median days to close, 50 most recently updated closed PRs: not measured

Stars over time

2026-02-25 · 12026-07-07 · 5

How these are measured

PracticesBeta

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

Checks run against github.com/iangow/db2pqr on 2026-10-11.

Docs source (2)

pkgdown

GitHub Pages site last deployed 2026-06-02

pkgdown site last built 2026-06-02

CRAN release process (1)

cran-comments.md

Lint, format, editor (1)

RStudio project

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

Dependencies

Declared dependencies

19 external dependencies (excludes base and recommended)

Installing db2pq adds 39 packages (23 with compiled code, 26 MB of source tarballs). Heaviest: stringi 11 MB, arrow 4.2 MB, RPostgres 1.4 MB.

Depends (1)

R >= 4.1.0

Imports (7)

arrow DBI keyring RPostgres tibbletoolswrds

LinkingTo (0)

none

Suggests (13)

adbcpostgresql adbcdrivermanager adbi duckdb dplyr dbplyr ggplot2 knitr nanoarrow processx quarto rstudioapi 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 (1)

Ian D. Gow

Author, Maintainer since 0.0.4 (2026)

Releases (1)

0.0.4Latest
record
2026-06-02 · current release
R
R 4.6.0 released · 2026-04-24

Package metadata

First published: 2026-06-02
Total releases: 1 / 1 yrs
License: MIT + file LICENSE OSI
Minimum R: ≥ 4.1.0
Download size: 46 KB

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("db2pq")

Format

Gow, I. D. (2026). db2pq: Export Database Tables to 'Parquet' (Version 0.0.4) [Computer software]. https://doi.org/10.32614/CRAN.package.db2pq

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

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