Thread

1. eterm · 1785954512 · focus · HN ↗

   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.

2. jauntywundrkind · 1785961459 · focus · HN ↗

   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.

   <a href="https:&#x2F;&#x2F;github.com&#x2F;ClickHouse&#x2F;ClickBench&#x2F;tree&#x2F;main&#x2F;playground" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;ClickHouse&#x2F;ClickBench&#x2F;tree&#x2F;main&#x2F;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.

   1. zX41ZdbW · 1785962772 · focus · HN ↗

      Thanks! There is a write-up: <a href="https:&#x2F;&#x2F;clickhouse.com&#x2F;blog&#x2F;clickbench-playground" rel="nofollow">https:&#x2F;&#x2F;clickhouse.com&#x2F;blog&#x2F;clickbench-playground A lot of interesting things around hosting it.
3. cvince · 1785969987 · focus · HN ↗

   Really cool idea. Skimmed the writeup, but none of this is emulated???

   1. zX41ZdbW · 1785977755 · focus · HN ↗

      All databases are hosted in VMs. Most of them only support amd64, so the host machine is also amd64 - this is the only limitation. It uses hardware virtualization, so nothing is emulated.

Unofficial Hacker News client; not affiliated with Y Combinator.