Doom runs in an SQL database: a technical feat

A programmer has made possible what many would consider madness: running the classic video game Doom inside an SQL database. Lukas Vogel, the creator of this project called SQLDoom, has used a Python client to handle the game's input and output, manage timing, and display each frame on the screen. This is complemented by CedarDB tables that track the game's geometry and state, while around 1,300 lines of SQL queries are spread across 89 common table expressions to implement game logic and generate 35 frames per second.

## Why it matters This project is a fascinating example of how creativity and programming can merge to achieve unexpected results. SQLDoom is not only a technical feat but also highlights the potential of databases in video game development, opening the door to new forms of interaction and design.

## What we know SQLDoom represents a significant improvement over Vogel's previous project, DoomQL, which attempted to create a fully multiplayer shooter in SQL but ended up with grayscale ASCII graphics reminiscent of Wolfenstein 3D. The evolution of these projects demonstrates progress in programming capabilities and the use of databases in unconventional contexts.

## What is still unclear However, questions remain about the viability and performance of SQLDoom compared to traditional gaming platforms. Can it truly compete in terms of gameplay and user experience? The answer to this question could define the future of video games in databases.