Clickhouse Local
clickhouse.tech
Clickhouse Local
1–10 of 77 posts
Re: Clickhouse Local
#2Clickhouse is one of the most underrated databases.
This basically replaces most of my usages of SQLite.
When its SQL "dialect" matures, Clickhouse will eat MySQL lunch, then PostgreSQL.
Re: Clickhouse Local
#3Clickhouse is one of the most underrated databases. This basically replaces most of my usages of SQLite. When its SQL "dialect" matures, Clickhouse will eat MySQL lunch, then PostgreSQL.
For analytics - sure. Clickhouse was not designed to handle
OLTP workload, there's no transaction support.
Re: Clickhouse Local
#4I wonder how performant this is in comparison to other quick and dirty methods to work on local files like bash, pythonz etc.
Re: Clickhouse Local
#5A related article from last year: https://news.ycombinator.com/item?id=20163017. No comments though.
Re: Clickhouse Local
#6Why do people on HN love Clickhouse so much? As far as I can tell, it’s an ordinary column store, with a bunch of limitations around distributed joins and a heuristic-based query planner. There are several good analytical databases that will give you the same scan performance and a much better query planner and executor.
This is not a rhetorical question, I would really like to know why it gets so much attention here.
Re: Clickhouse Local
#7Why do people on HN love Clickhouse so much? As far as I can tell, it’s an ordinary column store, with a bunch of limitations around distributed joins and a heuristic-based query planner. There are several good analytical databases that will give you the same scan performance and a much better query planner and executor. This is not a rhetorical question, I would really like to know why it gets so much attention here…
Could you name those good analytical databases? I'd love to learn more.
Re: Clickhouse Local
#8Why do people on HN love Clickhouse so much? As far as I can tell, it’s an ordinary column store, with a bunch of limitations around distributed joins and a heuristic-based query planner. There are several good analytical databases that will give you the same scan performance and a much better query planner and executor. This is not a rhetorical question, I would really like to know why it gets so much attention here…
Could you name those good analytical databases? I'd love to learn more.
Snowflake, Redshift, BigQuery, Databricks, Presto.
Re: Clickhouse Local
#9Clickhouse is one of the most underrated databases. This basically replaces most of my usages of SQLite. When its SQL "dialect" matures, Clickhouse will eat MySQL lunch, then PostgreSQL.
For analytics - sure. Clickhouse was not designed to handle OLTP workload, there's no transaction support.
I cringe a bit inside at people using say nosql approaches when it makes literally no sense to do so.
Therefore I think the lack of OLTP will not matter much and that clickhouse will be widely used, but also misused when it becomes too fashionable.