News for hackers. Stuff that matters.
Re:Click-V: A RISC-V emulator built with ClickHouse SQL by meepmorp on Wednesday June 04, 2025 @09:36AM (#44180590)
based on this line from the readme, the answer to your question is likely "because":

> This emulator makes ClickHouse truly Turing complete. We are one step closer to running ClickHouse in ClickHouse.

Re:Click-V: A RISC-V emulator built with ClickHouse SQL by blyry on Wednesday June 04, 2025 @10:09AM (#44180913)
lol for sure, I'm genuinely curious though, like maybe op is a clickhouse dev? Or maybe they had the cursed idea and decided clickhouse was the best fit for various reasons?
Re:Click-V: A RISC-V emulator built with ClickHouse SQL by jitl on Wednesday June 04, 2025 @10:56AM (#44181370)
Postgres does not have incremental view maintenance for its materialized views like clickhouse does. This means the implementation strategy would need to be quite different. Perhaps triggers is enough and of course if you use functions then sure, you can make an emulator there too.
Re:Click-V: A RISC-V emulator built with ClickHouse SQL by blyry on Wednesday June 04, 2025 @10:12AM (#44180931)
okay did like 10 seconds of introspection and OP probably isn't the repo author, and the repo author definitely looks like they work at clickhouse
Re:Click-V: A RISC-V emulator built with ClickHouse SQL by cptnapalm on Wednesday June 04, 2025 @09:57AM (#44180797)
"Because" is always the most fun reason.