{
  "_id": "6a129e12acfb0bcc41d0fa20",
  "Type": "Package",
  "Package": "duckplyr",
  "Title": "A 'DuckDB'-Backed Version of 'dplyr'",
  "Version": "1.2.1.9012",
  "Authors@R": "c(\nperson(\"Hannes\", \"Mühleisen\", role = \"aut\",\ncomment = c(ORCID = \"0000-0001-8552-0029\")),\nperson(\"Kirill\", \"Müller\", , \"kirill@cynkra.com\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-1416-3412\")),\nperson(\"Posit Software, PBC\", role = c(\"cph\", \"fnd\"),\ncomment = c(ROR = \"03wc8by49\"))\n)",
  "Description": "A drop-in replacement for 'dplyr', powered by 'DuckDB' for\nperformance.  Offers convenient utilities for working with\nin-memory and larger-than-memory data while retaining full\n'dplyr' compatibility.",
  "License": "MIT + file LICENSE",
  "URL": "https://duckplyr.tidyverse.org,\nhttps://github.com/tidyverse/duckplyr",
  "BugReports": "https://github.com/tidyverse/duckplyr/issues",
  "Config/Needs/check": "anthonynorth/roxyglobals",
  "Config/Needs/development": "devtools, qs2, reprex, r-lib/roxygen2,\nroxyglobals, rstudioapi, tidyverse",
  "Config/Needs/website": "dbplyr, rmarkdown, tidyverse/tidytemplate",
  "Config/testthat/edition": "3",
  "Config/testthat/parallel": "false",
  "Config/testthat/start-first": "rel_api, tpch, as_duckplyr_df,\ndplyr-mutate, dplyr-filter, dplyr-count-tally",
  "Encoding": "UTF-8",
  "Roxygen": "list( markdown = TRUE, roclets = c(\"collate\", \"namespace\",\n\"rd\", \"roxyglobals::global_roclet\") )",
  "VignetteBuilder": "knitr",
  "Config/roxygen2/version": "8.0.0.9000",
  "Config/pak/sysreqs": "xz-utils",
  "Repository": "https://fastverse.r-universe.dev",
  "Date/Publication": "2026-05-24 04:56:01 UTC",
  "RemoteUrl": "https://github.com/tidyverse/duckplyr",
  "RemoteRef": "HEAD",
  "RemoteSha": "fa9ae49cac0257b2f4d19f6577875c4470b0b6d8",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-24 06:38:12 UTC",
    "User": "root"
  },
  "Author": "Hannes Mühleisen [aut] (ORCID: <https://orcid.org/0000-0001-8552-0029>),\nKirill Müller [aut, cre] (ORCID:\n<https://orcid.org/0000-0002-1416-3412>),\nPosit Software, PBC [cph, fnd] (ROR: <https://ror.org/03wc8by49>)",
  "Maintainer": "Kirill Müller <kirill@cynkra.com>",
  "MD5sum": "d033000327d8a10676c84631c4cd70a0",
  "_user": "fastverse",
  "_type": "src",
  "_file": "duckplyr_1.2.1.9012.tar.gz",
  "_fileid": "eb67dde0c87fb815b3f6d8de48911a9d2988b3f80494f6ef863eeafe9f97a38e",
  "_filesize": 1167924,
  "_sha256": "eb67dde0c87fb815b3f6d8de48911a9d2988b3f80494f6ef863eeafe9f97a38e",
  "_created": "2026-05-24T06:38:12.000Z",
  "_published": "2026-05-24T06:43:30.694Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77577827937,
      "time": 247,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7182961097"
    },
    {
      "job": 77577827931,
      "time": 257,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7182961937"
    },
    {
      "job": 77577827928,
      "time": 160,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7182955885"
    },
    {
      "job": 77577827932,
      "time": 178,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7182963822"
    },
    {
      "job": 77577643489,
      "time": 224,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7182936155"
    },
    {
      "job": 77577827927,
      "time": 153,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7182951722"
    },
    {
      "job": 77577827935,
      "time": 208,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7182957441"
    },
    {
      "job": 77577827934,
      "time": 251,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7182961484"
    },
    {
      "job": 77577827936,
      "time": 236,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7182959945"
    }
  ],
  "_buildurl": "https://github.com/r-universe/fastverse/actions/runs/26354130575",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/tidyverse/duckplyr",
  "_commit": {
    "id": "fa9ae49cac0257b2f4d19f6577875c4470b0b6d8",
    "author": "github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "fledge: Bump version to 1.2.1.9012 (#925)\n\nCo-authored-by: krlmlr <krlmlr@users.noreply.github.com>",
    "time": 1779598561
  },
  "_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": "R",
      "version": ">= 4.0.0",
      "role": "Depends"
    },
    {
      "package": "dplyr",
      "version": ">= 1.2.0",
      "role": "Depends"
    },
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "collections",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "duckdb",
      "version": ">= 1.4.4",
      "role": "Imports"
    },
    {
      "package": "glue",
      "role": "Imports"
    },
    {
      "package": "jsonlite",
      "role": "Imports"
    },
    {
      "package": "lifecycle",
      "role": "Imports"
    },
    {
      "package": "magrittr",
      "role": "Imports"
    },
    {
      "package": "memoise",
      "role": "Imports"
    },
    {
      "package": "pillar",
      "version": ">= 1.10.2",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "version": ">= 1.0.6",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "role": "Imports"
    },
    {
      "package": "tidyselect",
      "role": "Imports"
    },
    {
      "package": "utils",
      "role": "Imports"
    },
    {
      "package": "vctrs",
      "version": ">= 0.6.3",
      "role": "Imports"
    },
    {
      "package": "arrow",
      "role": "Suggests"
    },
    {
      "package": "brio",
      "role": "Suggests"
    },
    {
      "package": "callr",
      "role": "Suggests"
    },
    {
      "package": "conflicted",
      "role": "Suggests"
    },
    {
      "package": "constructive",
      "version": ">= 1.0.0",
      "role": "Suggests"
    },
    {
      "package": "curl",
      "role": "Suggests"
    },
    {
      "package": "dbplyr",
      "role": "Suggests"
    },
    {
      "package": "hms",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "lobstr",
      "role": "Suggests"
    },
    {
      "package": "lubridate",
      "role": "Suggests"
    },
    {
      "package": "nycflights13",
      "role": "Suggests"
    },
    {
      "package": "palmerpenguins",
      "role": "Suggests"
    },
    {
      "package": "prettycode",
      "role": "Suggests"
    },
    {
      "package": "purrr",
      "role": "Suggests"
    },
    {
      "package": "readr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.1.5",
      "role": "Suggests"
    },
    {
      "package": "usethis",
      "role": "Suggests"
    },
    {
      "package": "withr",
      "role": "Suggests"
    },
    {
      "package": "qs2",
      "role": "Enhances"
    }
  ],
  "_owner": "tidyverse",
  "_selfowned": false,
  "_usedby": 6,
  "_updates": [
    {
      "week": "2025-31",
      "n": 6
    },
    {
      "week": "2025-38",
      "n": 12
    },
    {
      "week": "2025-45",
      "n": 9
    },
    {
      "week": "2025-46",
      "n": 4
    },
    {
      "week": "2025-47",
      "n": 1
    },
    {
      "week": "2025-48",
      "n": 9
    },
    {
      "week": "2025-49",
      "n": 4
    },
    {
      "week": "2026-03",
      "n": 3
    },
    {
      "week": "2026-04",
      "n": 1
    },
    {
      "week": "2026-05",
      "n": 1
    },
    {
      "week": "2026-08",
      "n": 9
    },
    {
      "week": "2026-09",
      "n": 23
    },
    {
      "week": "2026-10",
      "n": 2
    },
    {
      "week": "2026-11",
      "n": 8
    },
    {
      "week": "2026-13",
      "n": 3
    },
    {
      "week": "2026-15",
      "n": 2
    },
    {
      "week": "2026-18",
      "n": 1
    },
    {
      "week": "2026-19",
      "n": 11
    },
    {
      "week": "2026-20",
      "n": 8
    },
    {
      "week": "2026-21",
      "n": 3
    }
  ],
  "_tags": [
    {
      "name": "v1.1.0.9001",
      "date": "2025-07-29"
    },
    {
      "name": "v1.1.1",
      "date": "2025-07-29"
    },
    {
      "name": "v1.1.1.9000",
      "date": "2025-09-16"
    },
    {
      "name": "v1.1.1.9001",
      "date": "2025-09-17"
    },
    {
      "name": "v1.1.2",
      "date": "2025-09-17"
    },
    {
      "name": "v1.1.2.9000",
      "date": "2025-09-19"
    },
    {
      "name": "v1.1.2.9001",
      "date": "2025-11-03"
    },
    {
      "name": "v1.1.3",
      "date": "2025-11-03"
    },
    {
      "name": "v1.1.3.9000",
      "date": "2025-11-04"
    },
    {
      "name": "v1.1.3.9001",
      "date": "2025-11-08"
    },
    {
      "name": "v1.1.3.9002",
      "date": "2025-11-11"
    },
    {
      "name": "v1.1.3.9003",
      "date": "2025-11-12"
    },
    {
      "name": "v1.1.3.9004",
      "date": "2025-11-17"
    },
    {
      "name": "v1.1.3.9005",
      "date": "2025-11-27"
    },
    {
      "name": "v1.1.3.9006",
      "date": "2025-12-06"
    },
    {
      "name": "v1.1.3.9007",
      "date": "2026-01-14"
    },
    {
      "name": "v1.1.3.9008",
      "date": "2026-01-26"
    },
    {
      "name": "v1.1.3.9009",
      "date": "2026-02-23"
    },
    {
      "name": "v1.1.3.9010",
      "date": "2026-02-24"
    },
    {
      "name": "v1.1.3.9011",
      "date": "2026-02-24"
    },
    {
      "name": "v1.1.99.9901",
      "date": "2026-02-24"
    },
    {
      "name": "v1.2.0",
      "date": "2026-02-24"
    },
    {
      "name": "v1.2.0.9000",
      "date": "2026-02-25"
    },
    {
      "name": "v1.2.0.9001",
      "date": "2026-02-28"
    },
    {
      "name": "v1.2.0.9002",
      "date": "2026-03-08"
    },
    {
      "name": "v1.2.0.9003",
      "date": "2026-03-09"
    },
    {
      "name": "v1.2.1",
      "date": "2026-03-09"
    },
    {
      "name": "v1.2.1.9000",
      "date": "2026-03-10"
    },
    {
      "name": "v1.2.1.9001",
      "date": "2026-03-12"
    },
    {
      "name": "v1.2.1.9002",
      "date": "2026-03-13"
    },
    {
      "name": "v1.2.1.9003",
      "date": "2026-03-28"
    },
    {
      "name": "v1.2.1.9004",
      "date": "2026-04-11"
    },
    {
      "name": "v1.2.1.9005",
      "date": "2026-05-04"
    },
    {
      "name": "v1.2.1.9006",
      "date": "2026-05-06"
    },
    {
      "name": "v1.2.1.9007",
      "date": "2026-05-10"
    },
    {
      "name": "v1.2.1.9008",
      "date": "2026-05-10"
    },
    {
      "name": "v1.2.1.9009",
      "date": "2026-05-13"
    },
    {
      "name": "v1.2.1.9010",
      "date": "2026-05-14"
    },
    {
      "name": "v1.2.1.9011",
      "date": "2026-05-16"
    },
    {
      "name": "v1.2.1.9012",
      "date": "2026-05-24"
    }
  ],
  "_topics": [
    "analytics",
    "dataframe",
    "dplyr",
    "duckdb",
    "performance"
  ],
  "_stars": 388,
  "_contributors": [
    {
      "user": "krlmlr",
      "count": 1748,
      "uuid": 1741643
    },
    {
      "user": "maelle",
      "count": 60,
      "uuid": 8360597
    },
    {
      "user": "copilot",
      "count": 18,
      "uuid": 198982749
    },
    {
      "user": "tmonster",
      "count": 12,
      "uuid": 6248601
    },
    {
      "user": "toppyy",
      "count": 6,
      "uuid": 43851547
    },
    {
      "user": "hannes",
      "count": 5,
      "uuid": 227792
    },
    {
      "user": "timtaylor",
      "count": 4,
      "uuid": 43499035
    },
    {
      "user": "joakimlinde",
      "count": 4,
      "uuid": 61517589
    },
    {
      "user": "andreranza",
      "count": 4,
      "uuid": 43607279
    },
    {
      "user": "davisvaughan",
      "count": 2,
      "uuid": 19150088
    },
    {
      "user": "jeroenjanssens",
      "count": 2,
      "uuid": 1368256
    },
    {
      "user": "wibeasley",
      "count": 2,
      "uuid": 1372890
    },
    {
      "user": "hadley",
      "count": 2,
      "uuid": 4196
    },
    {
      "user": "stefanlinner",
      "count": 2,
      "uuid": 83122367
    },
    {
      "user": "luisdva",
      "count": 1,
      "uuid": 5580938
    },
    {
      "user": "mine-cetinkaya-rundel",
      "count": 1,
      "uuid": 5965649
    }
  ],
  "_userbio": {
    "uuid": 105517888,
    "type": "organization",
    "name": "fastverse",
    "description": "An Extensible Suite of High-Performance and Low-Dependency Packages for Statistical Computing and Data Manipulation in R"
  },
  "_downloads": {
    "count": 6473,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/duckplyr"
  },
  "_devurl": "https://github.com/tidyverse/duckplyr",
  "_pkgdown": "https://duckplyr.tidyverse.org",
  "_searchresults": 533,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/duckplyr.html",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/tidyverse/duckplyr",
  "_realowner": "tidyverse",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.0",
      "date": "2023-07-07"
    },
    {
      "version": "0.2.0",
      "date": "2023-09-10"
    },
    {
      "version": "0.2.1",
      "date": "2023-09-17"
    },
    {
      "version": "0.2.2",
      "date": "2023-10-16"
    },
    {
      "version": "0.2.3",
      "date": "2023-11-08"
    },
    {
      "version": "0.3.0",
      "date": "2023-12-11"
    },
    {
      "version": "0.3.1",
      "date": "2024-03-10"
    },
    {
      "version": "0.3.2",
      "date": "2024-03-17"
    },
    {
      "version": "0.4.0",
      "date": "2024-05-21"
    },
    {
      "version": "0.4.1",
      "date": "2024-07-12"
    },
    {
      "version": "1.0.0",
      "date": "2025-02-07"
    },
    {
      "version": "1.0.1",
      "date": "2025-02-27"
    },
    {
      "version": "1.1.0",
      "date": "2025-05-08"
    },
    {
      "version": "1.1.1",
      "date": "2025-08-01"
    },
    {
      "version": "1.1.2",
      "date": "2025-09-18"
    },
    {
      "version": "1.1.3",
      "date": "2025-11-04"
    },
    {
      "version": "1.2.0",
      "date": "2026-02-25"
    },
    {
      "version": "1.2.1",
      "date": "2026-03-10"
    }
  ],
  "_exports": [
    "%>%",
    "as_duckdb_tibble",
    "as_duckplyr_df",
    "as_duckplyr_tibble",
    "as_tbl",
    "compute_csv",
    "compute_parquet",
    "db_exec",
    "df_from_csv",
    "df_from_file",
    "df_from_parquet",
    "df_to_parquet",
    "duckdb_tibble",
    "duckplyr_df_from_csv",
    "duckplyr_df_from_file",
    "duckplyr_df_from_parquet",
    "duckplyr_execute",
    "fallback_config",
    "fallback_purge",
    "fallback_review",
    "fallback_sitrep",
    "fallback_upload",
    "flights_df",
    "is_duckdb_tibble",
    "is_duckplyr_df",
    "last_rel",
    "methods_overwrite",
    "methods_restore",
    "new_relational",
    "new_relexpr",
    "read_csv_duckdb",
    "read_file_duckdb",
    "read_json_duckdb",
    "read_parquet_duckdb",
    "read_sql_duckdb",
    "read_tbl_duckdb",
    "rel_aggregate",
    "rel_alias",
    "rel_distinct",
    "rel_explain",
    "rel_filter",
    "rel_join",
    "rel_limit",
    "rel_names",
    "rel_order",
    "rel_project",
    "rel_set_alias",
    "rel_set_diff",
    "rel_set_intersect",
    "rel_set_symdiff",
    "rel_to_df",
    "rel_union_all",
    "relexpr_comparison",
    "relexpr_constant",
    "relexpr_function",
    "relexpr_reference",
    "relexpr_set_alias",
    "relexpr_window",
    "stats_show"
  ],
  "_help": [
    {
      "page": "anti_join.duckplyr_df",
      "title": "Anti join",
      "topics": [
        "anti_join.duckplyr_df"
      ]
    },
    {
      "page": "arrange.duckplyr_df",
      "title": "Order rows using column values",
      "topics": [
        "arrange.duckplyr_df"
      ]
    },
    {
      "page": "as_tbl",
      "title": "Convert a duckplyr frame to a dbplyr table",
      "topics": [
        "as_tbl"
      ]
    },
    {
      "page": "collect.duckplyr_df",
      "title": "Force conversion to a data frame",
      "topics": [
        "collect.duckplyr_df"
      ]
    },
    {
      "page": "compute_csv",
      "title": "Compute results to a CSV file",
      "topics": [
        "compute_csv",
        "compute_csv.data.frame",
        "compute_csv.duckplyr_df"
      ]
    },
    {
      "page": "compute_parquet",
      "title": "Compute results to a Parquet file",
      "topics": [
        "compute_parquet",
        "compute_parquet.data.frame",
        "compute_parquet.duckplyr_df"
      ]
    },
    {
      "page": "compute.duckplyr_df",
      "title": "Compute results",
      "topics": [
        "compute.duckplyr_df"
      ]
    },
    {
      "page": "config",
      "title": "Configuration options",
      "topics": [
        "config"
      ]
    },
    {
      "page": "count.duckplyr_df",
      "title": "Count the observations in each group",
      "topics": [
        "count.duckplyr_df"
      ]
    },
    {
      "page": "db_exec",
      "title": "Execute a statement for the default connection",
      "topics": [
        "db_exec"
      ]
    },
    {
      "page": "distinct.duckplyr_df",
      "title": "Keep distinct/unique rows",
      "topics": [
        "distinct.duckplyr_df"
      ]
    },
    {
      "page": "duckdb_tibble",
      "title": "duckplyr data frames",
      "topics": [
        "as_duckdb_tibble",
        "duckdb_tibble",
        "is_duckdb_tibble"
      ]
    },
    {
      "page": "explain.duckplyr_df",
      "title": "Explain details of a tbl",
      "topics": [
        "explain.duckplyr_df"
      ]
    },
    {
      "page": "fallback",
      "title": "Fallback to dplyr",
      "topics": [
        "fallback",
        "fallback_config",
        "fallback_purge",
        "fallback_review",
        "fallback_sitrep",
        "fallback_upload"
      ]
    },
    {
      "page": "filter.duckplyr_df",
      "title": "Keep rows that match a condition",
      "topics": [
        "filter.duckplyr_df",
        "filter_out.duckplyr_df"
      ]
    },
    {
      "page": "flights_df",
      "title": "Flight data",
      "topics": [
        "flights_df"
      ]
    },
    {
      "page": "full_join.duckplyr_df",
      "title": "Full join",
      "topics": [
        "full_join.duckplyr_df"
      ]
    },
    {
      "page": "head.duckplyr_df",
      "title": "Return the First Parts of an Object",
      "topics": [
        "head.duckplyr_df"
      ]
    },
    {
      "page": "inner_join.duckplyr_df",
      "title": "Inner join",
      "topics": [
        "inner_join.duckplyr_df"
      ]
    },
    {
      "page": "intersect.duckplyr_df",
      "title": "Intersect",
      "topics": [
        "intersect.duckplyr_df"
      ]
    },
    {
      "page": "last_rel",
      "title": "Retrieve details about the most recent computation",
      "topics": [
        "last_rel"
      ]
    },
    {
      "page": "left_join.duckplyr_df",
      "title": "Left join",
      "topics": [
        "left_join.duckplyr_df"
      ]
    },
    {
      "page": "methods_overwrite",
      "title": "Forward all dplyr methods to duckplyr",
      "topics": [
        "methods_overwrite",
        "methods_restore"
      ]
    },
    {
      "page": "mutate.duckplyr_df",
      "title": "Create, modify, and delete columns",
      "topics": [
        "mutate.duckplyr_df"
      ]
    },
    {
      "page": "new_relational",
      "title": "Relational implementer's interface",
      "topics": [
        "new_relational",
        "rel_aggregate",
        "rel_alias",
        "rel_distinct",
        "rel_explain",
        "rel_filter",
        "rel_join",
        "rel_limit",
        "rel_names",
        "rel_order",
        "rel_project",
        "rel_set_alias",
        "rel_set_diff",
        "rel_set_intersect",
        "rel_set_symdiff",
        "rel_to_df",
        "rel_union_all"
      ]
    },
    {
      "page": "new_relexpr",
      "title": "Relational expressions",
      "topics": [
        "new_relexpr",
        "relexpr_comparison",
        "relexpr_constant",
        "relexpr_function",
        "relexpr_reference",
        "relexpr_set_alias",
        "relexpr_window"
      ]
    },
    {
      "page": "pull.duckplyr_df",
      "title": "Extract a single column",
      "topics": [
        "pull.duckplyr_df"
      ]
    },
    {
      "page": "read_csv_duckdb",
      "title": "Read CSV files using DuckDB",
      "topics": [
        "read_csv_duckdb"
      ]
    },
    {
      "page": "read_file_duckdb",
      "title": "Read files using DuckDB",
      "topics": [
        "read_file_duckdb"
      ]
    },
    {
      "page": "read_json_duckdb",
      "title": "Read JSON files using DuckDB",
      "topics": [
        "read_json_duckdb"
      ]
    },
    {
      "page": "read_parquet_duckdb",
      "title": "Read Parquet files using DuckDB",
      "topics": [
        "read_parquet_duckdb"
      ]
    },
    {
      "page": "read_sql_duckdb",
      "title": "Return SQL query as duckdb_tibble",
      "topics": [
        "read_sql_duckdb"
      ]
    },
    {
      "page": "read_tbl_duckdb",
      "title": "Read a table from a DuckDB database file",
      "topics": [
        "read_tbl_duckdb"
      ]
    },
    {
      "page": "relocate.duckplyr_df",
      "title": "Change column order",
      "topics": [
        "relocate.duckplyr_df"
      ]
    },
    {
      "page": "rename.duckplyr_df",
      "title": "Rename columns",
      "topics": [
        "rename.duckplyr_df"
      ]
    },
    {
      "page": "right_join.duckplyr_df",
      "title": "Right join",
      "topics": [
        "right_join.duckplyr_df"
      ]
    },
    {
      "page": "select.duckplyr_df",
      "title": "Keep or drop columns using their names and types",
      "topics": [
        "select.duckplyr_df"
      ]
    },
    {
      "page": "semi_join.duckplyr_df",
      "title": "Semi join",
      "topics": [
        "semi_join.duckplyr_df"
      ]
    },
    {
      "page": "setdiff.duckplyr_df",
      "title": "Set difference",
      "topics": [
        "setdiff.duckplyr_df"
      ]
    },
    {
      "page": "slice_head.duckplyr_df",
      "title": "Subset rows using their positions",
      "topics": [
        "slice_head.duckplyr_df"
      ]
    },
    {
      "page": "stats_show",
      "title": "Show stats",
      "topics": [
        "stats_show"
      ]
    },
    {
      "page": "summarise.duckplyr_df",
      "title": "Summarise each group down to one row",
      "topics": [
        "summarise.duckplyr_df"
      ]
    },
    {
      "page": "symdiff.duckplyr_df",
      "title": "Symmetric difference",
      "topics": [
        "symdiff.duckplyr_df"
      ]
    },
    {
      "page": "transmute.duckplyr_df",
      "title": "Create, modify, and delete columns",
      "topics": [
        "transmute.duckplyr_df"
      ]
    },
    {
      "page": "union_all.duckplyr_df",
      "title": "Union of all",
      "topics": [
        "union_all.duckplyr_df"
      ]
    },
    {
      "page": "union.duckplyr_df",
      "title": "Union",
      "topics": [
        "union.duckplyr_df"
      ]
    },
    {
      "page": "unsupported",
      "title": "Verbs not implemented in duckplyr",
      "topics": [
        "unsupported"
      ]
    }
  ],
  "_pkglogo": "https://github.com/tidyverse/duckplyr/raw/HEAD/man/figures/logo.png",
  "_readme": "https://github.com/tidyverse/duckplyr/raw/HEAD/README.md",
  "_rundeps": [
    "cachem",
    "cli",
    "collections",
    "DBI",
    "dplyr",
    "duckdb",
    "fastmap",
    "generics",
    "glue",
    "jsonlite",
    "lifecycle",
    "magrittr",
    "memoise",
    "pillar",
    "pkgconfig",
    "R6",
    "rlang",
    "tibble",
    "tidyselect",
    "utf8",
    "vctrs",
    "withr"
  ],
  "_vignettes": [
    {
      "source": "large.Rmd",
      "filename": "large.html",
      "title": "Large data",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Introduction",
        "To duckplyr",
        "From files",
        "From DuckDB",
        "Materialization",
        "To files",
        "Memory usage",
        "The big picture"
      ],
      "created": "2025-01-27 15:48:43",
      "modified": "2025-04-11 18:01:07",
      "commits": 12
    },
    {
      "source": "prudence.Rmd",
      "filename": "prudence.html",
      "title": "Memory protection: controlling automatic materialization",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Introduction",
        "Eager and lazy computation",
        "Example",
        "Comparison",
        "Prudence",
        "Concept",
        "Enforcing DuckDB operation",
        "From stingy to lavish",
        "Thrift",
        "File ingestion and custom limits",
        "Conclusion"
      ],
      "created": "2025-02-01 05:09:25",
      "modified": "2025-09-16 19:07:30",
      "commits": 10
    },
    {
      "source": "fallback.Rmd",
      "filename": "fallback.html",
      "title": "Fallback to dplyr",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Introduction",
        "DuckDB mode",
        "Relation objects",
        "Help from dplyr",
        "Enforce DuckDB operation",
        "Configure fallbacks",
        "Conclusion"
      ],
      "created": "2025-02-01 07:50:03",
      "modified": "2025-04-11 18:01:07",
      "commits": 7
    },
    {
      "source": "limits.Rmd",
      "filename": "limits.html",
      "title": "Translations",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Data types",
        "Verbs",
        "Functions within verbs",
        "Parentheses",
        "Comparison operators",
        "Basic arithmetics",
        "Math functions",
        "Logical operators",
        "Branching and conversion",
        "String manipulation",
        "Date manipulation",
        "Aggregation",
        "Shifting",
        "Ranking",
        "Special cases",
        "Contributing",
        "Known incompatibilities",
        "Output order stability",
        "sum()",
        "Empty vectors in aggregate functions",
        "min() and max() for logical input",
        "n_distinct() and multiple arguments",
        "is.na() and NaN values",
        "Row names",
        "Other differences"
      ],
      "created": "2024-12-14 06:57:36",
      "modified": "2025-11-26 17:20:07",
      "commits": 17
    },
    {
      "source": "duckdb.Rmd",
      "filename": "duckdb.html",
      "title": "Interoperability with DuckDB and dbplyr",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Introduction",
        "From duckplyr to dbplyr",
        "Call arbitrary functions in duckplyr",
        "Conclusion"
      ],
      "created": "2025-04-11 18:01:07",
      "modified": "2025-04-17 17:55:32",
      "commits": 2
    },
    {
      "source": "developers.Rmd",
      "filename": "developers.html",
      "title": "Selective use of duckplyr",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Introduction",
        "External data with explicit qualification",
        "Restoring dplyr methods",
        "Own data",
        "In other packages"
      ],
      "created": "2024-12-14 05:27:20",
      "modified": "2025-04-11 18:01:07",
      "commits": 17
    },
    {
      "source": "telemetry.Rmd",
      "filename": "telemetry.html",
      "title": "Telemetry",
      "engine": "knitr::rmarkdown",
      "headings": [],
      "created": "2025-01-27 15:48:43",
      "modified": "2025-02-07 04:44:38",
      "commits": 4
    },
    {
      "source": "extend.Rmd",
      "filename": "extend.html",
      "title": "Implementer's interface",
      "engine": "knitr::rmarkdown",
      "headings": [],
      "created": "2025-01-27 15:48:43",
      "modified": "2025-01-27 15:48:43",
      "commits": 1
    }
  ],
  "_score": 13.46111829278964,
  "_indexed": false,
  "_nocasepkg": "duckplyr",
  "_universes": [
    "fastverse"
  ],
  "_indexurl": "https://tidyverse.r-universe.dev/duckplyr",
  "_previous": "1.2.1.9011",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.2.1.9012",
      "date": "2026-05-24T06:40:39.000Z",
      "distro": "noble",
      "commit": "fa9ae49cac0257b2f4d19f6577875c4470b0b6d8",
      "fileid": "4b171ca7484d8e3fdbf11654247fa945c45e766be55fad5926339bb5fe88c062",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/fastverse/actions/runs/26354130575"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.2.1.9012",
      "date": "2026-05-24T06:40:42.000Z",
      "distro": "noble",
      "commit": "fa9ae49cac0257b2f4d19f6577875c4470b0b6d8",
      "fileid": "b260f93435db3ffa9d0f6098776b2f1150872ae525b7be168e0345dce97a83af",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/fastverse/actions/runs/26354130575"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.2.1.9012",
      "date": "2026-05-24T06:40:26.000Z",
      "commit": "fa9ae49cac0257b2f4d19f6577875c4470b0b6d8",
      "fileid": "e35800392c66e909b5e9172c3200c4753cafb10fead82de7d619e3473ea450a5",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/fastverse/actions/runs/26354130575"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.2.1.9012",
      "date": "2026-05-24T06:41:37.000Z",
      "commit": "fa9ae49cac0257b2f4d19f6577875c4470b0b6d8",
      "fileid": "83fc45f4414d3b268b02e996611d4b0feb59c19b0050f9abdc5df228a5b6fba2",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/fastverse/actions/runs/26354130575"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.2.1.9012",
      "date": "2026-05-24T06:41:06.000Z",
      "commit": "fa9ae49cac0257b2f4d19f6577875c4470b0b6d8",
      "fileid": "8a8f8125b1c5781d80a9dcf3bc359a612d6bd0b25b071056cf5c987e7a1c468d",
      "status": "success",
      "buildurl": "https://github.com/r-universe/fastverse/actions/runs/26354130575"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.2.1.9012",
      "date": "2026-05-24T06:39:42.000Z",
      "commit": "fa9ae49cac0257b2f4d19f6577875c4470b0b6d8",
      "fileid": "3a7480489d975da2d1df51650d4a0da1ecf85162380bdde8d630ac84ea816be6",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/fastverse/actions/runs/26354130575"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.2.1.9012",
      "date": "2026-05-24T06:39:41.000Z",
      "commit": "fa9ae49cac0257b2f4d19f6577875c4470b0b6d8",
      "fileid": "3121addc32431838ac6d7cba200be6da7c6782494af4c1fadb19043b4c7038a8",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/fastverse/actions/runs/26354130575"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "1.2.1.9012",
      "date": "2026-05-24T06:39:30.000Z",
      "commit": "fa9ae49cac0257b2f4d19f6577875c4470b0b6d8",
      "fileid": "4032b33ad986fd5c058870d8f43522c2612331663a453e0841b43c1373c15938",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/fastverse/actions/runs/26354130575"
    }
  ]
}