This morning's accomplishment: finally setting up an otel collector at home, pointing it at #clickhouse, getting #caddy tracing via otel, and throwing a #grafana dashboard on it.
I didn't expect the dashboard to be the hard part.
Does anyone have experience using #ClickHouse for metrics?
Boosts are welcomed!
@velvia happy to help! You could open a case or chat at https://console.clickhouse.cloud
or ask in the #ClickHouse Community Slack here https://clickhouse.com/slack
or could put error output, logs, and/or details here, but this is not particularly private... please let me know which you'd prefer
Anyone used #clickhouse in a single node? Hows that working for you?
Currently we have a use-case where I think it would work perfect for us but a cluster I think is overkill as it's quite early.
@JasonPunyon @sirber @joranelias noting that #clickhouse can also do many|most|all of these functions locally with clickhouse-local [https://clickhouse.com/docs/en/operations/utilities/clickhouse-local], or we also have chDB for running clickhouse in process [https://github.com/chdb-io/chdb]
@thomoco @pcwizz regarding the #docker images, there's a way to set the user on the first run via CLICKHOUSE_PASSWORD or CLICKHOUSE_PASSWORD_FILE so that the #ClickHouse will set it.
Public service annoncement
If you are running #clickhouse it ships with a default password-less user will full access that you must remember to disable.
"By default, the ClickHouse server provides the default user account which is not allowed using SQL-driven access control and account management but has all the rights and permissions. The default user account is used in any cases when the username is not defined, for example, at login from client or in distributed queries. In distributed query processing a default user account is used, if the configuration of the server or cluster does not specify the user and password properties." - https://clickhouse.com/docs/en/operations/access-rights#access-control-usage
ClickHouse released a research paper on the ClickHouse internals design and server architecture - useful reference information on this distributed #opensource SQL database
All benchmarks are liars.
Also, here’s a set of db benchmarks from #clickhouse:
https://benchmark.clickhouse.com/
Various DBs including:
- #mysql
- #postgres
- #sqlite
- #timescaledb
- #alloydb
- #mariadb
still time available although time is short to enroll in the free virtual ClickHouse Fundamentals training this week, focused on the in the EMEA timezones (although all are welcome)
https://clickhouse.com/company/events/clickhouse-fundamentals
ClickHouse Fundamentals
6-hours of free training & labs
with live virtual instructors
Wednesday-Thursday May 15-16 2024
2pm-5pm CEST each day
hi @laplab - full disclosure: I work at ClickHouse, and we appreciate the feedback very much. We're always looking to improve our documentation, and we've passed this info on to our Docs team already. They will make some improvements in readability and conciseness!
If you have any other questions, ideas, or needs - please do let us know and we'd be happy to assist. Best wishes
#duckdb is really cool!
I needed to clean some JSON data and export it into Parquet, worked like a charm.
Also, documentation is much more readable and concise than the one of #ClickHouse.