{ "_id": "6abe207799f7aa8c6aa527d4", "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-10-01 08:53:06 UTC", "User": "root" }, "_user": "iangow", "_type": "src", "_file": "db2pq_0.0.4.tar.gz", "_fileid": "https://r2.ropensci.org/780706d37579d7f24c128109ed956a5377d17c40174632345c29a4fa70a07079", "_filesize": 195586, "_sha256": "780706d37579d7f24c128109ed956a5377d17c40174632345c29a4fa70a07079", "_expires": "2027-01-09T08:57:25.000Z", "_created": "2026-10-01T08:53:06.000Z", "_published": "2026-10-01T08:57:27.337Z", "_jobs": [ { "job": 110293833860, "time": 165, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11150501466" }, { "job": 110293833917, "time": 196, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11150229852" }, { "job": 110293833885, "time": 142, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "11150343634" }, { "job": 110293833945, "time": 87, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "11150931244" }, { "job": 110292298523, "time": 261, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11150089595" }, { "job": 110293833886, "time": 177, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11150636181" }, { "job": 110293833976, "time": 83, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "WARNING", "artifact": "11150506823" }, { "job": 110293833954, "time": 97, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "WARNING", "artifact": "11151015228" }, { "job": 110293834110, "time": 70, "config": "windows-release-x86_64", "r": "4.6.1", "check": "WARNING", "artifact": "11150570940" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/iangow/actions/runs/36838664678", "_status": "success", "_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 }, "_distro": "resolute", "_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": 5, "_contributors": [ { "user": "iangow", "count": 72, "uuid": 1708790 } ], "_userbio": { "uuid": 1708790, "type": "user", "name": "Ian Gow", "followers": 126 }, "_downloads": { "count": 415, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/db2pq" }, "_devurl": "https://github.com/iangow/db2pqr", "_pkgdown": "https://iangow.github.io/db2pqr/", "_searchresults": 18, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/db2pq.html", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "LICENSE" ], "_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": 4.431363764158987, "_indexed": true, "_nocasepkg": "db2pq", "_universes": [ "iangow" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.0.4", "date": "2026-10-01T08:55:54.000Z", "distro": "resolute", "commit": "f2591ebabf031e17c8a90c27197c3c97263b2191", "fileid": "https://r2.ropensci.org/1b32a6c9c6dd25f8129f6405697d96459b6dddc43e43b0bd581e60b219ad14cb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/iangow/actions/runs/36838664678" }, { "r": "4.6.1", "os": "linux", "version": "0.0.4", "date": "2026-10-01T08:56:24.000Z", "distro": "resolute", "commit": "f2591ebabf031e17c8a90c27197c3c97263b2191", "fileid": "https://r2.ropensci.org/483f5d839c6fd8fa028a65f16428245e17ef6805cbc7c73c82ef7d00e4257f4a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/iangow/actions/runs/36838664678" }, { "r": "4.5.3", "os": "mac", "version": "0.0.4", "date": "2026-10-01T08:55:50.000Z", "commit": "f2591ebabf031e17c8a90c27197c3c97263b2191", "fileid": "https://r2.ropensci.org/0d963a15d1ee1362aa5f3cbeb3de706733edec08f58cb05e13535099a521816f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/iangow/actions/runs/36838664678" }, { "r": "4.6.1", "os": "mac", "version": "0.0.4", "date": "2026-10-01T08:56:23.000Z", "commit": "f2591ebabf031e17c8a90c27197c3c97263b2191", "fileid": "https://r2.ropensci.org/8cb3238ad30b929d8b7bbe7eae466b3d1d28ccf45d73608dcc86c9f2861c9900", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/iangow/actions/runs/36838664678" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.4", "date": "2026-10-01T08:57:00.000Z", "commit": "f2591ebabf031e17c8a90c27197c3c97263b2191", "fileid": "https://r2.ropensci.org/114e22b3ce3309b5275d731b2d395f28b9647cf5a3006871285cca26fdb3f67f", "status": "success", "buildurl": "https://github.com/r-universe/iangow/actions/runs/36838664678" }, { "r": "4.7.0", "os": "win", "version": "0.0.4", "date": "2026-10-01T08:54:27.000Z", "commit": "f2591ebabf031e17c8a90c27197c3c97263b2191", "fileid": "https://r2.ropensci.org/90c8caf2d3f27199364a5ef0153397510b1c61a09f4b6e03a0870d0953204e09", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/iangow/actions/runs/36838664678" }, { "r": "4.5.3", "os": "win", "version": "0.0.4", "date": "2026-10-01T08:54:46.000Z", "commit": "f2591ebabf031e17c8a90c27197c3c97263b2191", "fileid": "https://r2.ropensci.org/d296c2746369c4835eb36f0da07f7e2340d54a3fc95a687b284a0125f678421e", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/iangow/actions/runs/36838664678" }, { "r": "4.6.1", "os": "win", "version": "0.0.4", "date": "2026-10-01T08:54:15.000Z", "commit": "f2591ebabf031e17c8a90c27197c3c97263b2191", "fileid": "https://r2.ropensci.org/6d3807455d5de14ea73b15614cb634a4868360d031c629ccd9511d2fdb5ba0af", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/iangow/actions/runs/36838664678" } ] }