1、Tabix
Open source simple business intelligence application and sql editor tool for Clickhouse.
https://github.com/tabixio/tabix
官方提供了五种安装方式,请参加https://tabix.io/doc/Install/#variant-5-from-docker,这里我们使用从Docker启动方式。
2、修改clickhouse-server的配置文件
(1)复制配置文件到本地
D:\Users\chengyq>docker cp clickhouse-server:/etc/clickhouse-server/config.xml D:\clickhouse
D:\Users\chengyq>
(2)停止容器、并删除
D:\Users\chengyq>docker stop c1760937
c1760937
D:\Users\chengyq>docker rm c1760937eac6
c1760937eac6
D:\Users\chengyq>docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
19600aac5981 redis "docker-entrypoint.s…" 24 hours ago Exited (0) 4 minutes ago redis
(3)修改配置文件
去除注释
<listen_host>::</listen_host>
(4)重新启动容器
D:\Users\chengyq>docker run -d --name clickhouse-server --ulimit nofile=262144:262144 -p 8123:8123 -v //D/clickhouse/config.xml:/etc/clickhouse-server/config.xml --volume=//D/clickhouse:/var/lib/clickhouse yandex/clickhouse-server
8aca04c553be177e76b6cb28ffcc68b7db932879bc2886cbd97738f6bcdcf945
D:\Users\chengyq>
3、启动Tabix
docker run -d -p 8080:80 spoonest/clickhouse-tabix-web-client
如果是第一个启动,则会先拉取镜像。可以看到类似的下面信息
latest: Pulling from spoonest/clickhouse-tabix-web-client
3d77ce4481b1: Pull complete
1763ac300a70: Pull complete
3d07614cd131: Pull complete
fe87fdd97ea8: Pull complete
b4e92389ce3a: Pull complete
ace4dba934c8: Pull complete
11865748028f: Pull complete
8ed0e6b4c35e: Pull complete
bb4d5089c0b6: Pull complete
Digest: sha256:3ee2d1a7d9db918617bf88932faa6fb1f10a6ed2729795bc4efe06ec7a7397fd
Status: Downloaded newer image for spoonest/clickhouse-tabix-web-client:latest
3、打开Tabix
(1)开打地址
http://localhost:8080/
(2)添加链接信息
(3)登录成功后的主页面
(4)测试功能
show databases;