HNHacker News
TopNewBestAskShowJobs

zX41ZdbW

2,883 karma · joined May 23, 2016

https://github.com/alexey-milovidov
submissionscomments
zX41ZdbW··on The URL shortener that makes your links look as suspicious as possible
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...

zX41ZdbW··on Sirius DB
GPU databases can run a small subset of production workloads in a narrow combination of conditions.

There are plenty of GPU databases out there: mapD/OmniSci/HeavyDB, AresDB, BlazingSQL, Kinetika, BrytlytDB, SQReam, Alenka, ... Some of them are very niche, and the others are not even usable.

zX41ZdbW··on Show HN: 22 GB of Hacker News in SQLite
You can run it locally, but it is a client-server architecture, which means that something has to run behind the browser.
zX41ZdbW··on Show HN: 22 GB of Hacker News in SQLite
The query tab looks quite complex with all these content shards: https://hackerbook.dosaygo.com/?view=query

I have a much simpler database: https://play.clickhouse.com/play?user=play#U0VMRUNUIHRpbWUsI...

zX41ZdbW··on High-performance C++ hash table using grouped SIMD metadata scanning
The test does not look realistic: https://github.com/Cranot/grouped-simd-hashtable/blob/master...

Better to use a few distributions of keys from production-like datasets, e.g., from ClickBench. Most of them will be Zipfian and also have different temporal locality.

zX41ZdbW··on Ask HN: What are the best engineering blogs with real-world depth?
Here is my list of good technology blogs: https://clickhouse.com/blog/tech-blogs
zX41ZdbW··on MongoBleed Explained Simply
There are many more exposed MySQLs than MongoDBs:

https://www.shodan.io/search?query=mongodb https://www.shodan.io/search?query=mysql https://www.shodan.io/search?query=postgresql

But this must be proportional to the overall popularity.

zX41ZdbW··on Package managers keep using Git as a database, it never works out
ClickHouse can do it. Examples:

    https://play.clickhouse.com/

    clickhouse-client --host play.clickhouse.com --user play --secure

    ssh play.clickhouse.com
zX41ZdbW··on Show HN: Spice Cayenne – SQL acceleration built on Vortex
Let's add Spice to ClickBench: https://benchmark.clickhouse.com/
zX41ZdbW··on Show HN: Minimalist editor that lives in browser, stores everything in the URL
I've implemented the same idea a few years ago: https://pastila.nl/
zX41ZdbW··on Instant database clones with PostgreSQL 18
This is typical for analytical databases, e.g., ClickHouse (which I'm the author of) uses immutable data parts, allowing table cloning: https://clickhouse.com/docs/sql-reference/statements/create/...
zX41ZdbW··on Font with Built-In Syntax Highlighting (2024)
> it breaks when your code goes to a newline. there's no way to keep context line to line...

This is a blocker for my applications.

zX41ZdbW··on Programming languages used for music
I use SQL for music: https://github.com/ClickHouse/NoiSQL
zX41ZdbW··on Logging sucks
ClickHouse is a tiny component - a single binary that runs on a laptop.
zX41ZdbW··on A Fast 64-Bit Date Algorithm (30–40% faster by counting dates backwards)
Interesting how it compares with the ClickHouse implementation, which uses a lookup table: https://github.com/ClickHouse/ClickHouse/blob/master/src/Com...

So that a day number can be directly mapped to year, month, and day, and the calendar date can be mapped back with a year-month LUT.

zX41ZdbW··on A time-travelling door bug in Half Life 2
This reminds me of an old bug in simdjson - any usage of it breaks std::unordered_map in unrelated parts of the code due to an unintentional modification of FPU flags: https://github.com/simdjson/simdjson/issues/169
zX41ZdbW··on Waiting for SQL:202y: Group by All
I think it should be not only in GROUP BY, but in every context, e.g., inside expressions in SELECT, WHERE, etc.
zX41ZdbW··on Waiting for SQL:202y: Group by All
This will be great! One of the things ClickHouse has had since 2016.
zX41ZdbW··on Harder, Better, Faster, Stronger Version of Uber H3 in Rust
Most likely this one: https://iopscience.iop.org/article/10.1088/1538-3873/acb292/...
zX41ZdbW··on An overengineered solution to `sort | uniq -c` with 25x throughput (hist)
I've edited my profile to provide a link to GitHub.
zX41ZdbW··on Kafka is Fast – I'll use Postgres
I often use a different approach - assume by default that external contributors are smarter than our employees. This is needed to prevent arrogance and entitlement during code reviews. A reasonable pull request from an external contributor is more valuable than one from an employee.
zX41ZdbW··on Harder, Better, Faster, Stronger Version of Uber H3 in Rust
H3 was integrated into ClickHouse in 2019, and since then, I have heard many interesting stories. There are unusual ones, e.g., when it is used not to map data on Earth, but for astronomy (stars, galaxies).
zX41ZdbW··on Notes by djb on using Fil-C
I'm trying to make Turso load some data, but it is so slow that even several months are not enough to load the dataset: https://github.com/ClickHouse/ClickBench/issues/336
zX41ZdbW··on Do you know that there is an HTML tables API?
I was using it just half a year ago, after either reading MDN or reading what AI suggested. Which means, this API is not obscure and not forgotten. Using `rows` and `cells` is very convenient for keyboard navigation across table cells.

https://github.com/ClickHouse/ClickHouse/blob/master/program...

zX41ZdbW··on Kafka is Fast – I'll use Postgres
The statement is untrue. For example, ClickHouse is in C++, and it has thousands of contributors with hundreds of external contributors every month.
zX41ZdbW··on Hosting SQLite Databases on GitHub Pages (2021)
It's old news, but you can even host ClickHouse databases on GitHub pages: https://github.com/ClickHouse/web-tables-demo
zX41ZdbW··on An overengineered solution to `sort | uniq -c` with 25x throughput (hist)
This and similar tasks can be solved efficiently with clickhouse-local [1]. Example:

    ch --input-format LineAsString --query "SELECT line, count() AS c GROUP BY line ORDER BY c DESC" < data.txt
I've tested it and it is faster than both sort and this Rust code:

    time LC_ALL=C sort data.txt | uniq -c | sort -rn > /dev/null
    32 sec.

    time hist data.txt > /dev/null
    14 sec.

    time ch --input-format LineAsString --query "SELECT line, count() AS c GROUP BY line ORDER BY c DESC" < data.txt > /dev/null
    2.7 sec.
It is like a Swiss Army knife for data processing: it can solve various tasks, such as joining data from multiple files and data sources, processing various binary and text formats, converting between them, and accessing external databases.

[1] https://clickhouse.com/docs/operations/utilities/clickhouse-...

zX41ZdbW··on ADS-B Exposed
The main birds dataset is from eBird, and the photos are from Wikipedia.
zX41ZdbW··on ADS-B Exposed
A writeup: https://clickhouse.com/blog/birds

+ There is an attribution in the top-down corner of the map.

zX41ZdbW··on ADS-B Exposed
I'd like it if you try to guess :)

But it is easy to figure it out from the source code. The source code is here: https://github.com/ClickHouse/adsb.exposed/blob/main/index.h...

← PreviousPage 3 of 26Next →