{"repo":"IMSMWU/RClickhouse","free":true,"listed":false,"github":"https://github.com/IMSMWU/RClickhouse","clone":"git clone https://github.com/IMSMWU/RClickhouse.git","description":"A 'DBI' Interface to the Clickhouse Database Providing Basic 'dplyr' Support","language":"R","stars":96,"topics":["dplyr","r","clickhouse","dbi-interface","dplyr-sql-backends","clickhouse-database"],"license":"GPL-2.0","category":"databases-storage","readme_excerpt":"RClickhouse Overview ClickHouse © is a high-performance relational column-store database to enable big data exploration and 'analytics' scaling to petabytes of data. Methods are provided that enable working with 'Yandex Clickhouse' databases via 'DBI' methods and using 'dplyr'/'dbplyr' idioms. This R package is a DBI interface for the Yandex Clickhouse database. It provides basic dplyr support by auto-generating SQL-commands using dbplyr and is based on the official C++ Clickhouse Client. To cite this library, please use the BibTeX entry provided in inst/CITATION . Interfaces ClickHouse can be reached over several protocols, and different R packages target different ones. Pick the package that matches the interface you want to use: - Native TCP interface — this package, RClickhouse . It talks to ClickHouse over the native binary protocol (default port 9000 ) via the official C++ ClickHouse client. This is not the HTTP interface, so connect to the native port ( 9000 ) rather than the HTTP port ( 8123 ). - HTTP(S) interface — use ClickHouseHTTP (CRAN), a DBI backend built on the ClickHouse HTTP interface (default port 8123 ) with HTTPS/SSL support. - Arrow Flight SQL interface (experimental) — an experimental rewrite of RClickhouse on top of Arrow Flight SQL is being developed on the v2-flight-sql branch. Both the rewrite itself and the Arrow Flight SQL interface are experimental, and Arrow Flight is not exposed by default on ClickHouse Cloud. This branch also provides an ","default_branch":null,"files":null,"tree":[],"storefront":"/r/IMSMWU","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/IMSMWU/RClickhouse/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}