6 pointsby zX41ZdbW2 hours ago2 comments
  • jauntywundrkinda few seconds ago
    Incredible! This is amazing!

    README says it downloads onto a host the dataset, (builds if needed then) runs a snapshotted firecracker microvms that exposes a small /query endpoint. A monitor records and posts results.

    https://github.com/ClickHouse/ClickBench/tree/main/playgroun...

    Was a little hard to find in the changelog myself (unaided) since there has been such a massive flood of results getting added! Salute to that!! Epic work.

  • eterm2 hours ago
    That's actually neat, I can finally do a full sweep of something I found after the recent post about Lobsters migration, I came across a query that evaluates differently in MariaDB and SQLite.

        SELECT CASE WHEN 1 / 5 * 100.0 = 1 * 100.0 / 5 THEN 1 ELSE 0 END AS Huh
    
    In some engines that evaluates to 1 and in some it evaluates to 0.

    In some ( oracle ), it doesn't evaluate at all without a trick to bind it to a table.