{
  "_id": "6accb082a14063b82c3a7f4b",
  "Package": "redquack",
  "Title": "Transfer 'REDCap' Data to Database",
  "Version": "0.3.0",
  "Authors@R": "person(\"Dylan\", \"Pieper\", , \"dylanpieper@gmail.com\", role = c(\"aut\", \"cre\"))",
  "Description": "Transfer 'REDCap' (Research Electronic Data Capture) data\nto a database, specifically optimized for 'DuckDB'. Processes\ndata in chunks to handle large datasets without exceeding\navailable memory. Features include data labeling, coded value\nconversion, and hearing a \"quack\" sound on success.",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.3.2",
  "Config/testthat/edition": "3",
  "Config/pak/sysreqs": "make libicu-dev libssl-dev libx11-dev xz-utils\nzlib1g-dev",
  "Repository": "https://dylanpieper.r-universe.dev",
  "Date/Publication": "2026-07-14 19:13:27 UTC",
  "RemoteUrl": "https://github.com/dylanpieper/redquack",
  "RemoteRef": "HEAD",
  "RemoteSha": "04c40cd75cc26cbf4a5cced2ab531b56f07a3450",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-12 10:00:16 UTC",
    "User": "root"
  },
  "Author": "Dylan Pieper [aut, cre]",
  "Maintainer": "Dylan Pieper <dylanpieper@gmail.com>",
  "_user": "dylanpieper",
  "_type": "src",
  "_file": "redquack_0.3.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/3068c650fe0a2f7992a1839f75404c9f9b889d768e04219c806347107d6f0ff8",
  "_filesize": 4168363,
  "_sha256": "3068c650fe0a2f7992a1839f75404c9f9b889d768e04219c806347107d6f0ff8",
  "_expires": "2027-01-20T10:03:44.000Z",
  "_created": "2026-10-12T10:00:16.000Z",
  "_published": "2026-10-12T10:03:46.809Z",
  "_buildurl": "https://github.com/r-universe/dylanpieper/actions/runs/38233225192",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 114758637101,
      "time": 169,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11739373205"
    },
    {
      "job": 114758637257,
      "time": 138,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11740105924"
    },
    {
      "job": 114758637104,
      "time": 160,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11739811337"
    },
    {
      "job": 114758637258,
      "time": 146,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11739781374"
    },
    {
      "job": 114757600300,
      "time": 170,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11739681221"
    },
    {
      "job": 114758637083,
      "time": 105,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11740275601"
    },
    {
      "job": 114758637182,
      "time": 97,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11740360424"
    },
    {
      "job": 114758637197,
      "time": 97,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11739273019"
    },
    {
      "job": 114758637337,
      "time": 102,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11739109886"
    }
  ],
  "_upstream": "https://github.com/dylanpieper/redquack",
  "_commit": {
    "id": "04c40cd75cc26cbf4a5cced2ab531b56f07a3450",
    "author": "Dylan Pieper <dylanpieper@gmail.com>",
    "committer": "Dylan Pieper <dylanpieper@gmail.com>",
    "message": "remove confusing phrase from readme\n",
    "time": 1784056407
  },
  "_maintainer": {
    "name": "Dylan Pieper",
    "email": "dylanpieper@gmail.com",
    "login": "dylanpieper",
    "bluesky": "@dylanpieper.bsky.social",
    "description": "",
    "uuid": 1507130
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "audio",
      "role": "Imports"
    },
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "dbplyr",
      "role": "Imports"
    },
    {
      "package": "duckdb",
      "role": "Imports"
    },
    {
      "package": "httr2",
      "role": "Imports"
    },
    {
      "package": "labelled",
      "role": "Imports"
    },
    {
      "package": "readr",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "arrow",
      "role": "Suggests"
    },
    {
      "package": "keyring",
      "role": "Suggests"
    },
    {
      "package": "pak",
      "role": "Suggests"
    },
    {
      "package": "RSQLite",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    }
  ],
  "_owner": "dylanpieper",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2025-41",
      "n": 11
    },
    {
      "week": "2025-43",
      "n": 1
    },
    {
      "week": "2025-48",
      "n": 1
    },
    {
      "week": "2026-29",
      "n": 1
    }
  ],
  "_tags": [
    {
      "name": "v0.3.0",
      "date": "2025-11-29"
    }
  ],
  "_topics": [
    "database",
    "duckdb",
    "redcap"
  ],
  "_stars": 7,
  "_contributors": [
    {
      "user": "dylanpieper",
      "count": 129,
      "uuid": 1507130
    }
  ],
  "_userbio": {
    "uuid": 1507130,
    "type": "user",
    "name": "Dylan Pieper",
    "followers": 16
  },
  "_downloads": {
    "count": 302,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/redquack"
  },
  "_devurl": "https://github.com/dylanpieper/redquack",
  "_searchresults": 9,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/redquack.html",
    "LICENSE"
  ],
  "_homeurl": "https://github.com/dylanpieper/redquack",
  "_realowner": "dylanpieper",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.1",
      "date": "2025-03-24"
    },
    {
      "version": "0.2.0",
      "date": "2025-05-14"
    },
    {
      "version": "0.3.0",
      "date": "2025-10-09"
    }
  ],
  "_exports": [
    "close_duckdb",
    "collect_labeled",
    "collect_labeled_list",
    "collect_list",
    "inspect",
    "list_to_env",
    "metadata",
    "redcap_log",
    "redcap_to_db",
    "remove_duckdb",
    "save_parquet",
    "tbl_redcap",
    "transfer_log",
    "use_duckdb"
  ],
  "_help": [
    {
      "page": "close_duckdb",
      "title": "Close DuckDB Connection",
      "topics": [
        "close_duckdb"
      ]
    },
    {
      "page": "collect_labeled",
      "title": "Collect Labeled Data from Database Table",
      "topics": [
        "collect_labeled"
      ]
    },
    {
      "page": "collect_list",
      "title": "Collect a Database Table into to List of REDCap Instruments",
      "topics": [
        "collect_labeled_list",
        "collect_list"
      ]
    },
    {
      "page": "inspect",
      "title": "Inspect Project Data Table Structure",
      "topics": [
        "inspect"
      ]
    },
    {
      "page": "list_to_env",
      "title": "Assign List to Global Environment",
      "topics": [
        "list_to_env"
      ]
    },
    {
      "page": "metadata",
      "title": "Get Metadata Table",
      "topics": [
        "metadata"
      ]
    },
    {
      "page": "redcap_log",
      "title": "Get REDCap Logs Table",
      "topics": [
        "redcap_log"
      ]
    },
    {
      "page": "redcap_to_db",
      "title": "Transfer 'REDCap' Data to a Database",
      "topics": [
        "redcap_to_db"
      ]
    },
    {
      "page": "remove_duckdb",
      "title": "Remove DuckDB Database",
      "topics": [
        "remove_duckdb"
      ]
    },
    {
      "page": "save_parquet",
      "title": "Save Data to Parquet",
      "topics": [
        "save_parquet"
      ]
    },
    {
      "page": "tbl_redcap",
      "title": "Create REDCap Data Table Reference",
      "topics": [
        "tbl_redcap"
      ]
    },
    {
      "page": "transfer_log",
      "title": "Get Transfer Logs Table",
      "topics": [
        "transfer_log"
      ]
    },
    {
      "page": "use_duckdb",
      "title": "Create DuckDB Connection",
      "topics": [
        "use_duckdb"
      ]
    }
  ],
  "_readme": "https://github.com/dylanpieper/redquack/raw/HEAD/README.md",
  "_rundeps": [
    "askpass",
    "audio",
    "bit",
    "bit64",
    "blob",
    "cli",
    "clipr",
    "cpp11",
    "crayon",
    "curl",
    "DBI",
    "dbplyr",
    "dplyr",
    "duckdb",
    "forcats",
    "generics",
    "glue",
    "haven",
    "hms",
    "httr2",
    "labelled",
    "lifecycle",
    "magrittr",
    "openssl",
    "pillar",
    "pkgconfig",
    "prettyunits",
    "progress",
    "purrr",
    "R6",
    "readr",
    "rlang",
    "stringi",
    "stringr",
    "sys",
    "tibble",
    "tidyr",
    "tidyselect",
    "tzdb",
    "utf8",
    "vctrs",
    "vroom",
    "withr"
  ],
  "_score": 4.146128035678238,
  "_indexed": true,
  "_nocasepkg": "redquack",
  "_universes": [
    "dylanpieper"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.3.0",
      "date": "2026-10-12T10:02:58.000Z",
      "distro": "resolute",
      "commit": "04c40cd75cc26cbf4a5cced2ab531b56f07a3450",
      "fileid": "https://r2.ropensci.org/0e9bd2330f5c633b236ce6c8f1dd9c731dbcbe5efc5aaf4739d65ede7fe9e22d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dylanpieper/actions/runs/38233225192"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.3.0",
      "date": "2026-10-12T10:02:25.000Z",
      "distro": "resolute",
      "commit": "04c40cd75cc26cbf4a5cced2ab531b56f07a3450",
      "fileid": "https://r2.ropensci.org/8268a3033dd1b614b94a00ca4b724451e13af48ec3a1bc89b7fb70078740559d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dylanpieper/actions/runs/38233225192"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.3.0",
      "date": "2026-10-12T10:02:40.000Z",
      "commit": "04c40cd75cc26cbf4a5cced2ab531b56f07a3450",
      "fileid": "https://r2.ropensci.org/1ea3ece2735622a5f393c30fe7f605e67f52e0139257d0a743e7b3fef9ac6a52",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dylanpieper/actions/runs/38233225192"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.3.0",
      "date": "2026-10-12T10:02:21.000Z",
      "commit": "04c40cd75cc26cbf4a5cced2ab531b56f07a3450",
      "fileid": "https://r2.ropensci.org/542c3420db78eb5f81132bea6372aed3cb051ae9a65e862a68070a49220343e3",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dylanpieper/actions/runs/38233225192"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.3.0",
      "date": "2026-10-12T10:02:17.000Z",
      "commit": "04c40cd75cc26cbf4a5cced2ab531b56f07a3450",
      "fileid": "https://r2.ropensci.org/25c9281baed39774190c2357c4290649a0c37c21054811b0214e3c9916724cd9",
      "status": "success",
      "buildurl": "https://github.com/r-universe/dylanpieper/actions/runs/38233225192"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.3.0",
      "date": "2026-10-12T10:01:39.000Z",
      "commit": "04c40cd75cc26cbf4a5cced2ab531b56f07a3450",
      "fileid": "https://r2.ropensci.org/d62f02bb1dd2e7c08d2ae7f9498b4bd2d2362c738d517d3e15e2476852074008",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dylanpieper/actions/runs/38233225192"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.3.0",
      "date": "2026-10-12T10:01:35.000Z",
      "commit": "04c40cd75cc26cbf4a5cced2ab531b56f07a3450",
      "fileid": "https://r2.ropensci.org/bd5932b1af3a212c72cd3ef22146dc7f85946a3fabaeeec5be8eea02e194a28c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dylanpieper/actions/runs/38233225192"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.3.0",
      "date": "2026-10-12T10:01:38.000Z",
      "commit": "04c40cd75cc26cbf4a5cced2ab531b56f07a3450",
      "fileid": "https://r2.ropensci.org/bb47eeb1900b8f00197b62c480397dbf618e2ac16169538973f13076d7e009e4",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dylanpieper/actions/runs/38233225192"
    }
  ]
}