{
  "_id": "6ab6643d99f7aa8c6aa2e4af",
  "Package": "RClickhouse",
  "Type": "Package",
  "Title": "'Yandex Clickhouse' Interface for R with Basic 'dplyr' Support",
  "Version": "0.6.12",
  "Encoding": "UTF-8",
  "Authors@R": "c(\nperson(\"Christian\", \"Hotz-Behofsits\", email = \"christian.hotz-behofsits@wu.ac.at\", role = c(\"aut\", \"cre\")),\nperson(\"Daniel\", \"Winkler\", email = \"daniel.winkler@wu.ac.at\", role = c(\"aut\")),\nperson(\"Luca\", \"Rauchenberger\", email = \"luca.rauchenberger@wu.ac.at\", role = c(\"aut\")),\nperson(\"Peter\", \"Knaus\", email = \"peter.knaus@wu.ac.at\", role = c(\"aut\")),\nperson(\"Clemens\", \"Danninger\", email = \"cran@b8000h.org\", role = c(\"aut\")),\nperson(\"Daria\", \"Yudaeva\", email = \"daria.yudaeva@wu.ac.at\", role = c(\"aut\")),\nperson(\"Simon\", \"Stiebellehner\", email = \"simon.stiebellehner@gmail.com\", role = c(\"aut\")),\nperson(\"Dan\", \"Egnor\", role = c(\"aut\")),\nperson(\"Vlad\", \"Losev\", email = \"vladl@google.com\", role = c(\"aut\")),\nperson(\"Keith\", \"Ray\", email = \"keith.ray@gmail.com\", role = c(\"aut\")),\nperson(\"Zhanyong\", \"Wan\", email = \"wan@google.com\", role = c(\"aut\")),\nperson(\"Markus\", \"Heule\", email = \"mheule@google.com\", role = c(\"aut\")),\nperson(\"Oliver\", \"Flasch\", email = \"oflasch@gmail.com\", role = c(\"aut\")),\nperson(family = \"Google\", role = c(\"cph\")),\nperson(\"Yann\", \"Collet\", role = c(\"cph\", \"aut\"), comment = \"Yann Collet is the author and copyright holder of 'lz4'\")\n)",
  "Description": "'Yandex Clickhouse' (<https://clickhouse.com/>) is a\nhigh-performance relational column-store database to enable big\ndata exploration and 'analytics' scaling to petabytes of data.\nMethods are provided that enable working with 'Yandex\nClickhouse' databases via 'DBI' methods and using\n'dplyr'/'dbplyr' idioms.",
  "License": "GPL-2",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.3.2",
  "NeedsCompilation": "yes",
  "Collate": "'RcppExports.R' 'RClickhouse.R' 'ClickhouseDriver.R'\n'ClickhouseConnection.R' 'ClickhouseResult.R'\n'dbplyr-helpers.R' 'dplyr.R' 'zzz.R'",
  "URL": "https://github.com/IMSMWU/RClickhouse",
  "BugReports": "https://github.com/IMSMWU/RClickhouse/issues",
  "Config/pak/sysreqs": "libicu-dev",
  "Repository": "https://imsmwu.r-universe.dev",
  "Date/Publication": "2026-08-26 13:51:59 UTC",
  "RemoteUrl": "https://github.com/imsmwu/rclickhouse",
  "RemoteRef": "HEAD",
  "RemoteSha": "16d24312e5dea025b128461676f0d6af059e793a",
  "Packaged": {
    "Date": "2026-09-25 11:59:16 UTC",
    "User": "root"
  },
  "Author": "Christian Hotz-Behofsits [aut, cre],\nDaniel Winkler [aut],\nLuca Rauchenberger [aut],\nPeter Knaus [aut],\nClemens Danninger [aut],\nDaria Yudaeva [aut],\nSimon Stiebellehner [aut],\nDan Egnor [aut],\nVlad Losev [aut],\nKeith Ray [aut],\nZhanyong Wan [aut],\nMarkus Heule [aut],\nOliver Flasch [aut],\nGoogle [cph],\nYann Collet [cph, aut] (Yann Collet is the author and copyright holder\nof 'lz4')",
  "Maintainer": "Christian Hotz-Behofsits <christian.hotz-behofsits@wu.ac.at>",
  "_user": "imsmwu",
  "_type": "src",
  "_file": "RClickhouse_0.6.12.tar.gz",
  "_fileid": "https://r2.ropensci.org/2fbffc3421bf55a827a939fa4d3a71e8110d19a83e1d2fc2a4c38ebc7addca19",
  "_filesize": 223698,
  "_sha256": "2fbffc3421bf55a827a939fa4d3a71e8110d19a83e1d2fc2a4c38ebc7addca19",
  "_expires": "2027-01-03T12:08:27.000Z",
  "_created": "2026-09-25T11:59:16.000Z",
  "_published": "2026-09-25T12:08:29.272Z",
  "_jobs": [
    {
      "job": 108062638196,
      "time": 177,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "10862551953"
    },
    {
      "job": 108062638075,
      "time": 223,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "10862261701"
    },
    {
      "job": 108062638165,
      "time": 170,
      "config": "linux-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10862536978"
    },
    {
      "job": 108062638292,
      "time": 220,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10863116612"
    },
    {
      "job": 108062638145,
      "time": 173,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "10863101447"
    },
    {
      "job": 108062638113,
      "time": 480,
      "config": "macos-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "10863002360"
    },
    {
      "job": 108062638172,
      "time": 234,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10863051638"
    },
    {
      "job": 108062638114,
      "time": 478,
      "config": "macos-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10862232156"
    },
    {
      "job": 108061347566,
      "time": 270,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10862131311"
    },
    {
      "job": 108062638139,
      "time": 161,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "10862586924"
    },
    {
      "job": 108062638136,
      "time": 430,
      "config": "windows-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "10862972409"
    },
    {
      "job": 108062638231,
      "time": 206,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "10862956755"
    },
    {
      "job": 108062638190,
      "time": 170,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "10863071509"
    },
    {
      "job": 108062638379,
      "time": 401,
      "config": "windows-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10862867330"
    },
    {
      "job": 108062638276,
      "time": 186,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10862141712"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/imsmwu/actions/runs/36132018847",
  "_status": "success",
  "_upstream": "https://github.com/imsmwu/rclickhouse",
  "_commit": {
    "id": "16d24312e5dea025b128461676f0d6af059e793a",
    "author": "Christian Hotz-Behofsits <chris.hotz.behofsits@gmail.com>",
    "committer": "Christian Hotz-Behofsits <chris.hotz.behofsits@gmail.com>",
    "message": "Bump version to 0.6.12 and update cran-comments\n",
    "time": 1787752319
  },
  "_maintainer": {
    "name": "Christian Hotz-Behofsits",
    "email": "christian.hotz-behofsits@wu.ac.at",
    "login": "inkrement",
    "twitter": "@inkrement",
    "description": "Assistent professor @ WU Vienna. Background in software & information engineering; now quantitative marketing.",
    "uuid": 604528
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 3.6.2",
      "role": "Depends"
    },
    {
      "package": "Rcpp",
      "role": "LinkingTo"
    },
    {
      "package": "dplyr",
      "version": ">= 1.1.0",
      "role": "Imports"
    },
    {
      "package": "dbplyr",
      "version": ">= 2.0.0",
      "role": "Imports"
    },
    {
      "package": "methods",
      "version": ">= 3.3.2",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "version": ">= 1.0.0",
      "role": "Imports"
    },
    {
      "package": "Rcpp",
      "version": ">= 0.11.0",
      "role": "Imports"
    },
    {
      "package": "bit64",
      "role": "Imports"
    },
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "testthat",
      "role": "Suggests"
    }
  ],
  "_owner": "imsmwu",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-26",
      "n": 3
    },
    {
      "week": "2026-35",
      "n": 2
    }
  ],
  "_tags": [
    {
      "name": "v0.6.12",
      "date": "2026-08-26"
    }
  ],
  "_topics": [
    "clickhouse",
    "clickhouse-database",
    "dbi-interface",
    "dplyr",
    "dplyr-sql-backends",
    "cpp"
  ],
  "_stars": 98,
  "_contributors": [
    {
      "user": "inkrement",
      "count": 203,
      "uuid": 604528
    },
    {
      "user": "artpaul",
      "count": 147,
      "uuid": 1533100
    },
    {
      "user": "v5r",
      "count": 109,
      "uuid": 4190036
    },
    {
      "user": "dwinkler1",
      "count": 32,
      "uuid": 22460147
    },
    {
      "user": "tridelt",
      "count": 26,
      "uuid": 24197322
    },
    {
      "user": "alexey-milovidov",
      "count": 16,
      "uuid": 18581488
    },
    {
      "user": "abyss7",
      "count": 11,
      "uuid": 5627721
    },
    {
      "user": "sistema987",
      "count": 8,
      "uuid": 234894230
    },
    {
      "user": "enmk",
      "count": 5,
      "uuid": 1110183
    },
    {
      "user": "filimonov",
      "count": 4,
      "uuid": 1549571
    },
    {
      "user": "krlmlr",
      "count": 4,
      "uuid": 1741643
    },
    {
      "user": "ciberst",
      "count": 4,
      "uuid": 11655210
    },
    {
      "user": "adubovikov",
      "count": 3,
      "uuid": 4513061
    },
    {
      "user": "pavel-odintsov",
      "count": 3,
      "uuid": 2744166
    },
    {
      "user": "clrusby",
      "count": 3,
      "uuid": 28167577
    },
    {
      "user": "dariayudaeva",
      "count": 3,
      "uuid": 98695842
    },
    {
      "user": "aiwhj",
      "count": 2,
      "uuid": 16408168
    },
    {
      "user": "mkyhos",
      "count": 2,
      "uuid": 33769439
    },
    {
      "user": "huaijiang",
      "count": 2,
      "uuid": 1789093
    },
    {
      "user": "cyfdecyf",
      "count": 2,
      "uuid": 344294
    },
    {
      "user": "alicjagrzadziel",
      "count": 1,
      "uuid": 39812189
    },
    {
      "user": "brick0",
      "count": 1,
      "uuid": 3419726
    },
    {
      "user": "xomachine",
      "count": 1,
      "uuid": 3051015
    },
    {
      "user": "hatarist",
      "count": 1,
      "uuid": 2741725
    },
    {
      "user": "blinkov",
      "count": 1,
      "uuid": 623861
    },
    {
      "user": "testtridelt",
      "count": 1,
      "uuid": 71324785
    },
    {
      "user": "alex-zaitsev",
      "count": 1,
      "uuid": 25770686
    },
    {
      "user": "dgrr",
      "count": 1,
      "uuid": 10146748
    },
    {
      "user": "lzmhhh123",
      "count": 1,
      "uuid": 26040259
    },
    {
      "user": "njlr",
      "count": 1,
      "uuid": 1577531
    },
    {
      "user": "ingvaror",
      "count": 1,
      "uuid": 162822457
    }
  ],
  "_userbio": {
    "uuid": 15648815,
    "type": "organization",
    "name": "IMSM WU Vienna",
    "followers": 4,
    "description": "Institute for Interactive Marketing and Social Media"
  },
  "_downloads": {
    "count": 2545,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RClickhouse"
  },
  "_devurl": "https://github.com/imsmwu/rclickhouse",
  "_searchresults": 26,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/RClickhouse.html"
  ],
  "_homeurl": "https://github.com/imsmwu/rclickhouse",
  "_realowner": "imsmwu",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.3.0",
      "date": "2017-11-26"
    },
    {
      "version": "0.4.0",
      "date": "2018-01-20"
    },
    {
      "version": "0.5",
      "date": "2020-01-29"
    },
    {
      "version": "0.5.1",
      "date": "2020-01-30"
    },
    {
      "version": "0.5.2",
      "date": "2020-03-06"
    },
    {
      "version": "0.6.0",
      "date": "2022-01-13"
    },
    {
      "version": "0.6.3",
      "date": "2022-03-08"
    },
    {
      "version": "0.6.4",
      "date": "2022-06-12"
    },
    {
      "version": "0.6.7",
      "date": "2023-04-02"
    },
    {
      "version": "0.6.8",
      "date": "2023-08-21"
    },
    {
      "version": "0.6.9",
      "date": "2024-01-19"
    },
    {
      "version": "0.6.10",
      "date": "2025-02-26"
    },
    {
      "version": "0.6.11",
      "date": "2026-06-23"
    },
    {
      "version": "0.6.12",
      "date": "2026-08-26"
    }
  ],
  "_exports": [
    "clickhouse",
    "dbBegin",
    "dbClearResult",
    "dbColumnInfo",
    "dbCommit",
    "dbConnect",
    "dbDataType",
    "dbDisconnect",
    "dbExistsTable",
    "dbFetch",
    "dbGetInfo",
    "dbGetRowCount",
    "dbGetRowsAffected",
    "dbGetStatement",
    "dbHasCompleted",
    "dbIsValid",
    "dbListFields",
    "dbListTables",
    "dbplyr_case_sensitive",
    "dbQuoteIdentifier",
    "dbQuoteString",
    "dbReadTable",
    "dbRemoveTable",
    "dbRollback",
    "dbSendQuery",
    "dbUnloadDriver",
    "fix_dbplyr",
    "loadConfig",
    "show"
  ],
  "_help": [
    {
      "page": "dbplyr_case_sensitive",
      "title": "Get dbplyr to work with Clickhouse",
      "topics": [
        "dbplyr_case_sensitive"
      ]
    },
    {
      "page": "fix_dbplyr",
      "title": "Return to dbplyrs original behavior",
      "topics": [
        "fix_dbplyr"
      ]
    },
    {
      "page": "RClickhouse",
      "title": "RClickhouse",
      "topics": [
        "RClickhouse-package",
        "RClickhouse"
      ]
    },
    {
      "page": "sql_variant",
      "title": "adapted from dbplyr",
      "topics": [
        "sql_aggregate",
        "sql_aggregate_2"
      ]
    }
  ],
  "_rundeps": [
    "bit",
    "bit64",
    "blob",
    "cli",
    "cpp11",
    "DBI",
    "dbplyr",
    "dplyr",
    "generics",
    "glue",
    "lifecycle",
    "magrittr",
    "pillar",
    "pkgconfig",
    "purrr",
    "R6",
    "Rcpp",
    "rlang",
    "stringi",
    "stringr",
    "tibble",
    "tidyr",
    "tidyselect",
    "utf8",
    "vctrs",
    "withr"
  ],
  "_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": 6.590038460719735,
  "_indexed": true,
  "_nocasepkg": "rclickhouse",
  "_universes": [
    "imsmwu",
    "inkrement"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.6.12",
      "date": "2026-09-25T12:02:08.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "16d24312e5dea025b128461676f0d6af059e793a",
      "fileid": "https://r2.ropensci.org/5ba182531950563f55a052f36cc578ba72b7e2d0931b416301275e110f005d41",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/36132018847"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.6.12",
      "date": "2026-09-25T12:02:42.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "16d24312e5dea025b128461676f0d6af059e793a",
      "fileid": "https://r2.ropensci.org/0a5775e2793188655b74893dee1a97413876ba78b0696b33668a5e2e3d31dec1",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/36132018847"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.6.12",
      "date": "2026-09-25T12:02:04.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "16d24312e5dea025b128461676f0d6af059e793a",
      "fileid": "https://r2.ropensci.org/88405e51013a37d19c8e255ebc532fdb2b60b0815125c10f249b7e14c66d6499",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/36132018847"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.6.12",
      "date": "2026-09-25T12:02:42.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "16d24312e5dea025b128461676f0d6af059e793a",
      "fileid": "https://r2.ropensci.org/a0185d1937dbd3bdf54c915152d8a8f160c46734c79f68e2b8c12f52f81adb59",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/36132018847"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.6.12",
      "date": "2026-09-25T12:01:58.000Z",
      "arch": "aarch64",
      "commit": "16d24312e5dea025b128461676f0d6af059e793a",
      "fileid": "https://r2.ropensci.org/2156d1ca8e2ad707bf8f87d65a2e3e81ded59f88fa8cf15d46488125b02c80d8",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/36132018847"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.6.12",
      "date": "2026-09-25T12:04:43.000Z",
      "arch": "x86_64",
      "commit": "16d24312e5dea025b128461676f0d6af059e793a",
      "fileid": "https://r2.ropensci.org/b30d7cdf5cfe9527db6e017dd99f2e698e7f772c0c5744f152bbda70c5417270",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/36132018847"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.6.12",
      "date": "2026-09-25T12:02:13.000Z",
      "arch": "aarch64",
      "commit": "16d24312e5dea025b128461676f0d6af059e793a",
      "fileid": "https://r2.ropensci.org/c30257b594b0fa2597b747db85dd4742ddc7b71386badf796771f8fbf0736ac2",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/36132018847"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.6.12",
      "date": "2026-09-25T12:04:21.000Z",
      "arch": "x86_64",
      "commit": "16d24312e5dea025b128461676f0d6af059e793a",
      "fileid": "https://r2.ropensci.org/b1951ed96c835bda80c8ae818f6ca31a788f87a806b7d6cf11cae4688d3bfc08",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/36132018847"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.6.12",
      "date": "2026-09-25T12:02:09.000Z",
      "arch": "emscripten",
      "commit": "16d24312e5dea025b128461676f0d6af059e793a",
      "fileid": "https://r2.ropensci.org/618d09767346d9994aef2a0f41eb078186d4fdbfbc1336cd2dfb6a6abdc92e60",
      "status": "success",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/36132018847"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.6.12",
      "date": "2026-09-25T12:05:16.000Z",
      "arch": "aarch64",
      "commit": "16d24312e5dea025b128461676f0d6af059e793a",
      "fileid": "https://r2.ropensci.org/947298953c22a590b9bc41e1babf36a67cad0b12f3e69ff0bb6a3a1ab2011b93",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/36132018847"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.6.12",
      "date": "2026-09-25T12:00:51.000Z",
      "arch": "x86_64",
      "commit": "16d24312e5dea025b128461676f0d6af059e793a",
      "fileid": "https://r2.ropensci.org/00586433cdddafd602ebd626308604d0269b0c7731eb63f401e14468469a7354",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/36132018847"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.6.12",
      "date": "2026-09-25T12:01:00.000Z",
      "arch": "x86_64",
      "commit": "16d24312e5dea025b128461676f0d6af059e793a",
      "fileid": "https://r2.ropensci.org/a666a1abcbe33de4e2f1695ebbb14845f6d4c0f3f8d67ffbbe4ad3d22f0efee7",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/36132018847"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.6.12",
      "date": "2026-09-25T12:04:36.000Z",
      "arch": "aarch64",
      "commit": "16d24312e5dea025b128461676f0d6af059e793a",
      "fileid": "https://r2.ropensci.org/d9981ff4b6605a39aaba4a10ba27ba27eb65f6bb52a6468ad7571c2d5adb670d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/36132018847"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.6.12",
      "date": "2026-09-25T12:01:00.000Z",
      "arch": "x86_64",
      "commit": "16d24312e5dea025b128461676f0d6af059e793a",
      "fileid": "https://r2.ropensci.org/f4923d156084fcc2f47f53cfcdc1b2e42c96c443bb4508cb18a236e4351a2c03",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/36132018847"
    }
  ]
}