{
  "_id": "6addb1359c8ebd685a2a6ded",
  "Package": "duckdb",
  "Title": "DBI Package for the DuckDB Database Management System",
  "Version": "2.0.0.9000",
  "Authors@R": "c(\nperson(\"Hannes\", \"Mühleisen\", , \"hannes@cwi.nl\", role = \"aut\",\ncomment = c(ORCID = \"0000-0001-8552-0029\")),\nperson(\"Mark\", \"Raasveldt\", , \"mark.raasveldt@cwi.nl\", role = \"aut\",\ncomment = c(ORCID = \"0000-0001-5005-6844\")),\nperson(\"Kirill\", \"Müller\", , \"kirill@cynkra.com\", role = \"cre\",\ncomment = c(ORCID = \"0000-0002-1416-3412\")),\nperson(\"Stichting DuckDB Foundation\", role = \"cph\"),\nperson(\"Apache Software Foundation\", role = \"cph\"),\nperson(\"PostgreSQL Global Development Group\", role = \"cph\"),\nperson(\"The Regents of the University of California\", role = \"cph\"),\nperson(\"Cameron Desrochers\", role = \"cph\"),\nperson(\"Victor Zverovich\", role = \"cph\"),\nperson(\"RAD Game Tools\", role = \"cph\"),\nperson(\"Valve Software\", role = \"cph\"),\nperson(\"Rich Geldreich\", role = \"cph\"),\nperson(\"Tenacious Software LLC\", role = \"cph\"),\nperson(\"The RE2 Authors\", role = \"cph\"),\nperson(\"Google Inc.\", role = \"cph\"),\nperson(\"Facebook Inc.\", role = \"cph\"),\nperson(\"Steven G. Johnson\", role = \"cph\"),\nperson(\"Jiahao Chen\", role = \"cph\"),\nperson(\"Tony Kelman\", role = \"cph\"),\nperson(\"Jonas Fonseca\", role = \"cph\"),\nperson(\"Lukas Fittl\", role = \"cph\"),\nperson(\"Salvatore Sanfilippo\", role = \"cph\"),\nperson(\"Art.sy, Inc.\", role = \"cph\"),\nperson(\"Oran Agra\", role = \"cph\"),\nperson(\"Redis Labs, Inc.\", role = \"cph\"),\nperson(\"Melissa O'Neill\", role = \"cph\"),\nperson(\"PCG Project contributors\", role = \"cph\")\n)",
  "Description": "The DuckDB project is an embedded analytical data\nmanagement system with support for the Structured Query\nLanguage (SQL). This package includes all of DuckDB and an R\nDatabase Interface (DBI) connector.",
  "License": "MIT + file LICENSE",
  "URL": "https://r.duckdb.org/, https://github.com/duckdb/duckdb-r",
  "BugReports": "https://github.com/duckdb/duckdb-r/issues",
  "Biarch": "true",
  "Config/build/compilation-database": "false",
  "Config/build/never-clean": "true",
  "Config/comment/compilation-database": "Generate manually with\npkgload:::generate_db() for faster pkgload::load_all()",
  "Config/gha/extra-packages": "adbcdrivermanager=?ignore-unavailable&ignore-build-errors,\narrow=?ignore-build-errors",
  "Config/comment/gha/extra-packages": "arrow does not compile against\nRtools45, and the aarch64 Windows runner has no binary to\ninstall instead. adbcdrivermanager needs ignore-unavailable as\nwell, and needs it on every runner: CRAN archived it, and pak\nis called with dependencies = \"all\", which resolves Enhances\ntoo, so the package is in the plan and resolves to nothing.\nignore-build-errors does not cover that -- it demotes a failed\nbuild, not a failed lookup. ignore-build-errors stays for the\nday it returns to CRAN and Rtools45 has to build it again.\nExplained in handbook/operations/ci/matrix/README.md.",
  "Config/testthat/edition": "3",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "Config/roxygen2/version": "8.1.1.9000",
  "Repository": "https://duckdb.r-universe.dev",
  "Date/Publication": "2026-10-23 08:09:55 UTC",
  "RemoteUrl": "https://github.com/duckdb/duckdb-r",
  "RemoteRef": "HEAD",
  "RemoteSha": "ca768a989ad5554f5b643dd26e84dce8578660ba",
  "NeedsCompilation": "yes",
  "Packaged": {
    "Date": "2026-10-23 13:45:05 UTC",
    "User": "root"
  },
  "Author": "Hannes Mühleisen [aut] (ORCID: <https://orcid.org/0000-0001-8552-0029>),\nMark Raasveldt [aut] (ORCID: <https://orcid.org/0000-0001-5005-6844>),\nKirill Müller [cre] (ORCID: <https://orcid.org/0000-0002-1416-3412>),\nStichting DuckDB Foundation [cph],\nApache Software Foundation [cph],\nPostgreSQL Global Development Group [cph],\nThe Regents of the University of California [cph],\nCameron Desrochers [cph],\nVictor Zverovich [cph],\nRAD Game Tools [cph],\nValve Software [cph],\nRich Geldreich [cph],\nTenacious Software LLC [cph],\nThe RE2 Authors [cph],\nGoogle Inc. [cph],\nFacebook Inc. [cph],\nSteven G. Johnson [cph],\nJiahao Chen [cph],\nTony Kelman [cph],\nJonas Fonseca [cph],\nLukas Fittl [cph],\nSalvatore Sanfilippo [cph],\nArt.sy, Inc. [cph],\nOran Agra [cph],\nRedis Labs, Inc. [cph],\nMelissa O'Neill [cph],\nPCG Project contributors [cph]",
  "Maintainer": "Kirill Müller <kirill@cynkra.com>",
  "_user": "duckdb",
  "_type": "src",
  "_file": "duckdb_2.0.0.9000.tar.gz",
  "_fileid": "https://r2.ropensci.org/3afa73dd853021b4a5292c3dd727592d29bdffefd5d4797cad2ff03b956a5159",
  "_filesize": 8576211,
  "_sha256": "3afa73dd853021b4a5292c3dd727592d29bdffefd5d4797cad2ff03b956a5159",
  "_expires": "2027-01-31T16:08:12.000Z",
  "_created": "2026-10-23T13:45:05.000Z",
  "_published": "2026-10-25T07:35:17.292Z",
  "_upstream": "https://github.com/duckdb/duckdb-r",
  "_status": "success",
  "_maintainer": {
    "name": "Kirill Müller",
    "email": "kirill@cynkra.com",
    "login": "krlmlr",
    "orcid": "0000-0002-1416-3412",
    "description": "",
    "uuid": 1741643
  },
  "_jobs": [
    {
      "job": 121096825808,
      "time": 2436,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12511415820"
    },
    {
      "job": 121096825811,
      "time": 2630,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12510883352"
    },
    {
      "job": 121096825816,
      "time": 2302,
      "config": "linux-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12510901618"
    },
    {
      "job": 121096826164,
      "time": 2551,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12511476101"
    },
    {
      "job": 121096825841,
      "time": 2387,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12512199979"
    },
    {
      "job": 121096825899,
      "time": 3916,
      "config": "macos-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12514487340"
    },
    {
      "job": 121096826110,
      "time": 2089,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12512344731"
    },
    {
      "job": 121096825017,
      "time": 3812,
      "config": "macos-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12591540044"
    },
    {
      "job": 121096825803,
      "time": 2655,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12507399073"
    },
    {
      "job": 121096825861,
      "time": 1615,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "12510525788"
    },
    {
      "job": 121096825836,
      "time": 2649,
      "config": "windows-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12510748595"
    },
    {
      "job": 121096825914,
      "time": 3701,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12512371598"
    },
    {
      "job": 121096826512,
      "time": 3145,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12510989156"
    },
    {
      "job": 121096826271,
      "time": 2603,
      "config": "windows-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12511521664"
    },
    {
      "job": 121096826250,
      "time": 3513,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12512002734"
    }
  ],
  "_buildurl": "https://github.com/r-universe/duckdb/actions/runs/39963377093",
  "_commit": {
    "id": "ca768a989ad5554f5b643dd26e84dce8578660ba",
    "author": "Kirill Müller <krlmlr@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #2970 from duckdb/claude/release-2.0.0-rerelease\n\nchore: Re-release 2.0.0 with the new logo",
    "time": 1792742995
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_registered": true,
  "_dependencies": [
    {
      "package": "DBI",
      "role": "Depends"
    },
    {
      "package": "R",
      "version": ">= 4.2.0",
      "role": "Depends"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "utils",
      "role": "Imports"
    },
    {
      "package": "adbcdrivermanager",
      "role": "Suggests"
    },
    {
      "package": "arrow",
      "version": ">= 13.0.0",
      "role": "Suggests"
    },
    {
      "package": "bit64",
      "role": "Suggests"
    },
    {
      "package": "callr",
      "role": "Suggests"
    },
    {
      "package": "clock",
      "role": "Suggests"
    },
    {
      "package": "DBItest",
      "role": "Suggests"
    },
    {
      "package": "dbplyr",
      "version": ">= 2.6.0",
      "role": "Suggests"
    },
    {
      "package": "dplyr",
      "role": "Suggests"
    },
    {
      "package": "nanoarrow",
      "role": "Suggests"
    },
    {
      "package": "rlang",
      "role": "Suggests"
    },
    {
      "package": "sf",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "tibble",
      "role": "Suggests"
    },
    {
      "package": "vctrs",
      "role": "Suggests"
    },
    {
      "package": "wk",
      "role": "Suggests"
    },
    {
      "package": "withr",
      "role": "Suggests"
    }
  ],
  "_owner": "duckdb",
  "_selfowned": true,
  "_usedby": 162,
  "_updates": [
    {
      "week": "2025-43",
      "n": 15
    },
    {
      "week": "2025-44",
      "n": 15
    },
    {
      "week": "2025-45",
      "n": 20
    },
    {
      "week": "2025-46",
      "n": 16
    },
    {
      "week": "2025-47",
      "n": 1
    },
    {
      "week": "2025-48",
      "n": 22
    },
    {
      "week": "2025-49",
      "n": 20
    },
    {
      "week": "2025-50",
      "n": 9
    },
    {
      "week": "2026-01",
      "n": 16
    },
    {
      "week": "2026-02",
      "n": 12
    },
    {
      "week": "2026-03",
      "n": 13
    },
    {
      "week": "2026-04",
      "n": 5
    },
    {
      "week": "2026-05",
      "n": 15
    },
    {
      "week": "2026-06",
      "n": 3
    },
    {
      "week": "2026-08",
      "n": 2
    },
    {
      "week": "2026-09",
      "n": 7
    },
    {
      "week": "2026-10",
      "n": 6
    },
    {
      "week": "2026-11",
      "n": 24
    },
    {
      "week": "2026-12",
      "n": 79
    },
    {
      "week": "2026-13",
      "n": 33
    },
    {
      "week": "2026-14",
      "n": 1
    },
    {
      "week": "2026-15",
      "n": 5
    },
    {
      "week": "2026-16",
      "n": 98
    },
    {
      "week": "2026-18",
      "n": 16
    },
    {
      "week": "2026-19",
      "n": 13
    },
    {
      "week": "2026-20",
      "n": 78
    },
    {
      "week": "2026-21",
      "n": 51
    },
    {
      "week": "2026-24",
      "n": 46
    },
    {
      "week": "2026-25",
      "n": 47
    },
    {
      "week": "2026-26",
      "n": 15
    },
    {
      "week": "2026-27",
      "n": 4
    },
    {
      "week": "2026-28",
      "n": 2
    },
    {
      "week": "2026-29",
      "n": 6
    },
    {
      "week": "2026-30",
      "n": 96
    },
    {
      "week": "2026-31",
      "n": 71
    },
    {
      "week": "2026-32",
      "n": 124
    },
    {
      "week": "2026-33",
      "n": 10
    },
    {
      "week": "2026-34",
      "n": 7
    },
    {
      "week": "2026-36",
      "n": 8
    },
    {
      "week": "2026-37",
      "n": 56
    },
    {
      "week": "2026-38",
      "n": 17
    },
    {
      "week": "2026-39",
      "n": 66
    },
    {
      "week": "2026-40",
      "n": 98
    },
    {
      "week": "2026-41",
      "n": 2
    },
    {
      "week": "2026-42",
      "n": 2193
    },
    {
      "week": "2026-43",
      "n": 71
    }
  ],
  "_tags": [
    {
      "name": "v1.4.1.9003",
      "date": "2025-10-25"
    },
    {
      "name": "v1.4.1.9004",
      "date": "2025-10-29"
    },
    {
      "name": "v1.4.1.9005",
      "date": "2025-10-30"
    },
    {
      "name": "v1.4.1.9006",
      "date": "2025-10-31"
    },
    {
      "name": "v1.4.1.9007",
      "date": "2025-11-01"
    },
    {
      "name": "v1.4.1.9008",
      "date": "2025-11-02"
    },
    {
      "name": "v1.4.1.9009",
      "date": "2025-11-03"
    },
    {
      "name": "v1.4.1.9010",
      "date": "2025-11-04"
    },
    {
      "name": "v1.4.1.9011",
      "date": "2025-11-05"
    },
    {
      "name": "v1.4.1.9012",
      "date": "2025-11-06"
    },
    {
      "name": "v1.4.1.9013",
      "date": "2025-11-07"
    },
    {
      "name": "v1.4.1.9014",
      "date": "2025-11-08"
    },
    {
      "name": "v1.4.1.9015",
      "date": "2025-11-09"
    },
    {
      "name": "v1.4.1.9016",
      "date": "2025-11-10"
    },
    {
      "name": "v1.4.1.9017",
      "date": "2025-11-11"
    },
    {
      "name": "v1.4.1.9018",
      "date": "2025-11-12"
    },
    {
      "name": "v1.4.2",
      "date": "2025-11-12"
    },
    {
      "name": "v1.4.2.9000",
      "date": "2025-11-13"
    },
    {
      "name": "v1.4.2.9001",
      "date": "2025-11-17"
    },
    {
      "name": "v1.4.2.9002",
      "date": "2025-11-27"
    },
    {
      "name": "v1.4.2.9003",
      "date": "2025-11-28"
    },
    {
      "name": "v1.4.2.9004",
      "date": "2025-11-29"
    },
    {
      "name": "v1.4.2.9005",
      "date": "2025-12-01"
    },
    {
      "name": "v1.4.2.9006",
      "date": "2025-12-02"
    },
    {
      "name": "v1.4.2.9007",
      "date": "2025-12-03"
    },
    {
      "name": "v1.4.2.9008",
      "date": "2025-12-04"
    },
    {
      "name": "v1.4.2.9009",
      "date": "2025-12-05"
    },
    {
      "name": "v1.4.2.9010",
      "date": "2025-12-06"
    },
    {
      "name": "v1.4.2.9011",
      "date": "2025-12-08"
    },
    {
      "name": "v1.4.2.9012",
      "date": "2025-12-09"
    },
    {
      "name": "v1.4.2.9013",
      "date": "2025-12-09"
    },
    {
      "name": "v1.4.3",
      "date": "2025-12-09"
    },
    {
      "name": "v1.4.3.9000",
      "date": "2025-12-11"
    },
    {
      "name": "v1.4.3.9001",
      "date": "2026-01-01"
    },
    {
      "name": "v1.4.3.9002",
      "date": "2026-01-03"
    },
    {
      "name": "v1.4.3.9003",
      "date": "2026-01-07"
    },
    {
      "name": "v1.4.3.9004",
      "date": "2026-01-08"
    },
    {
      "name": "v1.4.3.9005",
      "date": "2026-01-09"
    },
    {
      "name": "v1.4.3.9006",
      "date": "2026-01-10"
    },
    {
      "name": "v1.4.3.9007",
      "date": "2026-01-13"
    },
    {
      "name": "v1.4.3.9008",
      "date": "2026-01-14"
    },
    {
      "name": "v1.4.3.9009",
      "date": "2026-01-15"
    },
    {
      "name": "v1.4.3.9010",
      "date": "2026-01-16"
    },
    {
      "name": "v1.4.3.9011",
      "date": "2026-01-22"
    },
    {
      "name": "v1.4.3.9012",
      "date": "2026-01-23"
    },
    {
      "name": "v1.4.3.9013",
      "date": "2026-01-27"
    },
    {
      "name": "v1.4.3.9014",
      "date": "2026-01-27"
    },
    {
      "name": "v1.4.3.9015",
      "date": "2026-01-27"
    },
    {
      "name": "v1.4.4",
      "date": "2026-01-27"
    },
    {
      "name": "v1.4.4.9000",
      "date": "2026-01-28"
    },
    {
      "name": "v1.4.4.9001",
      "date": "2026-01-29"
    },
    {
      "name": "v1.4.4.9002",
      "date": "2026-02-02"
    },
    {
      "name": "v1.4.4.9003",
      "date": "2026-02-05"
    },
    {
      "name": "v1.4.4.9004",
      "date": "2026-02-17"
    },
    {
      "name": "v1.4.4.9005",
      "date": "2026-02-28"
    },
    {
      "name": "v1.4.4.9006",
      "date": "2026-03-01"
    },
    {
      "name": "v1.4.4.9007",
      "date": "2026-03-06"
    },
    {
      "name": "v1.4.4.9008",
      "date": "2026-03-08"
    },
    {
      "name": "v1.4.4.9009",
      "date": "2026-03-10"
    },
    {
      "name": "v1.4.4.9010",
      "date": "2026-03-10"
    },
    {
      "name": "v1.5.0.9000",
      "date": "2026-03-11"
    },
    {
      "name": "v1.5.0",
      "date": "2026-03-12"
    },
    {
      "name": "v1.5.0.9001",
      "date": "2026-03-12"
    },
    {
      "name": "v1.5.0.9002",
      "date": "2026-03-13"
    },
    {
      "name": "v1.5.0.9003",
      "date": "2026-03-16"
    },
    {
      "name": "v1.5.0.9004",
      "date": "2026-03-17"
    },
    {
      "name": "v1.5.0.9005",
      "date": "2026-03-18"
    },
    {
      "name": "v1.5.0.9006",
      "date": "2026-03-19"
    },
    {
      "name": "v1.5.0.9007",
      "date": "2026-03-23"
    },
    {
      "name": "v1.5.0.9008",
      "date": "2026-03-23"
    },
    {
      "name": "v1.5.1",
      "date": "2026-03-24"
    },
    {
      "name": "v1.5.1.9000",
      "date": "2026-03-28"
    },
    {
      "name": "v1.5.1.9001",
      "date": "2026-03-29"
    },
    {
      "name": "v1.5.1.9002",
      "date": "2026-03-30"
    },
    {
      "name": "v1.5.1.9003",
      "date": "2026-04-11"
    },
    {
      "name": "v1.5.1.9004",
      "date": "2026-04-13"
    },
    {
      "name": "v1.5.1.9005",
      "date": "2026-04-13"
    },
    {
      "name": "v1.5.2",
      "date": "2026-04-13"
    },
    {
      "name": "v1.5.2.9000",
      "date": "2026-04-14"
    },
    {
      "name": "v1.5.2.9001",
      "date": "2026-05-01"
    },
    {
      "name": "v1.5.2.9002",
      "date": "2026-05-04"
    },
    {
      "name": "v1.5.2.9003",
      "date": "2026-05-06"
    },
    {
      "name": "v1.5.2.9004",
      "date": "2026-05-10"
    },
    {
      "name": "v1.5.2.9005",
      "date": "2026-05-10"
    },
    {
      "name": "v1.5.2.9006",
      "date": "2026-05-12"
    },
    {
      "name": "v1.5.2.9007",
      "date": "2026-05-14"
    },
    {
      "name": "v1.5.2.9008",
      "date": "2026-05-21"
    },
    {
      "name": "v1.5.2.9009",
      "date": "2026-05-21"
    },
    {
      "name": "v1.5.2.9901",
      "date": "2026-05-21"
    },
    {
      "name": "v1.5.3.9000",
      "date": "2026-05-22"
    },
    {
      "name": "v1.5.3.9001",
      "date": "2026-05-23"
    },
    {
      "name": "v1.5.3.9002",
      "date": "2026-05-24"
    },
    {
      "name": "v1.5.3",
      "date": "2026-06-02"
    },
    {
      "name": "v1.5.3.9003",
      "date": "2026-06-11"
    },
    {
      "name": "v1.5.3.9004",
      "date": "2026-06-14"
    },
    {
      "name": "v1.5.3.9005",
      "date": "2026-06-17"
    },
    {
      "name": "v1.5.3.9006",
      "date": "2026-06-17"
    },
    {
      "name": "v1.5.3.9901",
      "date": "2026-06-18"
    },
    {
      "name": "v1.5.4",
      "date": "2026-06-18"
    },
    {
      "name": "v1.5.4.9000",
      "date": "2026-06-19"
    },
    {
      "name": "v1.5.4.9001",
      "date": "2026-06-20"
    },
    {
      "name": "v1.5.4.9002",
      "date": "2026-06-21"
    },
    {
      "name": "v1.5.4.9003",
      "date": "2026-06-26"
    },
    {
      "name": "v1.5.4.9004",
      "date": "2026-06-27"
    },
    {
      "name": "v1.5.4.1",
      "date": "2026-06-28"
    },
    {
      "name": "v1.5.4.9005",
      "date": "2026-06-28"
    },
    {
      "name": "v1.5.4.2",
      "date": "2026-06-29"
    },
    {
      "name": "v1.5.4.9006",
      "date": "2026-06-30"
    },
    {
      "name": "v1.5.4.9007",
      "date": "2026-07-03"
    },
    {
      "name": "v1.5.4.3",
      "date": "2026-07-09"
    },
    {
      "name": "v1.5.4.9008",
      "date": "2026-07-09"
    },
    {
      "name": "v1.5.4.4",
      "date": "2026-07-17"
    },
    {
      "name": "v1.5.4.9009",
      "date": "2026-07-19"
    },
    {
      "name": "v1.5.4.9010",
      "date": "2026-07-21"
    },
    {
      "name": "v1.5.4.9011",
      "date": "2026-07-22"
    },
    {
      "name": "v1.5.4.9012",
      "date": "2026-07-22"
    },
    {
      "name": "v1.5.4.9013",
      "date": "2026-07-22"
    },
    {
      "name": "v1.5.4.9901",
      "date": "2026-07-23"
    },
    {
      "name": "v1.5.4.9902",
      "date": "2026-07-24"
    },
    {
      "name": "v1.5.4.9903",
      "date": "2026-07-24"
    },
    {
      "name": "v1.5.5",
      "date": "2026-07-24"
    },
    {
      "name": "v1.5.5.9000",
      "date": "2026-07-25"
    },
    {
      "name": "v1.5.5.9001",
      "date": "2026-07-28"
    },
    {
      "name": "v1.5.5.9002",
      "date": "2026-07-30"
    },
    {
      "name": "v1.5.5.9003",
      "date": "2026-07-31"
    },
    {
      "name": "v1.5.5.9004",
      "date": "2026-08-01"
    },
    {
      "name": "v1.5.5.9005",
      "date": "2026-08-02"
    },
    {
      "name": "v1.5.5.9006",
      "date": "2026-08-03"
    },
    {
      "name": "v1.5.5.9007",
      "date": "2026-08-04"
    },
    {
      "name": "v1.5.5.9008",
      "date": "2026-08-05"
    },
    {
      "name": "v1.5.5.9009",
      "date": "2026-08-05"
    },
    {
      "name": "v1.5.5.9010",
      "date": "2026-08-06"
    },
    {
      "name": "v1.5.5.9011",
      "date": "2026-08-08"
    },
    {
      "name": "v1.5.5.9012",
      "date": "2026-08-08"
    },
    {
      "name": "v1.5.5.9013",
      "date": "2026-08-09"
    },
    {
      "name": "v1.5.5.9014",
      "date": "2026-08-10"
    },
    {
      "name": "v1.5.5.9015",
      "date": "2026-08-14"
    },
    {
      "name": "v1.5.5.9016",
      "date": "2026-08-16"
    },
    {
      "name": "v1.5.5.9017",
      "date": "2026-08-17"
    },
    {
      "name": "v1.5.5.9018",
      "date": "2026-08-20"
    },
    {
      "name": "v1.5.5.9019",
      "date": "2026-08-23"
    },
    {
      "name": "v1.5.5.9020",
      "date": "2026-09-05"
    },
    {
      "name": "v1.5.5.9021",
      "date": "2026-09-13"
    },
    {
      "name": "v1.5.5.9022",
      "date": "2026-09-13"
    },
    {
      "name": "v1.5.5.9023",
      "date": "2026-09-14"
    },
    {
      "name": "v1.5.5.9024",
      "date": "2026-09-19"
    },
    {
      "name": "v1.5.5.9025",
      "date": "2026-09-20"
    },
    {
      "name": "v1.5.5.9026",
      "date": "2026-09-21"
    },
    {
      "name": "v1.5.5.9027",
      "date": "2026-09-26"
    },
    {
      "name": "v1.5.5.9028",
      "date": "2026-09-26"
    },
    {
      "name": "v1.5.5.9029",
      "date": "2026-09-27"
    },
    {
      "name": "v1.5.5.9900",
      "date": "2026-09-28"
    },
    {
      "name": "v1.5.6",
      "date": "2026-09-28"
    },
    {
      "name": "v1.5.6.9000",
      "date": "2026-09-28"
    },
    {
      "name": "v1.5.6.9001",
      "date": "2026-09-29"
    },
    {
      "name": "v1.5.6.9002",
      "date": "2026-10-01"
    },
    {
      "name": "v1.5.6.9003",
      "date": "2026-10-10"
    },
    {
      "name": "v1.5.6.9004",
      "date": "2026-10-13"
    },
    {
      "name": "v1.99.99.9001",
      "date": "2026-10-21"
    },
    {
      "name": "v2.0.0",
      "date": "2026-10-22"
    }
  ],
  "_topics": [
    "database",
    "duckdb",
    "olap",
    "cpp"
  ],
  "_stars": 230,
  "_contributors": [
    {
      "user": "krlmlr",
      "count": 3872,
      "uuid": 1741643
    },
    {
      "user": "claude",
      "count": 2241,
      "uuid": 81847
    },
    {
      "user": "copilot",
      "count": 40,
      "uuid": 198982749
    },
    {
      "user": "tmonster",
      "count": 20,
      "uuid": 6248601
    },
    {
      "user": "lschneiderbauer",
      "count": 17,
      "uuid": 422100
    },
    {
      "user": "edward-burn",
      "count": 16,
      "uuid": 9583964
    },
    {
      "user": "hannes",
      "count": 16,
      "uuid": 227792
    },
    {
      "user": "szarnyasg",
      "count": 10,
      "uuid": 1402801
    },
    {
      "user": "toppyy",
      "count": 7,
      "uuid": 43851547
    },
    {
      "user": "maelle",
      "count": 7,
      "uuid": 8360597
    },
    {
      "user": "romainfrancois",
      "count": 6,
      "uuid": 2625526
    },
    {
      "user": "joakimlinde",
      "count": 5,
      "uuid": 61517589
    },
    {
      "user": "mytherin",
      "count": 4,
      "uuid": 3978469
    },
    {
      "user": "antonov548",
      "count": 3,
      "uuid": 22891541
    },
    {
      "user": "thomassoeiro",
      "count": 3,
      "uuid": 124079058
    },
    {
      "user": "eitsupi",
      "count": 2,
      "uuid": 50911393
    },
    {
      "user": "m-muecke",
      "count": 2,
      "uuid": 26463953
    },
    {
      "user": "meztez",
      "count": 1,
      "uuid": 31039074
    },
    {
      "user": "dfalbel",
      "count": 1,
      "uuid": 4706822
    },
    {
      "user": "eddelbuettel",
      "count": 1,
      "uuid": 673121
    },
    {
      "user": "elefeint",
      "count": 1,
      "uuid": 41136058
    },
    {
      "user": "eli-daniels",
      "count": 1,
      "uuid": 90638398
    },
    {
      "user": "ioannanika",
      "count": 1,
      "uuid": 45609421
    },
    {
      "user": "pdet",
      "count": 1,
      "uuid": 7377477
    },
    {
      "user": "rplsmn",
      "count": 1,
      "uuid": 74007913
    },
    {
      "user": "thohan88",
      "count": 1,
      "uuid": 16469189
    },
    {
      "user": "t-kalinowski",
      "count": 1,
      "uuid": 8462255
    },
    {
      "user": "jangorecki",
      "count": 1,
      "uuid": 3627377
    },
    {
      "user": "olivroy",
      "count": 1,
      "uuid": 52606734
    },
    {
      "user": "tau31",
      "count": 1,
      "uuid": 121633071
    }
  ],
  "_userbio": {
    "uuid": 82039556,
    "type": "organization",
    "name": "DuckDB Foundation",
    "followers": 1845
  },
  "_downloads": {
    "count": 105318,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/duckdb"
  },
  "_devurl": "https://github.com/duckdb/duckdb-r",
  "_pkgdown": "https://r.duckdb.org/",
  "_searchresults": 6512,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/duckdb.html",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_homeurl": "https://github.com/duckdb/duckdb-r",
  "_realowner": "duckdb",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.2.1",
      "date": "2020-09-10"
    },
    {
      "version": "0.2.1-2",
      "date": "2020-09-30"
    },
    {
      "version": "0.2.2",
      "date": "2020-11-03"
    },
    {
      "version": "0.2.2-1",
      "date": "2020-11-09"
    },
    {
      "version": "0.2.3",
      "date": "2020-12-12"
    },
    {
      "version": "0.2.4",
      "date": "2021-02-02"
    },
    {
      "version": "0.2.5",
      "date": "2021-03-16"
    },
    {
      "version": "0.2.6",
      "date": "2021-05-09"
    },
    {
      "version": "0.2.7",
      "date": "2021-06-14"
    },
    {
      "version": "0.2.8",
      "date": "2021-08-02"
    },
    {
      "version": "0.2.9",
      "date": "2021-09-06"
    },
    {
      "version": "0.3.0",
      "date": "2021-10-08"
    },
    {
      "version": "0.3.1",
      "date": "2021-11-16"
    },
    {
      "version": "0.3.1-1",
      "date": "2021-11-22"
    },
    {
      "version": "0.3.2",
      "date": "2022-02-07"
    },
    {
      "version": "0.3.2-1",
      "date": "2022-03-02"
    },
    {
      "version": "0.3.2-2",
      "date": "2022-03-16"
    },
    {
      "version": "0.3.4",
      "date": "2022-06-05"
    },
    {
      "version": "0.3.4-1",
      "date": "2022-06-13"
    },
    {
      "version": "0.4.0",
      "date": "2022-06-21"
    },
    {
      "version": "0.5.0",
      "date": "2022-09-05"
    },
    {
      "version": "0.5.1",
      "date": "2022-09-20"
    },
    {
      "version": "0.6.0",
      "date": "2022-11-25"
    },
    {
      "version": "0.6.1",
      "date": "2022-12-08"
    },
    {
      "version": "0.6.2",
      "date": "2023-01-16"
    },
    {
      "version": "0.7.0",
      "date": "2023-02-14"
    },
    {
      "version": "0.7.1-1",
      "date": "2023-03-01"
    },
    {
      "version": "0.8.0",
      "date": "2023-05-23"
    },
    {
      "version": "0.8.1",
      "date": "2023-06-16"
    },
    {
      "version": "0.8.1-1",
      "date": "2023-07-17"
    },
    {
      "version": "0.8.1-2",
      "date": "2023-08-25"
    },
    {
      "version": "0.8.1-3",
      "date": "2023-09-01"
    },
    {
      "version": "0.9.1",
      "date": "2023-10-13"
    },
    {
      "version": "0.9.1-1",
      "date": "2023-10-30"
    },
    {
      "version": "0.9.2",
      "date": "2023-11-17"
    },
    {
      "version": "0.9.2-1",
      "date": "2023-11-28"
    },
    {
      "version": "0.10.0",
      "date": "2024-03-13"
    },
    {
      "version": "0.10.1",
      "date": "2024-04-02"
    },
    {
      "version": "0.10.2",
      "date": "2024-05-02"
    },
    {
      "version": "1.0.0",
      "date": "2024-06-14"
    },
    {
      "version": "1.0.0-1",
      "date": "2024-07-10"
    },
    {
      "version": "1.0.0-2",
      "date": "2024-07-19"
    },
    {
      "version": "1.1.0",
      "date": "2024-09-25"
    },
    {
      "version": "1.1.1",
      "date": "2024-10-16"
    },
    {
      "version": "1.1.2",
      "date": "2024-10-30"
    },
    {
      "version": "1.1.3",
      "date": "2024-11-21"
    },
    {
      "version": "1.1.3-1",
      "date": "2024-12-08"
    },
    {
      "version": "1.1.3-2",
      "date": "2025-01-24"
    },
    {
      "version": "1.2.0",
      "date": "2025-02-21"
    },
    {
      "version": "1.2.1",
      "date": "2025-03-14"
    },
    {
      "version": "1.2.2",
      "date": "2025-04-29"
    },
    {
      "version": "1.3.0",
      "date": "2025-06-02"
    },
    {
      "version": "1.3.1",
      "date": "2025-06-23"
    },
    {
      "version": "1.3.2",
      "date": "2025-07-09"
    },
    {
      "version": "1.3.3",
      "date": "2025-09-10"
    },
    {
      "version": "1.4.0",
      "date": "2025-09-18"
    },
    {
      "version": "1.4.1",
      "date": "2025-10-16"
    },
    {
      "version": "1.4.2",
      "date": "2025-11-18"
    },
    {
      "version": "1.4.3",
      "date": "2025-12-11"
    },
    {
      "version": "1.4.4",
      "date": "2026-01-28"
    },
    {
      "version": "1.5.0",
      "date": "2026-03-14"
    },
    {
      "version": "1.5.1",
      "date": "2026-03-26"
    },
    {
      "version": "1.5.2",
      "date": "2026-04-13"
    },
    {
      "version": "1.5.4",
      "date": "2026-06-19"
    },
    {
      "version": "1.5.4.1",
      "date": "2026-06-28"
    },
    {
      "version": "1.5.4.2",
      "date": "2026-06-29"
    },
    {
      "version": "1.5.4.3",
      "date": "2026-07-10"
    },
    {
      "version": "1.5.5",
      "date": "2026-07-25"
    },
    {
      "version": "1.5.6",
      "date": "2026-09-29"
    }
  ],
  "_exports": [
    "dbAppendTable",
    "dbBegin",
    "dbBind",
    "dbBindArrow",
    "dbClearResult",
    "dbColumnInfo",
    "dbCommit",
    "dbConnect",
    "dbDataType",
    "dbDisconnect",
    "dbExistsTable",
    "dbFetch",
    "dbFetchArrow",
    "dbFetchArrowChunk",
    "dbGetInfo",
    "dbGetRowCount",
    "dbGetRowsAffected",
    "dbGetStatement",
    "dbHasCompleted",
    "dbIsValid",
    "dbListFields",
    "dbListTables",
    "dbQuoteIdentifier",
    "dbQuoteLiteral",
    "dbRemoveTable",
    "dbRollback",
    "dbSendQuery",
    "dbSendQueryArrow",
    "dbWriteTable",
    "default_conn",
    "duckdb",
    "duckdb_adbc",
    "duckdb_fetch_arrow",
    "duckdb_fetch_record_batch",
    "duckdb_list_arrow",
    "duckdb_read_csv",
    "duckdb_register",
    "duckdb_register_arrow",
    "duckdb_shutdown",
    "duckdb_storage_status",
    "duckdb_unregister",
    "duckdb_unregister_arrow",
    "read_csv_duckdb",
    "show",
    "simulate_duckdb",
    "sql_exec",
    "sql_query",
    "tbl_file",
    "tbl_function",
    "tbl_query",
    "to_arrow_stream"
  ],
  "_help": [
    {
      "page": "backend-duckdb",
      "title": "DuckDB SQL backend for dbplyr",
      "topics": [
        "simulate_duckdb",
        "tbl_file",
        "tbl_function",
        "tbl_query"
      ]
    },
    {
      "page": "default_conn",
      "title": "Get the default connection",
      "topics": [
        "default_conn"
      ]
    },
    {
      "page": "duckdb",
      "title": "Connect to a DuckDB database instance",
      "topics": [
        "dbConnect,duckdb_driver-method",
        "dbConnect__duckdb_driver",
        "dbDisconnect,duckdb_connection-method",
        "dbDisconnect__duckdb_connection",
        "duckdb",
        "duckdb_adbc",
        "duckdb_shutdown"
      ]
    },
    {
      "page": "duckdb_error",
      "title": "DuckDB error conditions",
      "topics": [
        "duckdb_error"
      ]
    },
    {
      "page": "duckdb_explain-class",
      "title": "DuckDB EXPLAIN query tree",
      "topics": [
        "duckdb_explain",
        "duckdb_explain-class",
        "print.duckdb_explain"
      ]
    },
    {
      "page": "duckdb_memory",
      "title": "Memory-efficient reading and writing",
      "topics": [
        "duckdb_memory"
      ]
    },
    {
      "page": "duckdb_read_csv",
      "title": "Reads a CSV file into DuckDB",
      "topics": [
        "duckdb_read_csv"
      ]
    },
    {
      "page": "duckdb_register",
      "title": "Register a data frame as a virtual table",
      "topics": [
        "duckdb_register",
        "duckdb_unregister"
      ]
    },
    {
      "page": "duckdb_register_arrow",
      "title": "Register an Arrow data source as a virtual table",
      "topics": [
        "duckdb_list_arrow",
        "duckdb_register_arrow",
        "duckdb_unregister_arrow"
      ]
    },
    {
      "page": "duckdb_storage",
      "title": "DuckDB file-system usage: storage locations and how they are resolved",
      "topics": [
        "duckdb_storage",
        "duckdb_storage_status"
      ]
    },
    {
      "page": "duckdb_types",
      "title": "DuckDB data types in R",
      "topics": [
        "duckdb_types"
      ]
    },
    {
      "page": "duckdb_types_arrow",
      "title": "DuckDB data types through Arrow",
      "topics": [
        "duckdb_types_arrow"
      ]
    },
    {
      "page": "sql_query",
      "title": "Run an SQL query or statement",
      "topics": [
        "sql_exec",
        "sql_query"
      ]
    },
    {
      "page": "to_arrow_stream",
      "title": "Stream a dbplyr table on DuckDB into Arrow",
      "topics": [
        "to_arrow_stream"
      ]
    }
  ],
  "_pkglogo": "https://github.com/duckdb/duckdb-r/raw/HEAD/man/figures/logo.svg",
  "_readme": "https://github.com/duckdb/duckdb-r/raw/HEAD/README.md",
  "_rundeps": [
    "DBI"
  ],
  "_sysdeps": [
    {
      "shlib": "libstdc++",
      "package": "libstdc++6",
      "source": "gcc",
      "version": "16-20260322-1ubuntu1",
      "name": "c++",
      "homepage": "http://gcc.gnu.org/",
      "description": "GNU Standard C++ Library v3"
    }
  ],
  "_score": 15.708706934291603,
  "_indexed": true,
  "_nocasepkg": "duckdb",
  "_universes": [
    "duckdb",
    "krlmlr"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "2.0.0.9000",
      "date": "2026-10-23T14:28:33.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "ca768a989ad5554f5b643dd26e84dce8578660ba",
      "fileid": "https://r2.ropensci.org/937d6f245af0299eda1b59bde0d0bef24365f3240fa9cdf4d7163a918c876031",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/duckdb/actions/runs/39963377093"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "2.0.0.9000",
      "date": "2026-10-23T14:28:36.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "ca768a989ad5554f5b643dd26e84dce8578660ba",
      "fileid": "https://r2.ropensci.org/07fd98c742b2f3467dc5ba2e4d58472af1890d9505a5f2b59b6ae7b37ac0daab",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/duckdb/actions/runs/39963377093"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "2.0.0.9000",
      "date": "2026-10-23T14:28:34.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "ca768a989ad5554f5b643dd26e84dce8578660ba",
      "fileid": "https://r2.ropensci.org/b3f7504eee482ec1e1ead84a31ccccfc961b9f62550fcc5cf5b8e8dbe1f62739",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/duckdb/actions/runs/39963377093"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "2.0.0.9000",
      "date": "2026-10-23T14:28:40.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "ca768a989ad5554f5b643dd26e84dce8578660ba",
      "fileid": "https://r2.ropensci.org/a6df6fcfd0746005090da4e07983c15d534ccb60074a786603c5ead83113f6bf",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/duckdb/actions/runs/39963377093"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "2.0.0.9000",
      "date": "2026-10-23T15:04:27.000Z",
      "arch": "aarch64",
      "commit": "ca768a989ad5554f5b643dd26e84dce8578660ba",
      "fileid": "https://r2.ropensci.org/06afac2020858b767a9d4c93b432d2691f97948b1d78a95b7a5e5703df4bb1a1",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/duckdb/actions/runs/39963377093"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "2.0.0.9000",
      "date": "2026-10-23T15:05:22.000Z",
      "arch": "x86_64",
      "commit": "ca768a989ad5554f5b643dd26e84dce8578660ba",
      "fileid": "https://r2.ropensci.org/3b3034e601d6dbff59fb17dc6b2005eab8fcf31448f6c4f9e88bd2dd5008c7fb",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/duckdb/actions/runs/39963377093"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "2.0.0.9000",
      "date": "2026-10-23T15:07:59.000Z",
      "arch": "aarch64",
      "commit": "ca768a989ad5554f5b643dd26e84dce8578660ba",
      "fileid": "https://r2.ropensci.org/aef8e4a8abe38e918b561b08f9004ef321b06c15b8eb0b767c17d5d1c87436d1",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/duckdb/actions/runs/39963377093"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "2.0.0.9000",
      "date": "2026-10-25T06:37:46.000Z",
      "arch": "x86_64",
      "commit": "ca768a989ad5554f5b643dd26e84dce8578660ba",
      "fileid": "https://r2.ropensci.org/2a775a966a38ebda98ddd1047af920f416fe3677f0a3aa05d9b50e7278413499",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/duckdb/actions/runs/39963377093"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "2.0.0.9000",
      "date": "2026-10-23T14:28:19.000Z",
      "arch": "emscripten",
      "commit": "ca768a989ad5554f5b643dd26e84dce8578660ba",
      "fileid": "https://r2.ropensci.org/f54ee702bc5aeab0b009166510db247cb45a85e3d29e48d22a9773fd754ae1a6",
      "status": "success",
      "buildurl": "https://github.com/r-universe/duckdb/actions/runs/39963377093"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "2.0.0.9000",
      "date": "2026-10-23T14:29:26.000Z",
      "arch": "aarch64",
      "commit": "ca768a989ad5554f5b643dd26e84dce8578660ba",
      "fileid": "https://r2.ropensci.org/9be565e9ec3e06136364e217fd6895ded06e33cf4e0be4c983506619b76ec29e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/duckdb/actions/runs/39963377093"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "2.0.0.9000",
      "date": "2026-10-23T14:27:39.000Z",
      "arch": "x86_64",
      "commit": "ca768a989ad5554f5b643dd26e84dce8578660ba",
      "fileid": "https://r2.ropensci.org/756bc1e8c15d35d2d7c792895940cb5014efad2d515ed902ac216debec3739ee",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/duckdb/actions/runs/39963377093"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "2.0.0.9000",
      "date": "2026-10-23T14:28:01.000Z",
      "arch": "x86_64",
      "commit": "ca768a989ad5554f5b643dd26e84dce8578660ba",
      "fileid": "https://r2.ropensci.org/ad0a6ca0587e8162c85b1de9502e68d1662c5eca9d4cb6652896f092e80ae27b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/duckdb/actions/runs/39963377093"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "2.0.0.9000",
      "date": "2026-10-23T14:29:54.000Z",
      "arch": "aarch64",
      "commit": "ca768a989ad5554f5b643dd26e84dce8578660ba",
      "fileid": "https://r2.ropensci.org/4ee71809fd1a5f4a77b43357d49547f4b5f8906390cbb275c27dc7d8fa98b2ff",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/duckdb/actions/runs/39963377093"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "2.0.0.9000",
      "date": "2026-10-23T14:27:42.000Z",
      "arch": "x86_64",
      "commit": "ca768a989ad5554f5b643dd26e84dce8578660ba",
      "fileid": "https://r2.ropensci.org/34caed9a65404195a71918f90e11043be7ef0ff481c478e61135818065f3b594",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/duckdb/actions/runs/39963377093"
    }
  ]
}