Peter Gostev built DOOMQL, a Doom-like game where SQLite functions as the engine rather than just a data store. The project runs as a Python terminal script where every movement, collision, enemy action, combat mechanic, progression step, and pixel on screen is calculated by SQL queries. A single recursive common table expression handles the ray tracing required to render the graphics.
The significance lies in demonstrating how relational databases can execute complex procedural logic without traditional game loops. This approach proves that high-fidelity interactive experiences are possible when the database itself drives the state. The setup allows developers to inspect the game world directly through the database interface.
* The game state is stored in a local SQLite file.
* A Datasette app refreshes the view every second.
* A tactical map displays player position and enemy locations.
