{ "_id": "6a2035efcd65a98ecbd11365", "Package": "db2pq", "Type": "Package", "Title": "Export Database Tables to 'Parquet'", "Version": "0.0.4", "Description": "Tools for exporting 'PostgreSQL' tables to 'Parquet'\nfiles, with support for chunked writes, column type overrides,\nand timezone-aware timestamp handling. Includes functions for\nmaintaining a local 'Parquet' data library sourced from 'WRDS'\n(Wharton Research Data Services), with update-checking based on\ntable metadata, and archive management utilities for versioning\nlocal data files. See Gow and Ding (2024) \"Empirical Research\nin Accounting: Tools and Methods\" .", "URL": "https://github.com/iangow/db2pqr, https://iangow.github.io/db2pqr/", "BugReports": "https://github.com/iangow/db2pqr/issues", "Authors@R": "c(\nperson(\n\"Ian D.\", \"Gow\",\nemail = \"iandgow@gmail.com\",\nrole = c(\"aut\", \"cre\")\n)\n)", "Author": "Ian D. Gow [aut, cre]", "Maintainer": "Ian D. Gow ", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "Config/testthat/edition": "3", "Config/Needs/website": "pkgdown, quarto", "Config/roxygen2/version": "8.0.0", "Config/pak/sysreqs": "cmake libicu-dev libsecret-1-dev libssl-dev\nlibpq-dev", "Repository": "https://iangow.r-universe.dev", "Date/Publication": "2026-06-02 21:29:41 UTC", "RemoteUrl": "https://github.com/iangow/db2pqr", "RemoteRef": "HEAD", "RemoteSha": "f2591ebabf031e17c8a90c27197c3c97263b2191", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-03 14:06:48 UTC", "User": "root" }, "MD5sum": "1e9bf359d75c3c3e3af1742693aa79b2", "_user": "iangow", "_type": "src", "_file": "db2pq_0.0.4.tar.gz", "_fileid": "43dd9cb1ad92bcf6648e6494ee2fa3e23b92d08e7ed161c63417881fd23ef980", "_filesize": 192543, "_sha256": "43dd9cb1ad92bcf6648e6494ee2fa3e23b92d08e7ed161c63417881fd23ef980", "_created": "2026-06-03T14:06:48.000Z", "_published": "2026-06-03T14:10:55.635Z", "_distro": "noble", "_jobs": [ { "job": 79313683768, "time": 168, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7387001518" }, { "job": 79313684191, "time": 197, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7387014091" }, { "job": 79313683889, "time": 177, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7386991725" }, { "job": 79313683793, "time": 172, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7386991872" }, { "job": 79312919876, "time": 207, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7386927862" }, { "job": 79313683810, "time": 182, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7387007799" }, { "job": 79313683687, "time": 103, "config": "windows-devel", "r": "4.7.0", "check": "WARNING", "artifact": "7386973286" }, { "job": 79313683862, "time": 89, "config": "windows-oldrel", "r": "4.5.3", "check": "WARNING", "artifact": "7386967734" }, { "job": 79313684083, "time": 87, "config": "windows-release", "r": "4.6.0", "check": "WARNING", "artifact": "7386966739" } ], "_buildurl": "https://github.com/r-universe/iangow/actions/runs/26889970997", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/iangow/db2pqr", "_commit": { "id": "f2591ebabf031e17c8a90c27197c3c97263b2191", "author": "Ian Gow ", "committer": "Ian Gow ", "message": "Minor updates to page.\n", "time": 1780435781 }, "_maintainer": { "name": "Ian D. Gow", "email": "iandgow@gmail.com", "login": "iangow", "linkedin": "in/iangow", "twitter": "@iandgow", "description": "", "uuid": 1708790 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "arrow", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "keyring", "role": "Imports" }, { "package": "RPostgres", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "tools", "role": "Imports" }, { "package": "wrds", "role": "Imports" }, { "package": "adbcpostgresql", "role": "Suggests" }, { "package": "adbcdrivermanager", "role": "Suggests" }, { "package": "adbi", "role": "Suggests" }, { "package": "duckdb", "role": "Suggests" }, { "package": "dplyr", "role": "Suggests" }, { "package": "dbplyr", "role": "Suggests" }, { "package": "ggplot2", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "nanoarrow", "role": "Suggests" }, { "package": "processx", "role": "Suggests" }, { "package": "quarto", "role": "Suggests" }, { "package": "rstudioapi", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" } ], "_owner": "iangow", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-09", "n": 32 }, { "week": "2026-12", "n": 2 }, { "week": "2026-13", "n": 5 }, { "week": "2026-21", "n": 19 }, { "week": "2026-22", "n": 10 }, { "week": "2026-23", "n": 4 } ], "_tags": [ { "name": "v0.0.2", "date": "2026-02-26" }, { "name": "v0.0.3", "date": "2026-03-21" }, { "name": "v0.0.4", "date": "2026-05-29" } ], "_stars": 3, "_contributors": [ { "user": "iangow", "count": 72, "uuid": 1708790 } ], "_userbio": { "uuid": 1708790, "type": "user", "name": "Ian Gow" }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/db2pq" }, "_devurl": "https://github.com/iangow/db2pqr", "_pkgdown": "https://iangow.github.io/db2pqr/", "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/db2pq.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/iangow/db2pqr", "_realowner": "iangow", "_cranurl": true, "_releases": [ { "version": "0.0.4", "date": "2026-06-02" } ], "_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" ], "_help": [ { "page": "adbc_diagnostics", "title": "Report optional ADBC dependency status", "topics": [ "adbc_diagnostics" ] }, { "page": "con_to_adbi", "title": "Create an ADBC PostgreSQL connection from an 'RPostgres' connection", "topics": [ "con_to_adbi" ] }, { "page": "db_schema_tables", "title": "List PostgreSQL relations in a schema", "topics": [ "db_schema_tables" ] }, { "page": "db_schema_to_pq", "title": "Export all tables in a PostgreSQL schema to Parquet", "topics": [ "db_schema_to_pq" ] }, { "page": "db_to_pq", "title": "Export a PostgreSQL table to Parquet", "topics": [ "db_to_pq" ] }, { "page": "lazy_tbl_to_pq", "title": "Export a lazy 'dbplyr' table to Parquet", "topics": [ "lazy_tbl_to_pq" ] }, { "page": "pq_archive", "title": "Archive a Parquet file into the archive subdirectory", "topics": [ "pq_archive" ] }, { "page": "pq_data_dir", "title": "Resolve the Parquet data repository directory", "topics": [ "pq_data_dir" ] }, { "page": "pq_last_modified", "title": "Get last-modified metadata for Parquet data files", "topics": [ "pq_last_modified" ] }, { "page": "pq_remove", "title": "Remove a Parquet file from active or archive storage", "topics": [ "pq_remove" ] }, { "page": "pq_restore", "title": "Restore an archived Parquet file to the active schema directory", "topics": [ "pq_restore" ] }, { "page": "tbl_to_pq", "title": "Export a lazy 'dbplyr' table to Parquet via ADBC", "topics": [ "tbl_to_pq" ] }, { "page": "tbl_to_pq_debug", "title": "Debug the ADBC chunk fetch path for a lazy 'dbplyr' table", "topics": [ "tbl_to_pq_debug" ] }, { "page": "wrds_check_credentials", "title": "Check WRDS PostgreSQL credentials", "topics": [ "wrds_check_credentials" ] }, { "page": "wrds_connect_dbi", "title": "Connect to WRDS PostgreSQL with DBI", "topics": [ "wrds_connect_dbi" ] }, { "page": "wrds_conninfo", "title": "Build WRDS PostgreSQL connection information", "topics": [ "wrds_conninfo" ] }, { "page": "wrds_credentials_available", "title": "Check whether WRDS credentials are available", "topics": [ "wrds_credentials_available" ] }, { "page": "wrds_get_tables", "title": "List WRDS relations in a schema", "topics": [ "wrds_get_tables" ] }, { "page": "wrds_get_username", "title": "Resolve a WRDS username", "topics": [ "wrds_get_username" ] }, { "page": "wrds_schema_to_pq", "title": "Export all tables in a WRDS schema to Parquet", "topics": [ "wrds_schema_to_pq" ] }, { "page": "wrds_sql_to_pq", "title": "Export a WRDS SQL query to Parquet", "topics": [ "wrds_sql_to_pq" ] }, { "page": "wrds_update_pq", "title": "Export a WRDS table to Parquet, skipping if already up to date", "topics": [ "wrds_update_pq" ] } ], "_readme": "https://github.com/iangow/db2pqr/raw/HEAD/README.md", "_rundeps": [ "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" ], "_score": 3.9542425094393248, "_indexed": true, "_nocasepkg": "db2pq", "_universes": [ "iangow" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.0.4", "date": "2026-06-03T14:09:39.000Z", "distro": "noble", "commit": "f2591ebabf031e17c8a90c27197c3c97263b2191", "fileid": "13fc90eed7dadd7bb496df0f22a98fb2eafbbaa0716b9d85918c1f33b3be9fca", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/iangow/actions/runs/26889970997" }, { "r": "4.6.0", "os": "linux", "version": "0.0.4", "date": "2026-06-03T14:10:08.000Z", "distro": "noble", "commit": "f2591ebabf031e17c8a90c27197c3c97263b2191", "fileid": "f1ef3798d2aca4fca65afcd83114d03b2eafc220b79bdfb371830fdde7dedc3f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/iangow/actions/runs/26889970997" }, { "r": "4.5.3", "os": "mac", "version": "0.0.4", "date": "2026-06-03T14:09:21.000Z", "commit": "f2591ebabf031e17c8a90c27197c3c97263b2191", "fileid": "d28972657deddf99b88f0bafbeba353fde5d2987e45c2da290f97aad19f97f6a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/iangow/actions/runs/26889970997" }, { "r": "4.6.0", "os": "mac", "version": "0.0.4", "date": "2026-06-03T14:09:20.000Z", "commit": "f2591ebabf031e17c8a90c27197c3c97263b2191", "fileid": "012d4d82690b88184bf84326c9a63acfef9435f0e3968cd41579b24cb4a2467e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/iangow/actions/runs/26889970997" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.4", "date": "2026-06-03T14:10:11.000Z", "commit": "f2591ebabf031e17c8a90c27197c3c97263b2191", "fileid": "49a15419de1b8b29c25acb5f47515b4f26d78d74c52e68f5b4c9740dfcbdf039", "status": "success", "buildurl": "https://github.com/r-universe/iangow/actions/runs/26889970997" }, { "r": "4.7.0", "os": "win", "version": "0.0.4", "date": "2026-06-03T14:08:26.000Z", "commit": "f2591ebabf031e17c8a90c27197c3c97263b2191", "fileid": "e668e2c933f01ca0908beb385925720b1ef8a00b39eb911f800cd302b2646f0e", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/iangow/actions/runs/26889970997" }, { "r": "4.5.3", "os": "win", "version": "0.0.4", "date": "2026-06-03T14:08:14.000Z", "commit": "f2591ebabf031e17c8a90c27197c3c97263b2191", "fileid": "641dc1b8e3f8e6b02d3f57501e887552cecace2b120d2b855d89dc94a40e2a4d", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/iangow/actions/runs/26889970997" }, { "r": "4.6.0", "os": "win", "version": "0.0.4", "date": "2026-06-03T14:08:11.000Z", "commit": "f2591ebabf031e17c8a90c27197c3c97263b2191", "fileid": "421a8d92e15b8a16e9de90708dd449970ef416d87f53bf8a88f19d89ae3e51bd", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/iangow/actions/runs/26889970997" } ] }