Package: db2pq 0.0.4

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

Authors:Ian D. Gow [aut, cre]

db2pq_0.0.4.tar.gz
db2pq_0.0.4.zip(r-4.7)db2pq_0.0.4.zip(r-4.6)db2pq_0.0.4.zip(r-4.5)
db2pq_0.0.4.tgz(r-4.6-any)db2pq_0.0.4.tgz(r-4.5-any)
db2pq_0.0.4.tar.gz(r-4.7-any)db2pq_0.0.4.tar.gz(r-4.6-any)
db2pq_0.0.4.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
db2pq/json (API)
NEWS

# Install 'db2pq' in R:

install.packages('db2pq', repos = c('https://iangow.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/iangow/db2pqr/issues

Pkgdown/docs site:https://iangow.github.io

On CRAN:

3.95 score 3 stars 22 exports 39 dependencies

Last updated from:f2591ebabf. Checks:6 OK, 3 WARNING. Indexed: yes.

Target	Result	Time
linux-devel-x86_64	OK	168
source / vignettes	OK	207
linux-release-x86_64	OK	197
macos-release-arm64	OK	172
macos-oldrel-arm64	OK	177
windows-devel	WARNING	103
windows-release	WARNING	87
windows-oldrel	WARNING	89
wasm-release	OK	182

Exports:adbc_diagnostics con_to_adbi db_schema_tables db_schema_to_pq db_to_pq lazy_tbl_to_pq pq_archive pq_data_dir pq_last_modified pq_remove pq_restore tbl_to_pq tbl_to_pq_debug wrds_check_credentials wrds_connect_dbi wrds_conninfo wrds_credentials_available wrds_get_tables wrds_get_username wrds_schema_to_pq wrds_sql_to_pq wrds_update_pq

Dependencies:arrow askpass assertthat bit bit64 blob cli clisymbols cpp11 DBI dbplyr dplyr filelock generics glue hms keyring lifecycle lubridate magrittr pillar pkgconfig purrr R6 rlang RPostgres stringi stringr sys tibble tidylog tidyr tidyselect timechange utf8 vctrs withr wrds yaml

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
Report optional ADBC dependency status	adbc_diagnostics
Create an ADBC PostgreSQL connection from an 'RPostgres' connection	con_to_adbi
List PostgreSQL relations in a schema	db_schema_tables
Export all tables in a PostgreSQL schema to Parquet	db_schema_to_pq
Export a PostgreSQL table to Parquet	db_to_pq
Export a lazy 'dbplyr' table to Parquet	lazy_tbl_to_pq
Archive a Parquet file into the archive subdirectory	pq_archive
Resolve the Parquet data repository directory	pq_data_dir
Get last-modified metadata for Parquet data files	pq_last_modified
Remove a Parquet file from active or archive storage	pq_remove
Restore an archived Parquet file to the active schema directory	pq_restore
Export a lazy 'dbplyr' table to Parquet via ADBC	tbl_to_pq
Debug the ADBC chunk fetch path for a lazy 'dbplyr' table	tbl_to_pq_debug
Check WRDS PostgreSQL credentials	wrds_check_credentials
Connect to WRDS PostgreSQL with DBI	wrds_connect_dbi
Build WRDS PostgreSQL connection information	wrds_conninfo
Check whether WRDS credentials are available	wrds_credentials_available
List WRDS relations in a schema	wrds_get_tables
Resolve a WRDS username	wrds_get_username
Export all tables in a WRDS schema to Parquet	wrds_schema_to_pq
Export a WRDS SQL query to Parquet	wrds_sql_to_pq
Export a WRDS table to Parquet, skipping if already up to date	wrds_update_pq