ClickHouse-local
Data
embedded sql engine
SHOW HN2023
289points
70comments
#159of 3,109 in 2023
Top 6%of 2023 by points
How HN took it
MixedNo clear lean
9 positive, 17 neutral or asking, 3 mixed, 8 critical, out of 37 comments about the project. Thread score +0.08.
Idea: 4 for, 1 againstDesign: 0 for, 3 againstExecution: 0 for, 3 againstPerformance: 1 for, 0 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Fast and easy to use for log and CSV analysis
From 2 comments
I recently had a few months of AWS Cloudfront CSV logs I needed to pull some analytics from, and I ended up using clickhouse-local to do the analysis and was just blown away by…
linsomniac on HNThe memory aspect is pretty interesting. I tried to play with "serverless ELT" (the other kind of serverless) where I would define AWS Lambda that turns incoming CSV files into…
glogla on HN
Useful Lambda and CLI data use cases
From 2 comments
Congrats on the Show HN! It's great to see more tools in this area (querying data from various sources in-place) and the Lambda use case is a really cool idea! I've recently done…
cube2222 on HNSo cool. Similarly, can we also build clickhouse-remote?
devdiary on HN
Objections
No Windows support
From 2 comments
Is there some way to use this on Windows / MinGW shells? ``` $ curl https://clickhouse.com/ | sh % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload…
POPOSYS on HNLooks like no Windows support for the whole clickhose product family! This is actually great as it gives me one more reason to ask for a real operating system! Now with…
POPOSYS on HN
No library or API bindings, CLI only
From 2 comments
It is not available as a library, only CLI.
zX41ZdbW on HNAh, okay. Won't work for my use case. Still cool though!
winrid on HN
Joins may exhaust memory
From 1 comment
Huh! I recently used this to play with CH, and had no idea it was so new! Also, I've been impressed with the range of formats/protocols/types of storage CH can use, and it's a…
twotwotwo on HN
Requests
Browser or WASM version
From 1 comment
Any plans to be able to directly run this in the browser similar to DuckDB. Nice to see more options in the space.
varunkmohan on HN
npm or Python bindings
From 2 comments
This is really beautiful! I can think of a ton of use cases; so often I'm writing scraps of code or setting up quick DBs just to parse some specific dataset. I have a couple…
noduerme on HNIt is not available as a library, only CLI.
zX41ZdbW on HN
Easier S3 credential configuration
From 1 comment
Do you know if it's possible to tell clickhouse-local (without the need of a config file) to use environment variables for AWS authentication? I know there is the…
denvrede on HN
Questions
Can it read files from AWS S3?
From 2 comments
Can Clickhouse local query from files on AWS S3? We recently had some issues querying parquet files on AWS S3. I tried benchmarking various tools and DuckDB seemed the most…
whinvik on HNSure you can read from S3. You can define table that will look at your files like this https://clickhouse.com/docs/en/integrations/s3/s3-table-engine/ Or just use s3 table…
qoega on HN
How are column types inferred?
From 1 comment
This is really beautiful! I can think of a ton of use cases; so often I'm writing scraps of code or setting up quick DBs just to parse some specific dataset. I have a couple…
noduerme on HN
Alternatives named
DuckDB
From 2 comments
I wonder how hard it would be to put this in process to compete with DuckDB?
benjaminwootton on HNHere is one example: https://colab.research.google.com/github/dcmoura/spyql/blob/master/notebooks/json_benchmark.ipynb Note: DuckDB is not present in this comparison, because it…
zX41ZdbW on HN
OctoSQL
From 1 comment
Congrats on the Show HN! It's great to see more tools in this area (querying data from various sources in-place) and the Lambda use case is a really cool idea! I've recently done…
cube2222 on HN
textql, dsq, q, trdsql
From 1 comment