LightHouse-Docker is a lightweight GUI interface (docker version) for ClickHouse based on LightHouse.
Execute shell commands:
docker build -t yeyouluo/lighthouse:v1.0 .
Then you can get the docker image with the following command:
docker images | grep lighthouse
Execute shell commands:
docker run -d --name lighthouse-nginx -p 80:80 yeyouluo/lighthouse:v1.0
or
docker compose up -d
Explore in your browser. Just like: http://127.0.0.1/#http://192.168.1.10:8123/?user=default
.
192.168.1.10:8123
: clickhouse host ip and port
If you need to specify username (e.g. XXX), then add "/?user=XXX" to your URL, e.g. "http://127.0.0.1:8123/?user=XXX". If you want to force basic auth instead of URL-based (basic auth does not work with CORS, be careful), then add "/?basic_user=XXX" instead.
You can do the following using LightHouse:
- See tables list, filter it
- See table size on disk and estimated number of rows
- See table contents with filters and sorting
- Execute read-only queries in SQL editor
That's it! It is not meant to be a full-fledged replacement for tabix, for example.
MIT License. Based on:
- LightHouse https://github.com/VKCOM/lighthouse
- AG Grid https://www.ag-grid.com/
- ACE editor https://ace.c9.io/
- jQuery https://jquery.org/
- Tabix patches for ACE Editor https://github.com/tabixio/tabix