Analytical foundations
Run ClickHouse locally
Start a disposable server and client with an official package or container, then keep it bound and removable for the lab.
Use an official package or container to run ClickHouse locally. Connect with clickhouse-client or the local command supported by your installation.
Keep the first server on the development machine. Do not expose an unauthenticated database port to the internet. A ClickHouse Cloud service is another option when you want managed storage and operations.
Run SELECT version(), create a practice database, and record the exact command that stops and removes the local environment.
Run a disposable server and connect with the native client:
docker run --rm -d --name clickhouse \
-p 8123:8123 -p 9000:9000 clickhouse/clickhouse-server
docker exec -it clickhouse clickhouse-clientInside the client, run SELECT version() and create a separate practice database. Stop the container when finished. Do not publish the native or HTTP ports on an internet-facing host without authentication and network controls.
Lesson completed