The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.

db2pq: Export Database Tables to 'Parquet'

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

Version: 0.0.4
Depends: R (≥ 4.1.0)
Imports: arrow, DBI, keyring, RPostgres, tibble, tools, wrds
Suggests: adbcpostgresql, adbcdrivermanager, adbi, duckdb, dplyr, dbplyr, ggplot2, knitr, nanoarrow, processx, quarto, rstudioapi, testthat (≥ 3.0.0)
Published: 2026-06-02
DOI: 10.32614/CRAN.package.db2pq
Author: Ian D. Gow [aut, cre]
Maintainer: Ian D. Gow <iandgow at gmail.com>
BugReports: https://github.com/iangow/db2pqr/issues
License: MIT + file LICENSE
URL: https://github.com/iangow/db2pqr, https://iangow.github.io/db2pqr/
NeedsCompilation: no
Materials: README, NEWS
CRAN checks: db2pq results

Documentation:

Reference manual: db2pq.html , db2pq.pdf

Downloads:

Package source: db2pq_0.0.4.tar.gz
Windows binaries: r-devel: not available, r-release: db2pq_0.0.4.zip, r-oldrel: db2pq_0.0.4.zip
macOS binaries: r-release (arm64): db2pq_0.0.4.tgz, r-oldrel (arm64): db2pq_0.0.4.tgz, r-release (x86_64): db2pq_0.0.4.tgz, r-oldrel (x86_64): db2pq_0.0.4.tgz

Linking:

Please use the canonical form https://CRAN.R-project.org/package=db2pq to link to this page.

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.