HackerTrans
TopNewTrendsCommentsPastAskShowJobs

zX41ZdbW

2,628 karmajoined 10 лет назад
https://github.com/alexey-milovidov

Submissions

Hellishly Slow Level 13 Deflate Compression

kirill.korins.ky
94 points·by zX41ZdbW·21 день назад·26 comments

Global weather data from flying airplanes (2025)

clickhouse.com
1 points·by zX41ZdbW·2 месяца назад·0 comments

A cooperative fiber scheduler for Linux

github.com
3 points·by zX41ZdbW·2 месяца назад·0 comments

Agentic Coding at ClickHouse

clickhouse.com
2 points·by zX41ZdbW·2 месяца назад·0 comments

iOS Exploit Chain Adopted by Multiple Threat Actors

cloud.google.com
2 points·by zX41ZdbW·4 месяца назад·0 comments

Databricks Announces Lakewatch: New Open, Agentic SIEM

databricks.com
3 points·by zX41ZdbW·4 месяца назад·1 comments

PostGIS-compatible spatial functions for ClickHouse

github.com
3 points·by zX41ZdbW·4 месяца назад·0 comments

Claude Code rolls out a voice mode capability

techcrunch.com
11 points·by zX41ZdbW·4 месяца назад·1 comments

Training neural networks on Apple Neural Engine via reverse'd private APIs

github.com
3 points·by zX41ZdbW·4 месяца назад·0 comments

Harness engineering: leveraging Codex in an agent-first world

openai.com
3 points·by zX41ZdbW·5 месяцев назад·0 comments

Polyglot – a Rust/WASM SQL transpilation library

tobilg.com
2 points·by zX41ZdbW·5 месяцев назад·0 comments

SereneDB – The First Real-Time Search Analytics Database

github.com
3 points·by zX41ZdbW·5 месяцев назад·0 comments

OpenText to Divest Vertica for US$150M

morningstar.com
1 points·by zX41ZdbW·5 месяцев назад·0 comments

Global weather data from flying airplanes (2025)

clickhouse.com
2 points·by zX41ZdbW·6 месяцев назад·0 comments

Solving the "Impossible" in ClickHouse: Advent of Code 2025

clickhouse.com
1 points·by zX41ZdbW·6 месяцев назад·0 comments

Snowflake announces intent to acquire Observe

snowflake.com
4 points·by zX41ZdbW·6 месяцев назад·1 comments

Solving Advent of Code 2025 in SQL

clickhouse.com
2 points·by zX41ZdbW·6 месяцев назад·0 comments

Marmot – A distributed SQLite server with MySQL wire compatible interface

github.com
189 points·by zX41ZdbW·6 месяцев назад·38 comments

Collaboration Sucks

posthog.com
2 points·by zX41ZdbW·7 месяцев назад·1 comments

[untitled]

1 points·by zX41ZdbW·7 месяцев назад·0 comments

comments

zX41ZdbW
·6 дней назад·discuss
I've recently tested BQN on ClickBench (a benchmark for OLAP databases), and the results are not great: https://benchmark.clickhouse.com/#system=+N|liH&type=-&machi...

If anyone is curious how queries in this language look, you can see it here: https://github.com/ClickHouse/ClickBench/pull/939/changes#di...
zX41ZdbW
·11 дней назад·discuss
Coding with AI is not much different from coding without AI, just faster and with slightly less typing. But you still have to organize the work and split it into small items. If you ask a model to implement a ray tracer in SQL, it can do something one-shot, but it won't be as satisfactory as with an engineer.
zX41ZdbW
·11 дней назад·discuss
It is needed to find bottlenecks in the engine and optimize customer queries. For example, it gives things like: https://github.com/ClickHouse/ClickHouse/pull/108757

You can read more about this approach in my presentation: https://presentations.clickhouse.com/2026-openhouse-sf/great... and video: https://www.youtube.com/watch?v=FmS7VopaqNg
zX41ZdbW
·11 дней назад·discuss
It is needed to find bottlenecks in the engine and optimize customer queries. For example, it gives things like: https://github.com/ClickHouse/ClickHouse/pull/108757

You can read more about this approach in my presentation: https://presentations.clickhouse.com/2026-openhouse-sf/great... and video: https://www.youtube.com/watch?v=FmS7VopaqNg
zX41ZdbW
·18 дней назад·discuss
I host a publicly open database with Hacker News data at https://play.clickhouse.com/play?user=play#U0VMRUNUICogRlJPT...

So you can create any sort of similar services in a single SQL query and an HTML page.

I also hosted it as a publicly accessible data lake, which you can query from everywhere: https://github.com/ClickHouse/ClickHouse/issues/29693#issuec...

It is also updated in real-time.
zX41ZdbW
·23 дня назад·discuss
Found one example that survived, and it was legitimate: https://github.com/ClickHouse/ClickHouse/pull/99522/changes
zX41ZdbW
·23 дня назад·discuss
The CI only runs after one of the maintainers adds a "can be tested" label. When the label is already added, it stops when any of the infrastructure-related files are modified, like Dockerfile, CI configurations, etc. This is quite ok, but not 100% bulletproof, as you can easily do weird things by modifying the code or using a bug in the compiler. However, the CI infrastructure runs on isolated machines inside an isolated account.

Before adding the label, we have to check the diff for suspicious things. There were a few abuse attempts (all of them were from now vanished GitHub accounts).
zX41ZdbW
·2 месяца назад·discuss
There is already a database named EventQL: https://github.com/eventql/eventql I covered it in my presentation: https://presentations.clickhouse.com/2018-unknown_developers...
zX41ZdbW
·2 месяца назад·discuss
I've been trying for more than a year to make TursoDB load a single file, and it fails: https://github.com/ClickHouse/ClickBench/issues/336
zX41ZdbW
·4 месяца назад·discuss
The performance of hash tables and hash functions significantly depends on the data distribution, and should be compared on real datasets.

I've covered it in my presentation: https://presentations.clickhouse.com/2017-hash_tables/
zX41ZdbW
·4 месяца назад·discuss
Ground vehicles with transponders: https://adsb.exposed/?dataset=Planes&zoom=7&lat=42.1262&lng=...
zX41ZdbW
·4 месяца назад·discuss
https://github.com/ClickHouse/ClickHouse/pull/99828
zX41ZdbW
·4 месяца назад·discuss
Two problematic statements in this article:

1. Test pass rate is 99.98% is not good - the only acceptable rate is 100%.

2. Tests should not be quarantined or disabled. Every flaky test deserves attention.
zX41ZdbW
·4 месяца назад·discuss
Similarly, this is how it was introduced in ClickHouse in 2019: https://github.com/ClickHouse/ClickHouse/pull/4774
zX41ZdbW
·5 месяцев назад·discuss
I once tried to post an interesting visualization to r/dataisbeautiful and received hundreds of upvotes, but then it was wiped for an unknown reason. Then I contacted the mods, both on Reddit and over email, to no avail.

It was a very frustrating experience, don't recommend anyone to try.
zX41ZdbW
·6 месяцев назад·discuss
Though ClickHouse is not limited to a single machine or local data processing. It's a full-featured distributed database.
zX41ZdbW
·6 месяцев назад·discuss
When a single server is not enough, you deploy ClickHouse on a cluster, up to thousands of machines, e.g., https://clickhouse.com/blog/how-clickhouse-powers-ahrefs-the...
zX41ZdbW
·6 месяцев назад·discuss
This is bad news: it is not usable:

> 5.3 Licensee may not disclose any benchmarking or results of evaluating the Software without Exasol´s prior written consent
zX41ZdbW
·6 месяцев назад·discuss
This is good news.

I was trying to add Exasol to ClickBench (https://github.com/ClickHouse/ClickBench/) since 2016, but it was not possible due to the limitations and the fact that it required using a custom virtual machine image.

Now we should try it again...
zX41ZdbW
·6 месяцев назад·discuss
I would also like to have something like this, but for "vintage" links - something that looks like it was from the late 90s.

I use them in tests, just for fun: https://github.com/ClickHouse/ClickHouse/blob/master/tests/q...