zX41ZdbW (u/zX41ZdbW)

zX41ZdbW · 19 days 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 to year, month, and day, and the calendar date can be mapped back with a year-month LUT.

zX41ZdbW commented on A time-travelling door bug in Half Life 2 mastodon.gamedev.place/@T... · Posted by u/AshleysBrain

zX41ZdbW · 22 days 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/169

Posted by u/zX41ZdbW 22 days ago

What is cosh(List(Bool))? Or beyond algebra: analysis of data types cofault.com/aodt.html...

zX41ZdbW commented on Waiting for SQL:202y: Group by All peter.eisentraut.org/blog... · Posted by u/ingve

Exuma · a month ago

Also just let me reference the damn alias in a group by, FUCK

zX41ZdbW · a month ago

I think it should be not only in GROUP BY, but in every context, e.g., inside expressions in SELECT, WHERE, etc.

zX41ZdbW commented on Waiting for SQL:202y: Group by All peter.eisentraut.org/blog... · Posted by u/ingve

elygre · a month ago

Let me reference fields as I create them:

  select xxxxx as a
       , a * 2 as b

zX41ZdbW · a month ago

This will be great! One of the things ClickHouse has had since 2016.

zX41ZdbW commented on Harder, Better, Faster, Stronger Version of Uber H3 in Rust grim7reaper.github.io/blo... · Posted by u/ashergill

grim7reaper · a month ago

I'm curious about those interesting stories ^^ Care to share a bit more?

zX41ZdbW · a month ago

Most likely this one: https://iopscience.iop.org/article/10.1088/1538-3873/acb292/...

zX41ZdbW commented on An overengineered solution to `sort | uniq -c` with 25x throughput (hist) github.com/noamteyssier/h... · Posted by u/noamteyssier

OJFord · 2 months ago

And all their comments are shilling Clickhouse either directly or via a project built on top of it, without disclosure.

zX41ZdbW · a month ago

I've edited my profile to provide a link to GitHub.

u/zX41ZdbW

KarmaCake day2405May 23, 2016

About

https://github.com/alexey-milovidov

View Original