{
  "_id": "6ac9ef48fe5cc25786e82fb7",
  "Package": "ClickHouseHTTP",
  "Type": "Package",
  "Title": "A Simple HTTP Database Interface to 'ClickHouse'",
  "Version": "1.1.2",
  "Authors@R": "c(\nperson(\n\"Patrice\", \"Godard\",\nrole = c(\"aut\", \"cre\",\"cph\"),\nemail = \"patrice.godard@gmail.com\",\ncomment = c(ORCID = \"0000-0001-6257-9730\")\n),\nperson(\n\"Eusebiu\", \"Marcu\",\nrole = \"ctb\",\nemail = \"marcueusebiu@gmail.com\"\n)\n)",
  "Description": "'ClickHouse' (<https://clickhouse.com/>) is an\nopen-source, high performance columnar OLAP (online analytical\nprocessing of queries) database management system for real-time\nanalytics using SQL. This 'DBI' backend relies on the\n'ClickHouse' HTTP interface and support HTTPS protocol.",
  "URL": "https://patzaw.github.io/ClickHouseHTTP/,\nhttps://github.com/patzaw/ClickHouseHTTP/",
  "BugReports": "https://github.com/patzaw/ClickHouseHTTP/issues",
  "Roxygen": "list(markdown = TRUE)",
  "License": "GPL-3",
  "Encoding": "UTF-8",
  "Config/roxygen2/version": "8.1.0",
  "Config/testthat/edition": "3",
  "VignetteBuilder": "knitr",
  "Config/pak/sysreqs": "cmake libssl-dev",
  "Repository": "https://patzaw.r-universe.dev",
  "Date/Publication": "2026-10-10 05:53:53 UTC",
  "RemoteUrl": "https://github.com/patzaw/clickhousehttp",
  "RemoteRef": "HEAD",
  "RemoteSha": "055d0194caf6fac413523e08478172b7db7cdb53",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-10 07:36:40 UTC",
    "User": "root"
  },
  "Author": "Patrice Godard [aut, cre, cph] (ORCID:\n<https://orcid.org/0000-0001-6257-9730>),\nEusebiu Marcu [ctb]",
  "Maintainer": "Patrice Godard <patrice.godard@gmail.com>",
  "_user": "patzaw",
  "_type": "src",
  "_file": "ClickHouseHTTP_1.1.2.tar.gz",
  "_fileid": "https://r2.ropensci.org/1fee439d9a9f207a6cdc3c52f18005d9e5e18e8a6dd1a8849b86a796537daac0",
  "_filesize": 226908,
  "_sha256": "1fee439d9a9f207a6cdc3c52f18005d9e5e18e8a6dd1a8849b86a796537daac0",
  "_expires": "2027-01-18T07:54:47.000Z",
  "_created": "2026-10-10T07:36:40.000Z",
  "_published": "2026-10-10T07:54:48.626Z",
  "_buildurl": "https://github.com/r-universe/patzaw/actions/runs/38034759572",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 114163593303,
      "time": 149,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11664200643"
    },
    {
      "job": 114163593286,
      "time": 130,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11664305067"
    },
    {
      "job": 114163593282,
      "time": 86,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11663997141"
    },
    {
      "job": 114163593270,
      "time": 82,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11664446819"
    },
    {
      "job": 114162822467,
      "time": 267,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11664340219"
    },
    {
      "job": 114163593250,
      "time": 97,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11663800693"
    },
    {
      "job": 114163593362,
      "time": 67,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11663930142"
    },
    {
      "job": 114163593244,
      "time": 87,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11663430964"
    },
    {
      "job": 114163593295,
      "time": 76,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11664030616"
    }
  ],
  "_upstream": "https://github.com/patzaw/clickhousehttp",
  "_commit": {
    "id": "055d0194caf6fac413523e08478172b7db7cdb53",
    "author": "Patrice Godard <patrice.godard@angelinipharma.com>",
    "committer": "Patrice Godard <patrice.godard@angelinipharma.com>",
    "message": "homepage structure\n",
    "time": 1791611633
  },
  "_maintainer": {
    "name": "Patrice Godard",
    "email": "patrice.godard@gmail.com",
    "login": "patzaw",
    "linkedin": "in/patrice-godard-65a25920",
    "orcid": "0000-0001-6257-9730",
    "description": "Data scientist and bioinformatician. Strong experience in multiomics data analysis applied to pharmaceutical  research.",
    "uuid": 9802306
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1",
      "role": "Depends"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "version": ">= 0.3.0",
      "role": "Imports"
    },
    {
      "package": "httr2",
      "role": "Imports"
    },
    {
      "package": "jsonlite",
      "role": "Imports"
    },
    {
      "package": "arrow",
      "role": "Imports"
    },
    {
      "package": "data.table",
      "role": "Imports"
    },
    {
      "package": "stats",
      "role": "Imports"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "dplyr",
      "role": "Suggests"
    },
    {
      "package": "dbplyr",
      "role": "Suggests"
    },
    {
      "package": "stringi",
      "role": "Suggests"
    },
    {
      "package": "stringr",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "withr",
      "role": "Suggests"
    }
  ],
  "_owner": "patzaw",
  "_selfowned": true,
  "_usedby": 1,
  "_updates": [
    {
      "week": "2026-20",
      "n": 6
    },
    {
      "week": "2026-21",
      "n": 2
    },
    {
      "week": "2026-38",
      "n": 2
    },
    {
      "week": "2026-39",
      "n": 5
    },
    {
      "week": "2026-40",
      "n": 9
    },
    {
      "week": "2026-41",
      "n": 3
    }
  ],
  "_tags": [
    {
      "name": "v1.0.0",
      "date": "2026-05-18"
    },
    {
      "name": "v1.1.2",
      "date": "2026-10-02"
    }
  ],
  "_stars": 18,
  "_contributors": [
    {
      "user": "patzaw",
      "count": 31,
      "uuid": 9802306
    }
  ],
  "_userbio": {
    "uuid": 9802306,
    "type": "user",
    "name": "Patrice Godard",
    "followers": 20,
    "description": "Data scientist and bioinformatician. Strong experience in multiomics data analysis applied to pharmaceutical  research."
  },
  "_downloads": {
    "count": 715,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/ClickHouseHTTP"
  },
  "_devurl": "https://github.com/patzaw/clickhousehttp",
  "_pkgdown": "https://patzaw.github.io/ClickHouseHTTP/",
  "_searchresults": 20,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/ClickHouseHTTP.html",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/readme.html",
    "extra/readme.md"
  ],
  "_homeurl": "https://github.com/patzaw/clickhousehttp",
  "_realowner": "patzaw",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.1",
      "date": "2022-03-29"
    },
    {
      "version": "0.1.3",
      "date": "2022-09-05"
    },
    {
      "version": "0.3.0",
      "date": "2023-02-16"
    },
    {
      "version": "0.3.2",
      "date": "2023-07-04"
    },
    {
      "version": "0.3.3",
      "date": "2024-04-18"
    },
    {
      "version": "0.3.4",
      "date": "2025-06-05"
    },
    {
      "version": "1.0.0",
      "date": "2026-05-18"
    },
    {
      "version": "1.1.2",
      "date": "2026-10-02"
    }
  ],
  "_exports": [
    "ClickHouseHTTP",
    "dbConnect",
    "dbCreateTable",
    "dbGetInfo",
    "dbSendQuery",
    "dbWriteTable"
  ],
  "_help": [
    {
      "page": "ClickHouseHTTP",
      "title": "Create a ClickHouseHTTP DBI driver",
      "topics": [
        "ClickHouseHTTP"
      ]
    },
    {
      "page": "ClickHouseHTTPConnection-class",
      "title": "ClickHouseHTTPConnection class.",
      "topics": [
        "ClickHouseHTTPConnection-class",
        "dbAppendTable,ClickHouseHTTPConnection-method",
        "dbCreateTable,ClickHouseHTTPConnection-method",
        "dbExistsTable,ClickHouseHTTPConnection,character-method",
        "dbGetInfo,ClickHouseHTTPConnection-method",
        "dbListFields,ClickHouseHTTPConnection,character-method",
        "dbListTables,ClickHouseHTTPConnection-method",
        "dbReadTable,ClickHouseHTTPConnection,character-method",
        "dbRemoveTable,ClickHouseHTTPConnection,ANY-method",
        "dbSendQuery,ClickHouseHTTPConnection,character-method",
        "dbWriteTable,ClickHouseHTTPConnection,ANY-method"
      ]
    },
    {
      "page": "ClickHouseHTTPDriver-class",
      "title": "Driver for the ClickHouse database using HTTP(S) interface",
      "topics": [
        "ClickHouseHTTPDriver-class",
        "dbConnect,ClickHouseHTTPDriver-method"
      ]
    },
    {
      "page": "ClickHouseHTTPResult-class",
      "title": "ClickHouseHTTPResult class.",
      "topics": [
        "ClickHouseHTTPResult-class"
      ]
    }
  ],
  "_pkglogo": "https://github.com/patzaw/clickhousehttp/raw/HEAD/man/figures/logo.png",
  "_readme": "https://github.com/patzaw/clickhousehttp/raw/HEAD/README.md",
  "_rundeps": [
    "arrow",
    "askpass",
    "assertthat",
    "bit",
    "bit64",
    "cli",
    "cpp11",
    "curl",
    "data.table",
    "DBI",
    "glue",
    "httr2",
    "jsonlite",
    "lifecycle",
    "magrittr",
    "openssl",
    "purrr",
    "R6",
    "rlang",
    "sys",
    "tidyselect",
    "vctrs",
    "withr"
  ],
  "_vignettes": [
    {
      "source": "Setting-up-ClickHouse-docker.Rmd",
      "filename": "Setting-up-ClickHouse-docker.html",
      "title": "Setting up a ClickHouse database using docker",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Configuration",
        "SSL certificate",
        "Container"
      ],
      "created": "2026-10-02 07:12:50",
      "modified": "2026-10-02 07:12:50",
      "commits": 1
    },
    {
      "source": "Usage.Rmd",
      "filename": "Usage.html",
      "title": "Working with ClickHouse Databases Using ClickHouseHTTP",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Connection",
        "Write a table in the database",
        "Query the database",
        "Using alternative databases stored in ClickHouse"
      ],
      "created": "2026-10-02 07:12:50",
      "modified": "2026-10-02 07:12:50",
      "commits": 1
    }
  ],
  "_score": 6.811575005870594,
  "_indexed": true,
  "_nocasepkg": "clickhousehttp",
  "_universes": [
    "patzaw"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.1.2",
      "date": "2026-10-10T07:39:02.000Z",
      "distro": "resolute",
      "commit": "055d0194caf6fac413523e08478172b7db7cdb53",
      "fileid": "https://r2.ropensci.org/44d106428dfa0623fe210469567d9920abeda5a0d8f6785f089dfcbbee0df43e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/patzaw/actions/runs/38034759572"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.1.2",
      "date": "2026-10-10T07:38:44.000Z",
      "distro": "resolute",
      "commit": "055d0194caf6fac413523e08478172b7db7cdb53",
      "fileid": "https://r2.ropensci.org/08fb324900f0b2e29c9cec8bce415f3985b8a33e45b763d16a671fc33ada287d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/patzaw/actions/runs/38034759572"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.1.2",
      "date": "2026-10-10T07:54:12.000Z",
      "commit": "055d0194caf6fac413523e08478172b7db7cdb53",
      "fileid": "https://r2.ropensci.org/8e354f74ff093508620d945f194c767d53284c8754d6364c91e37cafcc23419f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/patzaw/actions/runs/38034759572"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "1.1.2",
      "date": "2026-10-10T07:54:00.000Z",
      "commit": "055d0194caf6fac413523e08478172b7db7cdb53",
      "fileid": "https://r2.ropensci.org/1fad9ccdd40a4764586ecee1f7a2c010fe524cceceb01410021927b62539c367",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/patzaw/actions/runs/38034759572"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.1.2",
      "date": "2026-10-10T07:38:35.000Z",
      "commit": "055d0194caf6fac413523e08478172b7db7cdb53",
      "fileid": "https://r2.ropensci.org/ebbdc8d97555e7df62670b8ffb1bcc89ae825bcada17edb9de9d2264d939d15b",
      "status": "success",
      "buildurl": "https://github.com/r-universe/patzaw/actions/runs/38034759572"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.1.2",
      "date": "2026-10-10T07:37:43.000Z",
      "commit": "055d0194caf6fac413523e08478172b7db7cdb53",
      "fileid": "https://r2.ropensci.org/dd161fdbea639127ecda2aefa867a0986d5f8c9167886b4bdff2c00d87eb017f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/patzaw/actions/runs/38034759572"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.1.2",
      "date": "2026-10-10T07:37:55.000Z",
      "commit": "055d0194caf6fac413523e08478172b7db7cdb53",
      "fileid": "https://r2.ropensci.org/3df45cddb0dcc79a2dd09b8bd1c282495cda4e410c147645d43ec6598e6dd13f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/patzaw/actions/runs/38034759572"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "1.1.2",
      "date": "2026-10-10T07:37:47.000Z",
      "commit": "055d0194caf6fac413523e08478172b7db7cdb53",
      "fileid": "https://r2.ropensci.org/8c5848af66a2798c6bc819325c0346559fdb9b23829f546a22afa5dff5078ef2",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/patzaw/actions/runs/38034759572"
    }
  ]
}