zX41ZdbW

10 ms·

1. 121.▲
   HTML, the Programming Language(html-lang.org)

   2 points by zX41ZdbW 1y ago|0 comments
2. 122.▲
   by zX41ZdbW 1y ago

   Fun facts about floating point, from my practice: Obvious: An array containing NaNs will almost certainly be sorted incorrectly with std::sort. Non-obvious: sorting an array containing NaNs with std::sort from libstdc++ (gcc's implemen
3. 123.▲
   by zX41ZdbW 1y ago

   This is a great article! A few more resources on this topic: https://randomascii.wordpress.com/category/floating-point/ - a series of articles about floating point, with deeper details. https://float.ex
4. 124.▲
   We built fast UPDATEs for the ClickHouse column store(clickhouse.com)

   2 points by zX41ZdbW 1y ago|0 comments
5. 125.▲
   by zX41ZdbW 1y ago

   Only 16 companies - quite sparse. May I ask to add my blog if possible? https://clickhouse.com/blog?category=engineering
6. 126.▲
   by zX41ZdbW 1y ago

   I've decided to check if it's possible to generate temperature and wind maps in real-time. Temperature: https://adsb.exposed/?dataset=Planes&zoom=5&lat=45.8124&lng=... Wind direction (Europe mainly):
7. 127.▲
   by zX41ZdbW 1y ago

   Very reasonable. I've recently experimented with the methods of serving bitmaps out of the database in my project[1]. One option was to generate PNG on the fly, but simply outputting an array of pixel color values over HTTP with Conten
8. 128.▲
   Stop Drawing Dead Fish (2013) [video](youtube.com)

   1 points by zX41ZdbW 1y ago|0 comments
9. 129.▲
   Malicious script injected into Amazon Q Developer for Visual Studio(github.com)

   1 points by zX41ZdbW 1y ago|1 comments
10. 130.▲
    by zX41ZdbW 1y ago

    This problem is made-up. ClickHouse accepts out-of-order insertions like regular ones - there is no difference.
11. 131.▲
    by zX41ZdbW 1y ago

    ClickHouse already has a built-in CLI agent.
12. 132.▲
    by zX41ZdbW 1y ago

    There is a drop-in, protocol-compatible replacement for ZooKeeper - ClickHouse Keeper: https://clickhouse.com/clickhouse/keeper Many applications depend on ZooKeeper's data model and client libraries, and can&#x27
13. 133.▲
    by zX41ZdbW 1y ago

    Distributed across 20 replicas.
14. 134.▲
    by zX41ZdbW 1y ago

    I use the approach of public apps built on top of free-form SQL queries. Examples: https://adsb.exposed/ - type any query and get a visualization. https://play.clickhouse.com/ - explore the database as you
15. 135.▲
    by zX41ZdbW 1y ago

    Yes, if we take the filtered and deduplicated HTMLs of CommonCrawl. I've made a video on this topic recently: https://www.youtube.com/watch?v=8yH3rY1fZEA
16. 136.▲
    by zX41ZdbW 1y ago

    I recommend taking a look at the ClickHouse SQL Lexer: https://github.com/ClickHouse/ClickHouse/blob/master/src/Par... https://github.com/ClickHouse/ClickHouse/blob/ma
17. 137.▲
    Distributed Cache for S3(clickhouse.com)

    2 points by zX41ZdbW 1y ago|0 comments
18. 138.▲
    by zX41ZdbW 1y ago

    I tried to add it to ClickBench, but the first CREATE TABLE statement leads to panic in Rust: https://github.com/tursodatabase/turso/issues/2058
19. 139.▲
    by zX41ZdbW 1y ago

    I've recently made a presentation on this topic: https://www.youtube.com/watch?v=8yH3rY1fZEA
20. 140.▲
    Complexity in Software Development(purplesyringa.moe)

    2 points by zX41ZdbW 1y ago|0 comments
21. 141.▲
    Benchmarking Postgres(planetscale.com)

    1 points by zX41ZdbW 1y ago|0 comments
22. 142.▲
    Fix the New Things First(antithesis.com)

    3 points by zX41ZdbW 1y ago|0 comments
23. 143.▲
    by zX41ZdbW 1y ago

    https://www.sec.gov/Archives/edgar/data/1579878/000162828025...
24. 144.▲
    Chdig – Dig into ClickHouse with TUI Interface(terminaltrove.com)

    2 points by zX41ZdbW 1y ago|0 comments
25. 145.▲
    Birds in the Cloud(clickhouse.com)

    1 points by zX41ZdbW 1y ago|0 comments
26. 146.▲
    Chdig – Dig into ClickHouse with TUI Interface(github.com)

    1 points by zX41ZdbW 1y ago|0 comments
27. 147.▲
    by zX41ZdbW 1y ago

    Load the data into MergeTree instead? https://clickhouse.com/docs/engines/table-engines/mergetree-...
28. 148.▲
    by zX41ZdbW 1y ago

    My SQL Playground can stream results and display them as a table: https://play.clickhouse.com/ And for a command-line client, clickhouse-client has been around since 2016.
29. 149.▲
    by zX41ZdbW 1y ago

    There is the "About" link at the bottom, pointing to the source code: https://github.com/ClickHouse/adsb.exposed/ In fact, the data processing pipeline is entirely trivial (a one-page shell script), and
30. 150.▲
    by zX41ZdbW 1y ago

    I have a similar visualization on top of ~150 billion data points of ADS-B data: https://adsb.exposed/ It is interactive, so you can filter by any dimension, like the types of aircraft you fly. It is 2D, but I thought about