Click-V: A RISC-V emulator built with ClickHouse SQL

A RISC-V emulator built with ClickHouse SQL. This emulator makes ClickHouse truly Turing complete. We are one step closer to running ClickHouse in ClickHouse. This project/repository isn't dev-friendly yet, I'm just uploading it here as a backup in case my PC catches fire. How it works The system will react to the following insert command: INSERT INTO clickv . clock (_) VALUES () This command will trigger a large set of branched materialized views and Null tables that filter out the program's instructions to simulate reading/writing from registers and memory. External host machine access works via a single UDF with a custom binary format that gets read/written as an Array(UInt8) . The program is able to perform any logic. Printing to a console table and drawing are built-in. It can also open/close/read/write/seek files and sockets via the ClickOS UDF. For more details, see the architecture section. Performance I tried to use every optimization trick in the book to get this t ... Read full article.