Oct
21
ClickHouse Playground
docker-compose.yml
services:
clickhouse:
image: clickhouse/clickhouse-server:latest
container_name: my-clickhouse
ports:
- "8123:8123" # HTTP API 端口,用于Web界面和HTTP请求
- "9000:9000" # 原生TCP协议端口,用于clickhouse-client连接
volumes:
- ./data:/var/lib/clickhouse # 数据持久化到主机的 ./data 目录
environment:
- CLICKHOUSE_DB=default
- CLICKHOUSE_USER=default
- CLICKHOUSE_PASSWORD=123456
- CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT=1
deploy:
resources:
limits:
cpus: '4.0'
memory: 8G
reservations:
cpus: '1.0'
memory: 2G
启动
$ docker compose up -d
连接
$ docker exec -it my-clickhouse clickhouse-client --user default --password 123456
Playground:
$ git clone https://github.com/VKCOM/lighthouse.git
访问(替换 $CLICKHOUSE 为部署的 IP 或域名)
http://127.0.0.1/lighthouse/#http://$CLICKHOUSE:8123/?user=learn&password=123456
转载请注明出自 ,如是转载文则注明原出处,谢谢:)
RSS订阅地址: https://www.felix021.com/blog/feed.php 。
引用
services:
clickhouse:
image: clickhouse/clickhouse-server:latest
container_name: my-clickhouse
ports:
- "8123:8123" # HTTP API 端口,用于Web界面和HTTP请求
- "9000:9000" # 原生TCP协议端口,用于clickhouse-client连接
volumes:
- ./data:/var/lib/clickhouse # 数据持久化到主机的 ./data 目录
environment:
- CLICKHOUSE_DB=default
- CLICKHOUSE_USER=default
- CLICKHOUSE_PASSWORD=123456
- CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT=1
deploy:
resources:
limits:
cpus: '4.0'
memory: 8G
reservations:
cpus: '1.0'
memory: 2G
启动
$ docker compose up -d
连接
$ docker exec -it my-clickhouse clickhouse-client --user default --password 123456
CREATE DATABASE learn;
CREATE USER 'learn' IDENTIFIED WITH sha256_password BY '123456';
GRANT ALL ON learn.* to 'learn';
CREATE USER 'learn' IDENTIFIED WITH sha256_password BY '123456';
GRANT ALL ON learn.* to 'learn';
Playground:
$ git clone https://github.com/VKCOM/lighthouse.git
访问(替换 $CLICKHOUSE 为部署的 IP 或域名)
http://127.0.0.1/lighthouse/#http://$CLICKHOUSE:8123/?user=learn&password=123456
欢迎扫码关注:

转载请注明出自 ,如是转载文则注明原出处,谢谢:)
RSS订阅地址: https://www.felix021.com/blog/feed.php 。
ClickHouse: Dictionary
Ollama API example


