zX41ZdbW

25 ms·

451.
by zX41ZdbW 3y ago
It is strange to hear about innovation in DuckDB - I see that they are gradually re-implementing the stuff already existing in ClickHouse. Sometimes they do a better job at promoting it.
452.
by zX41ZdbW 3y ago
ClickHouse: SELECT * FROM employees ORDER BY join_date LIMIT 1 BY role
453.
by zX41ZdbW 3y ago
Here are examples of MongoDB aggregations: https://github.com/ClickHouse/ClickBench/blob/main/mongodb/q... They are painful to write compared to SQL queries. Although the commercial version of Mongo
454.
by zX41ZdbW 3y ago
The ergonomics could be better: https://pastila.nl/?01359244/9ac65f960385a02b3193778b4c6af10... Significant newlines. Non-obvious way to specify database/schema.
455.
by zX41ZdbW 3y ago
Not only PQRL fixes this. It has been allowed in ClickHouse's SQL since its inception.
456.
by zX41ZdbW 3y ago
Both complaints are resolved by ClickHouse. This video also covers many other advantages of ClickHouse's SQL dialect: https://www.youtube.com/watch?v=zhrOYQpgvkk Some may find your first complaint questionable... But I
457.
by zX41ZdbW 3y ago
What does it mean? Is it the same as "LIMIT BY" in ClickHouse? https://clickhouse.com/docs/en/sql-reference/statements/sele...
458.
by zX41ZdbW 3y ago
ClickHouse is a simple and solid tool - you install it, it works, and it does not require attention. It is probably the less problematic data storage dependency. Works well in embedded scenarios.
459.
by zX41ZdbW 3y ago
We have recently merged PRQL support into ClickHouse: https://github.com/ClickHouse/ClickHouse/pull/50686 It's currently more like an experiment - I'm not sure if it will be usable or useful. There
460.
by zX41ZdbW 3y ago
Thanks for the link. We also make static websites by direct inclusion their HTML code in the C++ binary of ClickHouse. I've tried to use this library but found a bug: https://github.com/graphitemaster/incbin/i
461.
by zX41ZdbW 3y ago
We have recently added official builds of ClickHouse for RISCV-64: https://github.com/ClickHouse/ClickHouse/pull/31398 Although the support existed for several years, it was not automated until recently.
462.
by zX41ZdbW 3y ago
We started this challenge on ClickHouse's Twitter: https://twitter.com/ClickHouseDB/status/1635651016895918080 Nice to see a follow-up, although it feels secondary.
463.
by zX41ZdbW 3y ago
I recommend taking a look at a similar project I've implemented: clickhouse-obfuscator. It is described here: https://github.com/ClickHouse/ClickHouse/tree/master/program... (implementation details,
464.
by zX41ZdbW 3y ago
It shows Access Denied from Europe.
465.
by zX41ZdbW 3y ago
Interesting fact - all four are using ClickHouse, which is my favorite technology.
466.
by zX41ZdbW 3y ago
I've loaded all HN comments with embeddings into ClickHouse, and it performs well without vector indices (and better - with them): https://www.youtube.com/watch?v=hGRNcftpqAk Slides: https://presentations.cl
467.
by zX41ZdbW 3y ago
I'm doing the same way for https://play.clickhouse.com/play?user=play But there is one question. The article says: > I get my HTTPS certs from Let's Encrypt via certbot — this handles automatic renewal so I don
468.
by zX41ZdbW 3y ago
Interesting to see a comparison with ClickHouse Native format.
469.
by zX41ZdbW 3y ago
I recommend to model after ClickHouse ODBC integration: https://clickhouse.com/docs/en/sql-reference/table-functions... It already has the items from your list, like the predicate push-down. Plus, it is memor
470.
by zX41ZdbW 3y ago
Either it does not have hinting, or it looks not nice on a laptop with FullHD screen. I've created a website to compare monospace fonts on something resembling a work environment: https://alexey-milovidov.github.io/font
471.
by zX41ZdbW 3y ago
I've recently made a presentation on this topic exactly. Video: https://www.youtube.com/watch?v=hGRNcftpqAk Slides: https://presentations.clickhouse.com/meetup74/ai/
472.
by zX41ZdbW 3y ago
I also recommend this approach when you want to understand every step. I recently did a presentation about this topic: https://www.youtube.com/watch?v=hGRNcftpqAk It covers end-to-end, including ClickHouse as a vector datab
473.
by zX41ZdbW 3y ago
The article is from 2020, but the dataset is constantly updated. You can press the "pencil" button near the queries to run them on the live data and edit them interactively. I should update the article, though...
474.
by zX41ZdbW 3y ago
Duplicate of https://news.ycombinator.com/item?id=36671322
475.
by zX41ZdbW 3y ago
I checked your service, but it does not work. For example, I've asked: > What are the latest features introduced in ClickHouse? and it answered: > :sparkles::crystal_ball: Oh dear! A mystical internal server error has occurred. P
476.
by zX41ZdbW 3y ago
I've recently implemented a project to test and compare analytical databases, including cloud services: https://github.com/ClickHouse/ClickBench/ It compares Redshift and Athena as well.
477.
by zX41ZdbW 3y ago
It's better to ensure 100% compatibility with the data format so the new server versions can read the old format without conversions. For example, in ClickHouse, you can install the latest version over a version from 7 years ago, and i
478.
by zX41ZdbW 3y ago
I recommend checking a similar project - storing ClickHouse databases on GitHub pages for serverless analytical queries: https://github.com/ClickHouse/web-tables-demo
479.
by zX41ZdbW 3y ago
It looks redundant in the presence of ClickHouse, which covers these usage scenarios perfectly.
480.
by zX41ZdbW 3y ago
https://github.com/ClickHouse/libunwind/ There were multiple steps: 1. Avoid using malloc/free inside libunwind. 2. Avoid using FDECache that required a mutex. 3. Avoid using dl_iterate_phdr (a mutex inside l

More ›