db2pq

0.0.4

Export Database Tables to 'Parquet'

0packages depend

725downloads / year

46.3%test coverage

13/13checks pass

Overview

About

Maintained by Ian D. GowFirst published 2026-06-021 releasesCRAN page ↗GitHub ↗

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.

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.

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

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

Code health

Yes

Tests · ratio 0.52

46.3%

Coverage · measured lines

100%

Documentation · exports

Dependencies · direct

Check history

OK2026-06-09
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-06-08
12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
OK2026-06-03
6 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

READMEYes · 297 wordsVignettesNopkgdown siteNoNEWSYes · 67% structuredCode of conductNoContributing guideNo

Examples that run: 50%
Documented parameters: 95%
Return-value docs: 100%
References docs: 0%

Downloads

725

CRAN downloads in the past year

Rank #14,671 · ~2/day · ~60/mo

Releases R versions

Daily download trend is not available in this view yet.

28630 days

72590 days

7251 year

Compare downloads with other packages →

Also on1 r2u

Repository

GitHub ↗ iangow/db2pqr

5Stars

1Forks

1Open issues

0Open PRs

0Releases

72Commits

1Contributors

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

Stars over time

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

Repository practices

Upstream repositoryBeta

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

Checks run against github.com/iangow/db2pqr on 2026-07-30.

CRAN release process (1)

cran-comments.md

Lint, format, editor (1)

RStudio project

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

Dependencies

Declared dependencies

19 external dependencies (excludes base and recommended)

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.

Code & Tests

People & History

People (1)

Maintainer (1)

Ian D. Gow

Author, Maintainer

Authors (1)

Ian D. Gow

Author, Maintainer

Package Timeline

1 release. R releases are shown for context.

0.0.4Latest
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: not tracked yet
Installed size: not tracked yet
With dependencies: not tracked yet

Report a problem with this page →