Building a DOOM-like multiplayer shooter in pure SQL
a day ago
- #SQL
- #database
- #gamedev
- DOOMQL is a multiplayer DOOM-like shooter built entirely in SQL using CedarDB.
- Game state, including players, mobs, and inputs, is stored in database tables.
- Rendering is done via SQL views implementing raycasting and sprite projection.
- The game loop is a shell script executing SQL ~30 times per second.
- Clients interact with the game by sending SQL queries for rendering and input.
- Players can cheat by sending raw SQL commands due to lack of access control.
- Performance is ~30 FPS at 128x64 resolution, outperforming DuckDB DOOM.
- The project demonstrates the feasibility of using SQL for game logic and state management.
- All code is available on GitHub, with instructions for running the game via Docker.