zX41ZdbW

18 ms·

1. 151.▲
   Azure SQL Managed Instance Storage Is Regularly as Slow as 60 Seconds(kendralittle.com)

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

   Also, I'd like to share a musical synthesizer in SQL: https://github.com/ClickHouse/NoiSQL (my project).
3. 153.▲
   by zX41ZdbW 1y ago

   What is the data source?
4. 154.▲
   by zX41ZdbW 1y ago

   It is also worth looking at the number of unique repositories for each agent, or the number of unique large repositories (e.g., by the threshold on the number of stars). Here is the report we can check: https://play.clickhouse.co
5. 155.▲
   by zX41ZdbW 1y ago

   It's likely I've posted a link to playground before, https://play.clickhouse.com/ but it's unlikely I've posted a way to connect to it with ssh and this particular query. Feel free to share if you like!
6. 156.▲
   Archil – POSIX filesystem backed by S3(docs.archil.com)

   1 points by zX41ZdbW 1y ago|0 comments
7. 157.▲
   10-20x Faster LLVM -O0 Back-End(discourse.llvm.org)

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

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

   Also, there is a music synthesizer built on ClickHouse: https://github.com/ClickHouse/NoiSQL
10. 160.▲
    by zX41ZdbW 1y ago

    My favorite database, ClickHouse, does it out of the box.
11. 161.▲
    by zX41ZdbW 1y ago

    I'm also collecting this data, and it allows rendering beautiful heatmaps like here: https://github.com/ClickHouse/ClickHouse/issues/59020 Try: ssh play@play.clickhouse.com SELECT id, max(score
12. 162.▲
    by zX41ZdbW 1y ago

    For those interested in birdwatching, I also recommend checking a web app: https://adsb.exposed/?dataset=Birds Explanation: https://clickhouse.com/blog/birds
13. 163.▲
    by zX41ZdbW 1y ago

    Here are 75 queries from various benchmarks, that form the version benchmark: https://benchmark.clickhouse.com/versions/
14. 164.▲
    Distributed Cache for AWS S3(clickhouse.com)

    1 points by zX41ZdbW 1y ago|0 comments
15. 165.▲
    by zX41ZdbW 1y ago

    Nice trick: > How is it faster than std: It uses the fact that popcount of a uniformly distributed integer follows a binomial distribution. By rescaling that binomial distribution and adding some linear fill we can achieve a curve very s
16. 166.▲
    Jemalloc Repositories Are Archived(github.com)

    39 points by zX41ZdbW 1y ago|7 comments
17. 167.▲
    by zX41ZdbW 1y ago

    Currently, it's unclear why - I didn't find any information in their public channels.
18. 168.▲
    by zX41ZdbW 1y ago

    There is the "versions benchmark," which includes a lot of queries with JOINs and compares ClickHouse performance on them: https://benchmark.clickhouse.com/versions/
19. 169.▲
    by zX41ZdbW 1y ago

    Wow, this is precisely how ClickHouse stores table metadata! A set of .sql files in the directories, corresponding to databases.
20. 170.▲
    by zX41ZdbW 1y ago

    clickhouse-local is very handy for these tasks: $ echo "2a00:1450:400e:80c::200e 2606:4700::6810:85e5 2a03:2880:f145:82:face:b00c:0:25de 2603:1030:c02:8::14 2603:1030:20e:3::23c 2603:1030:b:3::152 2603:102
21. 171.▲
    by zX41ZdbW 1y ago

    FYI, I did exactly this five years ago: https://ghe.clickhouse.tech/#github-roulette It is done with a single SQL query, and the data is continuously updated: https://play.clickhouse.com/play?user=play#U0VMR
22. 172.▲
    by zX41ZdbW 1y ago

    It is more complex. The batch is written to a temporary directory. Then we have to do an atomic commit into three different places: on disk, which can be external storage as well (rename the temporary directory), in memory (to the data stru
23. 173.▲
    by zX41ZdbW 1y ago

    This can affect hosting databases in GitHub repositories. Yes, it does not look like an intended service usage, but I used it for a demo: https://github.com/ClickHouse/web-tables-demo/ Anyway, will try to do the s
24. 174.▲
    by zX41ZdbW 1y ago

    H3 and S2 are supported out of the box in ClickHouse and have reference libraries in C and C++. But it looks like A5 only has a reference implementation in TypeScript. Porting would not be a problem, though...
25. 175.▲
    by zX41ZdbW 1y ago

    100 is the default, and can be changed at runtime. The deduplication works regardless of server restarts, and it does not matter when a request goes to another replica, as it is implemented with a distributed consensus (RAFT) via clickhouse
26. 176.▲
    by zX41ZdbW 1y ago

    ClickHouse provides idempotent atomic inserts, so the insertion of the same batch can be safely repeated. The client can provide its own idempotency token or rely on the block hash.
27. 177.▲
    by zX41ZdbW 1y ago

    > after he fell down the PRNG rabbit-hole by circumstance Curious to learn more about the circumstance :)
28. 178.▲
    by zX41ZdbW 1y ago

    Also interesting to include PCG for comparison.
29. 179.▲
    by zX41ZdbW 1y ago

    Sierpinski also sounds nice in music. Examples here: https://github.com/ClickHouse/NoiSQL
30. 180.▲
    by zX41ZdbW 1y ago

    The usage in ClickHouse database: https://github.com/ClickHouse/ClickHouse/blob/d2697c0ea112fd... Aside from a few problems in specific Linux kernel versions, it works great.