{
  "_id": "6a42957e4ba05a737d8ac898",
  "Package": "duckdb",
  "Title": "DBI Package for the DuckDB Database Management System",
  "Version": "1.5.4.2",
  "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/testthat/edition": "3",
  "Encoding": "UTF-8",
  "SystemRequirements": "xz (for building from source)",
  "Config/roxygen2/version": "8.0.0.9000",
  "NeedsCompilation": "yes",
  "Packaged": {
    "Date": "2026-06-29 14:57:16 UTC",
    "User": "root"
  },
  "Author": "Hannes Mühleisen [aut] (ORCID:\n<https://orcid.org/0000-0001-8552-0029>), Mark Raasveldt [aut]\n(ORCID: <https://orcid.org/0000-0001-5005-6844>), Kirill Müller\n[cre] (ORCID: <https://orcid.org/0000-0002-1416-3412>),\nStichting DuckDB Foundation [cph], Apache Software Foundation\n[cph], PostgreSQL Global Development Group [cph], The Regents\nof the University of California [cph], Cameron Desrochers\n[cph], Victor Zverovich [cph], RAD Game Tools [cph], Valve\nSoftware [cph], Rich Geldreich [cph], Tenacious Software LLC\n[cph], The RE2 Authors [cph], Google Inc. [cph], Facebook Inc.\n[cph], Steven G. Johnson [cph], Jiahao Chen [cph], Tony Kelman\n[cph], Jonas Fonseca [cph], Lukas Fittl [cph], Salvatore\nSanfilippo [cph], Art.sy, Inc. [cph], Oran Agra [cph], Redis\nLabs, Inc. [cph], Melissa O'Neill [cph], PCG Project\ncontributors [cph]",
  "Maintainer": "Kirill Müller <kirill@cynkra.com>",
  "Config/pak/sysreqs": "xz-utils",
  "Repository": "https://cran.r-universe.dev",
  "Date/Publication": "2026-06-29 12:56:49 UTC",
  "RemoteUrl": "https://github.com/cran/duckdb",
  "RemoteRef": "HEAD",
  "RemoteSha": "49979d259f7adae6ab0c6d91864590794d92ea8c",
  "MD5sum": "755fb037737f5947a181d954b6390977",
  "_user": "cran",
  "_type": "src",
  "_file": "duckdb_1.5.4.2.tar.gz",
  "_fileid": "e308e6cd6121f65eae5e8a37ba58649e65d2a57fa985376afc9856e3005dc6f8",
  "_filesize": 4926926,
  "_sha256": "e308e6cd6121f65eae5e8a37ba58649e65d2a57fa985376afc9856e3005dc6f8",
  "_created": "2026-06-29T14:57:16.000Z",
  "_published": "2026-06-29T15:55:42.135Z",
  "_distro": "resolute",
  "_jobs": [
    {
      "job": 84090247667,
      "time": 1927,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7957270657"
    },
    {
      "job": 84090247638,
      "time": 1723,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7957180111"
    },
    {
      "job": 84090247618,
      "time": 1954,
      "config": "linux-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "7957281735"
    },
    {
      "job": 84090247624,
      "time": 2002,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "7957301108"
    },
    {
      "job": 84083800964,
      "time": 1658,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "7956402771"
    },
    {
      "job": 84090247577,
      "time": 1476,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7957070607"
    }
  ],
  "_buildurl": "https://github.com/r-universe/cran/actions/runs/28381124431",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/cran/duckdb",
  "_commit": {
    "id": "49979d259f7adae6ab0c6d91864590794d92ea8c",
    "author": "Kirill Müller <kirill@cynkra.com>",
    "committer": "cran-robot <csardi.gabor+cran@gmail.com>",
    "message": "version 1.5.4.2\n",
    "time": 1782737809
  },
  "_maintainer": {
    "name": "Kirill Müller",
    "email": "kirill@cynkra.com",
    "login": "krlmlr",
    "orcid": "0000-0002-1416-3412",
    "description": "Away from most OSS work until September 2026.",
    "uuid": 1741643
  },
  "_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",
      "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": "cran",
  "_selfowned": false,
  "_usedby": 126,
  "_updates": [
    {
      "week": "2025-26",
      "n": 1
    },
    {
      "week": "2025-28",
      "n": 1
    },
    {
      "week": "2025-37",
      "n": 1
    },
    {
      "week": "2025-38",
      "n": 1
    },
    {
      "week": "2025-42",
      "n": 1
    },
    {
      "week": "2025-47",
      "n": 1
    },
    {
      "week": "2025-50",
      "n": 1
    },
    {
      "week": "2026-05",
      "n": 1
    },
    {
      "week": "2026-11",
      "n": 1
    },
    {
      "week": "2026-13",
      "n": 1
    },
    {
      "week": "2026-16",
      "n": 1
    },
    {
      "week": "2026-25",
      "n": 1
    },
    {
      "week": "2026-26",
      "n": 1
    },
    {
      "week": "2026-27",
      "n": 1
    }
  ],
  "_tags": [
    {
      "name": "1.3.2",
      "date": "2025-07-09"
    },
    {
      "name": "1.3.3",
      "date": "2025-09-10"
    },
    {
      "name": "1.4.0",
      "date": "2025-09-18"
    },
    {
      "name": "1.4.1",
      "date": "2025-10-16"
    },
    {
      "name": "1.4.2",
      "date": "2025-11-17"
    },
    {
      "name": "1.4.3",
      "date": "2025-12-10"
    },
    {
      "name": "1.4.4",
      "date": "2026-01-28"
    },
    {
      "name": "1.5.0",
      "date": "2026-03-14"
    },
    {
      "name": "1.5.1",
      "date": "2026-03-26"
    },
    {
      "name": "1.5.2",
      "date": "2026-04-13"
    },
    {
      "name": "1.5.4",
      "date": "2026-06-19"
    },
    {
      "name": "1.5.4.1",
      "date": "2026-06-28"
    },
    {
      "name": "1.5.4.2",
      "date": "2026-06-29"
    }
  ],
  "_stars": 2,
  "_contributors": [
    {
      "user": "krlmlr",
      "count": 28,
      "uuid": 1741643
    }
  ],
  "_userbio": {
    "uuid": 6899542,
    "type": "organization",
    "name": "cran",
    "followers": 613,
    "description": "Unofficial read-only mirror of all CRAN R packages"
  },
  "_downloads": {
    "count": 116603,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/duckdb"
  },
  "_devurl": "https://github.com/duckdb/duckdb-r",
  "_pkgdown": "https://r.duckdb.org/",
  "_searchresults": 4544,
  "_topics": [
    "cpp"
  ],
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/duckdb.html",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/duckdb/duckdb-r",
  "_realowner": "duckdb",
  "_cranurl": false,
  "_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"
    }
  ],
  "_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_extension_storage",
    "duckdb_fetch_arrow",
    "duckdb_fetch_record_batch",
    "duckdb_list_arrow",
    "duckdb_read_csv",
    "duckdb_register",
    "duckdb_register_arrow",
    "duckdb_secret_storage",
    "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"
  ],
  "_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_explain-class",
      "title": "DuckDB EXPLAIN query tree",
      "topics": [
        "duckdb_explain",
        "duckdb_explain-class",
        "print.duckdb_explain"
      ]
    },
    {
      "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"
      ]
    },
    {
      "page": "duckdb_storage_config",
      "title": "Configure where DuckDB stores extensions and secrets",
      "topics": [
        "duckdb_extension_storage",
        "duckdb_secret_storage",
        "duckdb_storage_config",
        "duckdb_storage_status"
      ]
    },
    {
      "page": "sql_query",
      "title": "Run an SQL query or statement",
      "topics": [
        "sql_exec",
        "sql_query"
      ]
    }
  ],
  "_pkglogo": "https://github.com/cran/duckdb/raw/HEAD/man/figures/logo.png",
  "_readme": "https://github.com/cran/duckdb/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": 10.447767882455187,
  "_indexed": false,
  "_nocasepkg": "duckdb",
  "_universes": [
    "cran"
  ],
  "_indexurl": "https://duckdb.r-universe.dev/duckdb",
  "_previous": "1.5.4.1",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.5.4.2",
      "date": "2026-06-29T15:24:45.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "49979d259f7adae6ab0c6d91864590794d92ea8c",
      "fileid": "17734ef2ad4d232d5561facc48d4378fb88a838685fd93f84fd72cc0bfbca72b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/28381124431"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.5.4.2",
      "date": "2026-06-29T15:23:53.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "49979d259f7adae6ab0c6d91864590794d92ea8c",
      "fileid": "6a53d60ad49ef626501b56792f83a0a8f8044e98bf61fdf48cb508ed3003e6a7",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/28381124431"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.5.4.2",
      "date": "2026-06-29T15:24:51.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "49979d259f7adae6ab0c6d91864590794d92ea8c",
      "fileid": "c21ebfb3bf902f39d1f5f392abc1b89c91d5a6c70e9c790fd3654376cd21aa8f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/28381124431"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.5.4.2",
      "date": "2026-06-29T15:24:11.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "49979d259f7adae6ab0c6d91864590794d92ea8c",
      "fileid": "48c22c79c78260b3cae1b492ecee17b55bedfdea3b41e6fedf1898c661d8d865",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/28381124431"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.5.4.2",
      "date": "2026-06-29T15:24:36.000Z",
      "arch": "emscripten",
      "commit": "49979d259f7adae6ab0c6d91864590794d92ea8c",
      "fileid": "652df6716fd1b07d79507a80ae1c7458bb04c88c41059dda13ffbaf2669b6f7d",
      "status": "success",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/28381124431"
    }
  ]
}