{
  "_id": "6a12a901acfb0bcc41d15821",
  "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://tidyverse.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:51:22 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": "50567ad885899d20575ace12fcb956a9",
  "_user": "tidyverse",
  "_type": "src",
  "_file": "duckplyr_1.2.1.9012.tar.gz",
  "_fileid": "be4b7b6a18aa7423a2a9224b4fe181f9293d03d1cc663785ca5b53edddf3e8e0",
  "_filesize": 1167860,
  "_sha256": "be4b7b6a18aa7423a2a9224b4fe181f9293d03d1cc663785ca5b53edddf3e8e0",
  "_created": "2026-05-24T06:51:22.000Z",
  "_published": "2026-05-24T07:30:08.979Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77578494578,
      "time": 259,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7183042377"
    },
    {
      "job": 77578494574,
      "time": 272,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183043447"
    },
    {
      "job": 77578494576,
      "time": 140,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7183269118"
    },
    {
      "job": 77578494580,
      "time": 138,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183269775"
    },
    {
      "job": 77578295898,
      "time": 230,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183015831"
    },
    {
      "job": 77578494583,
      "time": 124,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183028672"
    },
    {
      "job": 77578494586,
      "time": 238,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7183040156"
    },
    {
      "job": 77578494584,
      "time": 233,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7183039468"
    },
    {
      "job": 77578494587,
      "time": 286,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183043518"
    }
  ],
  "_buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354364971",
  "_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": true,
  "_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": 22032646,
    "type": "organization",
    "name": "tidyverse",
    "description": "The tidyverse is a collection of R packages that share common principles and are designed to work together seamlessly"
  },
  "_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": true,
  "_nocasepkg": "duckplyr",
  "_universes": [
    "tidyverse",
    "krlmlr"
  ],
  "_previous": "1.2.1.9011",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.2.1.9012",
      "date": "2026-05-24T06:53:48.000Z",
      "distro": "noble",
      "commit": "fa9ae49cac0257b2f4d19f6577875c4470b0b6d8",
      "fileid": "288bd74f7aee4b9ede3e5043aa14d57a9ffc6f97097b55a86b562fd345a735f5",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354364971"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.2.1.9012",
      "date": "2026-05-24T06:53:59.000Z",
      "distro": "noble",
      "commit": "fa9ae49cac0257b2f4d19f6577875c4470b0b6d8",
      "fileid": "5671c9f094a075fd6b7f56a1a34f64899c0fb777abfe854777f23e8f2402f47b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354364971"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.2.1.9012",
      "date": "2026-05-24T07:28:26.000Z",
      "commit": "fa9ae49cac0257b2f4d19f6577875c4470b0b6d8",
      "fileid": "58adc30be0a8cf5549e3fd17acb3ac578ded218cb3d8f500b1a625709bb69375",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354364971"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.2.1.9012",
      "date": "2026-05-24T07:28:29.000Z",
      "commit": "fa9ae49cac0257b2f4d19f6577875c4470b0b6d8",
      "fileid": "02027ed0302af6c6b85c95e102e8b358049d300709ca4452eebda291c7d5dc6c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354364971"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.2.1.9012",
      "date": "2026-05-24T06:53:49.000Z",
      "commit": "fa9ae49cac0257b2f4d19f6577875c4470b0b6d8",
      "fileid": "b7467488e97e924764983edd6d5b730033d9b4841af0e4d7809d5abf73fdd132",
      "status": "success",
      "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354364971"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.2.1.9012",
      "date": "2026-05-24T06:52:47.000Z",
      "commit": "fa9ae49cac0257b2f4d19f6577875c4470b0b6d8",
      "fileid": "ca622df54857305f8fa59fb1419a188f3f4bd47d6e9a89079eeb503c78e89df0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354364971"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.2.1.9012",
      "date": "2026-05-24T06:52:41.000Z",
      "commit": "fa9ae49cac0257b2f4d19f6577875c4470b0b6d8",
      "fileid": "889f9530b08e9c9236e267962d466db634dbf45d33e1b757ad7f0507fbf3ab53",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354364971"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "1.2.1.9012",
      "date": "2026-05-24T06:52:49.000Z",
      "commit": "fa9ae49cac0257b2f4d19f6577875c4470b0b6d8",
      "fileid": "ede9d831b5167ee58c5af8978ba3578664ef9bcceca24a59ae7bda51aab732ad",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354364971"
    }
  ]
}