DOOMQL

This article describes DOOMQL, a creative project by Peter Gostev that uses SQLite as a full game engine to render a Doom-like first-person shooter. The game handles movement, collision, enemies, combat, and pixel rendering entirely through SQL queries, including a ray tracer implemented with recursive common table expressions (CTEs). It runs as a Python terminal script and generates an SQLite database that can be explored using Datasette with a custom HTML+JavaScript app for a real-time minimap and screen display. The project showcases innovative use of SQLite beyond traditional data storage, blending game development with database technology.