zX41ZdbW

8 ms·

91.
by zX41ZdbW 10mo ago
I've implemented the same idea a few years ago: https://pastila.nl/
92.
by zX41ZdbW 10mo ago
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/...
93.
by zX41ZdbW 10mo ago
> 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.
94.
by zX41ZdbW 10mo ago
I use SQL for music: https://github.com/ClickHouse/NoiSQL
95.
by zX41ZdbW 10mo ago
ClickHouse is a tiny component - a single binary that runs on a laptop.
96.
Parallelizing ClickHouse aggregation merge for fixed hash map(blog.incfly.org)
3 points by zX41ZdbW 10mo ago|0 comments
97.
QueryDog – a tool for ClickHouse performance optimisation(github.com)
1 points by zX41ZdbW 10mo ago|0 comments
98.
Iceberg, the Right Idea – The Wrong Spec(database-doctor.com)
3 points by zX41ZdbW 11mo ago|1 comments
99.
Let's Rebuild the MySQL Community Together(percona.com)
2 points by zX41ZdbW 11mo ago|0 comments
100.
by zX41ZdbW 11mo ago
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
101.
by zX41ZdbW 11mo ago
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&#x
102.
What is cosh(List(Bool))? Or beyond algebra: analysis of data types(cofault.com)
2 points by zX41ZdbW 11mo ago|0 comments
103.
by zX41ZdbW 11mo ago
I think it should be not only in GROUP BY, but in every context, e.g., inside expressions in SELECT, WHERE, etc.
104.
by zX41ZdbW 11mo ago
This will be great! One of the things ClickHouse has had since 2016.
105.
by zX41ZdbW 1y ago
Most likely this one: https://iopscience.iop.org/article/10.1088/1538-3873/acb292/...
106.
by zX41ZdbW 1y ago
I've edited my profile to provide a link to GitHub.
107.
by zX41ZdbW 1y ago
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
108.
Deepnote, a Jupyter alternative, is going open source(deepnote.com)
188 points by zX41ZdbW 1y ago|171 comments
109.
by zX41ZdbW 1y ago
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).
110.
by zX41ZdbW 1y ago
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
111.
by zX41ZdbW 1y ago
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. htt
112.
by zX41ZdbW 1y ago
The statement is untrue. For example, ClickHouse is in C++, and it has thousands of contributors with hundreds of external contributors every month.
113.
by zX41ZdbW 1y ago
It's old news, but you can even host ClickHouse databases on GitHub pages: https://github.com/ClickHouse/web-tables-demo
114.
by zX41ZdbW 1y ago
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 i
115.
Making complex JSON 58x faster, use 3,300x less memory, in ClickHouse(clickhouse.com)
2 points by zX41ZdbW 1y ago|1 comments
116.
by zX41ZdbW 1y ago
The main birds dataset is from eBird, and the photos are from Wikipedia.
117.
by zX41ZdbW 1y ago
A writeup: https://clickhouse.com/blog/birds + There is an attribution in the top-down corner of the map.
118.
by zX41ZdbW 1y ago
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...
119.
by zX41ZdbW 1y ago
Thanks for posting! I've recently added more datasets, "Places", "Birds", "Photos", and "You". Also, a hint - the rectangular selection tool lets you generate custom reports for a location.
120.
SQL Shader(github.com)
2 points by zX41ZdbW 1y ago|0 comments

More ›