{
  "_id": "6a17ee41acfb0bcc41da54a0",
  "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": "2025-11-29 20:43:31 UTC",
  "RemoteUrl": "https://github.com/dylanpieper/redquack",
  "RemoteRef": "HEAD",
  "RemoteSha": "bcfac9225a32288fa5af2fbb108bbe951b830585",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-28 07:20:12 UTC",
    "User": "root"
  },
  "Author": "Dylan Pieper [aut, cre]",
  "Maintainer": "Dylan Pieper <dylanpieper@gmail.com>",
  "MD5sum": "d56c8a52b0cc38f0d21ab5c4b4f49cfd",
  "_user": "dylanpieper",
  "_type": "src",
  "_file": "redquack_0.3.0.tar.gz",
  "_fileid": "e8d3930cfde581a44976ff147773326c1beb25d1579ab7c37ac76e8bcf5ba49f",
  "_filesize": 4169249,
  "_sha256": "e8d3930cfde581a44976ff147773326c1beb25d1579ab7c37ac76e8bcf5ba49f",
  "_created": "2026-05-28T07:20:12.000Z",
  "_published": "2026-05-28T07:26:57.782Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 78242754030,
      "time": 183,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7259987774"
    },
    {
      "job": 78242754015,
      "time": 165,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7259982177"
    },
    {
      "job": 78242754027,
      "time": 172,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7260034549"
    },
    {
      "job": 78242754045,
      "time": 135,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7260020271"
    },
    {
      "job": 78242187939,
      "time": 237,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7259933752"
    },
    {
      "job": 78242754128,
      "time": 112,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7259966935"
    },
    {
      "job": 78242753991,
      "time": 94,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7259961715"
    },
    {
      "job": 78242754031,
      "time": 100,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7259964083"
    },
    {
      "job": 78242754000,
      "time": 91,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7259960859"
    }
  ],
  "_buildurl": "https://github.com/r-universe/dylanpieper/actions/runs/26560520089",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/dylanpieper/redquack",
  "_commit": {
    "id": "bcfac9225a32288fa5af2fbb108bbe951b830585",
    "author": "Dylan Pieper <dylanpieper@gmail.com>",
    "committer": "Dylan Pieper <dylanpieper@gmail.com>",
    "message": "clarify details in readme\n- clarify RAM problem/solution\n- reference DBI\n- comment on `use_duckdb()`\n",
    "time": 1764449011
  },
  "_maintainer": {
    "name": "Dylan Pieper",
    "email": "dylanpieper@gmail.com",
    "login": "dylanpieper",
    "bluesky": "@dylanpieper.bsky.social",
    "description": "Data scientist, #rstats developer, he/him",
    "uuid": 1507130
  },
  "_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-24",
      "n": 3
    },
    {
      "week": "2025-25",
      "n": 7
    },
    {
      "week": "2025-26",
      "n": 1
    },
    {
      "week": "2025-31",
      "n": 12
    },
    {
      "week": "2025-32",
      "n": 2
    },
    {
      "week": "2025-33",
      "n": 2
    },
    {
      "week": "2025-35",
      "n": 4
    },
    {
      "week": "2025-36",
      "n": 2
    },
    {
      "week": "2025-38",
      "n": 6
    },
    {
      "week": "2025-41",
      "n": 11
    },
    {
      "week": "2025-43",
      "n": 1
    },
    {
      "week": "2025-48",
      "n": 1
    }
  ],
  "_tags": [
    {
      "name": "v0.3.0",
      "date": "2025-11-29"
    }
  ],
  "_topics": [
    "database",
    "duckdb",
    "redcap"
  ],
  "_stars": 7,
  "_contributors": [
    {
      "user": "dylanpieper",
      "count": 128,
      "uuid": 1507130
    }
  ],
  "_userbio": {
    "uuid": 1507130,
    "type": "user",
    "name": "Dylan Pieper",
    "description": "Data scientist, #rstats developer, he/him"
  },
  "_downloads": {
    "count": 175,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/redquack"
  },
  "_devurl": "https://github.com/dylanpieper/redquack",
  "_searchresults": 10,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/redquack.html",
    "manual.pdf"
  ],
  "_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",
    "rappdirs",
    "readr",
    "rlang",
    "stringi",
    "stringr",
    "sys",
    "tibble",
    "tidyr",
    "tidyselect",
    "tzdb",
    "utf8",
    "vctrs",
    "vroom",
    "withr"
  ],
  "_score": 4.623249290397901,
  "_indexed": true,
  "_nocasepkg": "redquack",
  "_universes": [
    "dylanpieper"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.3.0",
      "date": "2026-05-28T07:23:12.000Z",
      "distro": "noble",
      "commit": "bcfac9225a32288fa5af2fbb108bbe951b830585",
      "fileid": "0482a1e907df960ec790f5479b059d751bdfcfe15aa47a09ad3758c06b202593",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dylanpieper/actions/runs/26560520089"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.3.0",
      "date": "2026-05-28T07:22:53.000Z",
      "distro": "noble",
      "commit": "bcfac9225a32288fa5af2fbb108bbe951b830585",
      "fileid": "0e5d6d0d879252b0d8ad8c4f78166ae986f4f581464c104d355d33b7d241fab7",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dylanpieper/actions/runs/26560520089"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.3.0",
      "date": "2026-05-28T07:25:48.000Z",
      "commit": "bcfac9225a32288fa5af2fbb108bbe951b830585",
      "fileid": "66ded7c90e7a164e0b3458cadcb2eaa354041eab17e0847490d04dc709be45fb",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dylanpieper/actions/runs/26560520089"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.3.0",
      "date": "2026-05-28T07:25:05.000Z",
      "commit": "bcfac9225a32288fa5af2fbb108bbe951b830585",
      "fileid": "18ae9787a96eb9332fccda38dca2aadb60b00c8c7903bbef2757b70ced508bfe",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dylanpieper/actions/runs/26560520089"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.3.0",
      "date": "2026-05-28T07:22:27.000Z",
      "commit": "bcfac9225a32288fa5af2fbb108bbe951b830585",
      "fileid": "e4e4fd8c55db7d803b1b7bcb9e29b7c280a9de3e3b53f0a71803e76bbcd876a5",
      "status": "success",
      "buildurl": "https://github.com/r-universe/dylanpieper/actions/runs/26560520089"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.3.0",
      "date": "2026-05-28T07:21:39.000Z",
      "commit": "bcfac9225a32288fa5af2fbb108bbe951b830585",
      "fileid": "0eb371912abd8182a064f7014f1820fe65291855bda1dc3f1a6220ab7373da57",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dylanpieper/actions/runs/26560520089"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.3.0",
      "date": "2026-05-28T07:21:48.000Z",
      "commit": "bcfac9225a32288fa5af2fbb108bbe951b830585",
      "fileid": "52a5d1825b4c5a21a214341473f289187556f5365ad96f00716e664f8c926dc7",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dylanpieper/actions/runs/26560520089"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.3.0",
      "date": "2026-05-28T07:21:35.000Z",
      "commit": "bcfac9225a32288fa5af2fbb108bbe951b830585",
      "fileid": "adea1aa3fa6bf5ee87d7ab7583ae5380a22a246d89bb9e0e39b2460f5e39c395",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/dylanpieper/actions/runs/26560520089"
    }
  ]
}