Clickhousex
ClickHouse 数据库驱动程序通过 HTTP 接口与 Elixir 应用程序连接。
安装
def deps do
[
{:clickhousex, "~> 0.4.0"}
]
end
启用驱动程序
调用 start_link()/1 函数并传递连接选项：
Clickhousex.start_link( scheme: :http, hostname: "localhost", port: 8123, database: "default", username: "user", password: "654321" )
选项要求关键字列表包含零个或多个：
* `scheme` - Scheme (:http | :https). Default value: :http * `hostname` - The server hostname. Default value: "localhost" * `database` - Database name. Default value: "default" * `port` - The server port number. Default value: 8123 * `username` - Username. Default value: nil * `password` - User's password. Default value: nil
示例查询
iex(1)> {:ok, pid} = Clickhousex.start_link(scheme: :http, hostname: "localhost", port: 8123, database: "system")
{:ok, #PID<0.195.0>}
iex(2)> Clickhousex.query(pid, "SHOW TABLES", [])
{:ok, %Clickhousex.Query{columns: nil, name: "", statement: "SHOW TABLES"},
%Clickhousex.Result{columns: ["name"], command: :selected, num_rows: 23,
rows: [["asynchronous_metrics"], ["build_options"], ["clusters"], ["columns"],
["databases"], ["dictionaries"], ["events"], ["functions"],
["graphite_retentions"], ["merges"], ["metrics"], ["models"], ["numbers"],
["numbers_mt"], ["one"], ["parts"], ["parts_columns"], ["processes"],
["replicas"], ["replication_queue"], ["settings"], ["tables"],
["zookeeper"]]}}
iex(3)>
文档
文档在这里。