[r]evolution Summer 2022: Wasm Space Program

The author aims to build a universe simulation where millions of spaceships make real-time decisions in a massive universe, supported by a unique database called the Wasm Space Program. This project requires a database that can handle large volumes of transactions and analytics, as well as high concurrency for thousands of clients. The author finds SingleStoreDB 7.9 meets these requirements with its Hybrid transactional/analytical processing (HTAP) capabilities, extensibility, and support for WebAssembly (Wasm). The program uses the Code Engine - Powered by Wasm feature to run Rust code directly within SQL queries, Workspaces to isolate portions of the workload, and the Data API to connect directly from a browser to SingleStoreDB. The project results in a real-time simulation where spaceships interact with each other and their environment, providing an engaging experience for players.