{
  "_id": "6af4972fb90b31e79afd4943",
  "Package": "ClickHouseHTTP",
  "Type": "Package",
  "Title": "A Simple HTTP Database Interface to 'ClickHouse'",
  "Version": "1.1.3",
  "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.1",
  "Config/testthat/edition": "3",
  "VignetteBuilder": "knitr",
  "Config/pak/sysreqs": "cmake libxml2-dev libssl-dev",
  "Repository": "https://patzaw.r-universe.dev",
  "Date/Publication": "2026-11-11 15:18:59 UTC",
  "RemoteUrl": "https://github.com/patzaw/clickhousehttp",
  "RemoteRef": "HEAD",
  "RemoteSha": "1c0d379c7d9528223ffa4095fd7182cee2e6c042",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-11-11 16:16:48 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.3.tar.gz",
  "_fileid": "https://r2.ropensci.org/29fe2f7ab38d97b7540677d1356bc342a29cb8b64007bb7db193206cf387f4fe",
  "_filesize": 227327,
  "_sha256": "29fe2f7ab38d97b7540677d1356bc342a29cb8b64007bb7db193206cf387f4fe",
  "_expires": "2027-02-19T16:26:20.000Z",
  "_created": "2026-11-11T16:16:48.000Z",
  "_published": "2026-11-11T16:26:23.237Z",
  "_upstream": "https://github.com/patzaw/clickhousehttp",
  "_status": "success",
  "_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
  },
  "_jobs": [
    {
      "job": 130648309075,
      "time": 144,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13870874526"
    },
    {
      "job": 130648309110,
      "time": 160,
      "config": "linux-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13871752748"
    },
    {
      "job": 130648309372,
      "time": 116,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13870949331"
    },
    {
      "job": 130648309123,
      "time": 106,
      "config": "macos-release-arm64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13871563106"
    },
    {
      "job": 130645786969,
      "time": 251,
      "config": "source",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13870799536"
    },
    {
      "job": 130648309259,
      "time": 203,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "13871189274"
    },
    {
      "job": 130648309239,
      "time": 353,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13872935292"
    },
    {
      "job": 130648309122,
      "time": 99,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13869679921"
    },
    {
      "job": 130648309082,
      "time": 149,
      "config": "windows-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13871692792"
    }
  ],
  "_buildurl": "https://github.com/r-universe/patzaw/actions/runs/43056034026",
  "_commit": {
    "id": "1c0d379c7d9528223ffa4095fd7182cee2e6c042",
    "author": "Patrice Godard <patrice.godard@angelinipharma.com>",
    "committer": "Patrice Godard <patrice.godard@angelinipharma.com>",
    "message": "Use `arrow::write_ipc_file()` instead of `write_feather()`\n",
    "time": 1794410339
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_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
    },
    {
      "week": "2026-44",
      "n": 1
    },
    {
      "week": "2026-46",
      "n": 1
    }
  ],
  "_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": 19,
    "description": "Data scientist and bioinformatician. Strong experience in multiomics data analysis applied to pharmaceutical  research."
  },
  "_downloads": {
    "count": 734,
    "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,
  "_abi": {
    "exports": [
      {
        "key": "ClickHouseHTTP::ClickHouseHTTPConnection",
        "hash": "6911a0f5c94dc7c6"
      },
      {
        "key": "ClickHouseHTTP::ClickHouseHTTPDriver",
        "hash": "3616b1b744c803de"
      },
      {
        "key": "ClickHouseHTTP::ClickHouseHTTPResult",
        "hash": "b71768905236d878"
      }
    ],
    "imports": [
      {
        "key": "DBI::DBIConnection",
        "hash": "e723731c3dbaacdb"
      },
      {
        "key": "DBI::DBIDriver",
        "hash": "cd2584b29cba3eab"
      },
      {
        "key": "DBI::DBIObject",
        "hash": "09f3b098e445d20c"
      },
      {
        "key": "DBI::DBIResult",
        "hash": "8c1c65010fa94832"
      },
      {
        "key": "DBI::generic:dbAppendTable",
        "hash": "858138b929656947"
      },
      {
        "key": "DBI::generic:dbClearResult",
        "hash": "739c44c31c975b53"
      },
      {
        "key": "DBI::generic:dbColumnInfo",
        "hash": "4ca85a4be1b419b6"
      },
      {
        "key": "DBI::generic:dbConnect",
        "hash": "b28fec54a15b1754"
      },
      {
        "key": "DBI::generic:dbCreateTable",
        "hash": "493d1721a791bafc"
      },
      {
        "key": "DBI::generic:dbDataType",
        "hash": "6e56b0e86f78e27d"
      },
      {
        "key": "DBI::generic:dbDisconnect",
        "hash": "7c1b532d5c90334c"
      },
      {
        "key": "DBI::generic:dbExistsTable",
        "hash": "2d41885c07ff912e"
      },
      {
        "key": "DBI::generic:dbFetch",
        "hash": "05b6728268c40323"
      },
      {
        "key": "DBI::generic:dbGetInfo",
        "hash": "80063f68739bb353"
      },
      {
        "key": "DBI::generic:dbGetRowCount",
        "hash": "dfb79bfebf9f571f"
      },
      {
        "key": "DBI::generic:dbGetRowsAffected",
        "hash": "4c4f84ce2b8dac7a"
      },
      {
        "key": "DBI::generic:dbGetStatement",
        "hash": "0c7fc7f1d157be1d"
      },
      {
        "key": "DBI::generic:dbHasCompleted",
        "hash": "d2d001804dc9b889"
      },
      {
        "key": "DBI::generic:dbIsValid",
        "hash": "f9deb8148f92cdb2"
      },
      {
        "key": "DBI::generic:dbListFields",
        "hash": "d1d193bdbf5fe5be"
      },
      {
        "key": "DBI::generic:dbListTables",
        "hash": "66eba71dbc580096"
      },
      {
        "key": "DBI::generic:dbQuoteIdentifier",
        "hash": "82ddc9d8108b66bd"
      },
      {
        "key": "DBI::generic:dbQuoteString",
        "hash": "2e7910fcf67a4794"
      },
      {
        "key": "DBI::generic:dbReadTable",
        "hash": "cb2189390acec488"
      },
      {
        "key": "DBI::generic:dbRemoveTable",
        "hash": "a6c380b2a9c56d7c"
      },
      {
        "key": "DBI::generic:dbSendQuery",
        "hash": "849b42bbbc07746d"
      },
      {
        "key": "DBI::generic:dbUnloadDriver",
        "hash": "4d8c3dc970b3732e"
      },
      {
        "key": "DBI::generic:dbWriteTable",
        "hash": "956e377a7eb4c94d"
      }
    ]
  },
  "_rbuild": "4.6.2",
  "_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.936513742478894,
  "_indexed": true,
  "_nocasepkg": "clickhousehttp",
  "_universes": [
    "patzaw"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.1.3",
      "date": "2026-11-11T16:19:14.000Z",
      "distro": "resolute",
      "commit": "1c0d379c7d9528223ffa4095fd7182cee2e6c042",
      "fileid": "https://r2.ropensci.org/9c3c730dba7ad6c2bf4c587358b9e3382f1db05b3e5631a1a442abaca897b0eb",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/patzaw/actions/runs/43056034026"
    },
    {
      "r": "4.6.2",
      "os": "linux",
      "version": "1.1.3",
      "date": "2026-11-11T16:19:23.000Z",
      "distro": "resolute",
      "commit": "1c0d379c7d9528223ffa4095fd7182cee2e6c042",
      "fileid": "https://r2.ropensci.org/9aa2cacf63f01bb92fd3712b37dfc8d5b015d77f09ccae12d7833643b7770ff9",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/patzaw/actions/runs/43056034026"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.1.3",
      "date": "2026-11-11T16:18:44.000Z",
      "commit": "1c0d379c7d9528223ffa4095fd7182cee2e6c042",
      "fileid": "https://r2.ropensci.org/81493063a1055b8907c8114e774fb9b58bb16127494db77deee32ea67842513e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/patzaw/actions/runs/43056034026"
    },
    {
      "r": "4.6.2",
      "os": "mac",
      "version": "1.1.3",
      "date": "2026-11-11T16:18:36.000Z",
      "commit": "1c0d379c7d9528223ffa4095fd7182cee2e6c042",
      "fileid": "https://r2.ropensci.org/3d2f1bf31ff1fd19bca94a4397502a88f72be62cd1fd990cc0983fd0e584148d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/patzaw/actions/runs/43056034026"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.1.3",
      "date": "2026-11-11T16:20:34.000Z",
      "commit": "1c0d379c7d9528223ffa4095fd7182cee2e6c042",
      "fileid": "https://r2.ropensci.org/3829e4dcc6f4ea44937589471b97d682e6fee0534d88a6b4982ddcd7a593bf7b",
      "status": "success",
      "buildurl": "https://github.com/r-universe/patzaw/actions/runs/43056034026"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.1.3",
      "date": "2026-11-11T16:22:06.000Z",
      "commit": "1c0d379c7d9528223ffa4095fd7182cee2e6c042",
      "fileid": "https://r2.ropensci.org/fda169c1d78926c7afb783e47aea1ab97ab1430334083e1d1f3f08cbd317baed",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/patzaw/actions/runs/43056034026"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.1.3",
      "date": "2026-11-11T16:18:13.000Z",
      "commit": "1c0d379c7d9528223ffa4095fd7182cee2e6c042",
      "fileid": "https://r2.ropensci.org/5ece9e27c4deb79b1995e23a55f5f7a139530e2ef18e81393b2867d669041dd8",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/patzaw/actions/runs/43056034026"
    },
    {
      "r": "4.6.2",
      "os": "win",
      "version": "1.1.3",
      "date": "2026-11-11T16:18:46.000Z",
      "commit": "1c0d379c7d9528223ffa4095fd7182cee2e6c042",
      "fileid": "https://r2.ropensci.org/7e816c01764feeb347a6f6c68bd90a94799770979af7ce961598767ba1d58d0c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/patzaw/actions/runs/43056034026"
    }
  ]
}