Someone got Doom in an SQL database
Summary
A developer named Lukas Vogel created a version of the video game Doom that runs inside an SQL database. The game uses SQL queries to handle its logic and generate full-color graphics, showing that complex game data can be managed with database technology.Key Facts
- Lukas Vogel made Doom run using SQL queries inside a CedarDB database.
- The game logic is done with about 1,300 lines of SQL spread over 89 common table expressions.
- SQLDoom produces full-color 640×480 frames similar to the original Doom game.
- A small Python program manages input, timing, and displaying the game frames.
- Converting Doom’s game data into database tables was straightforward because of how the original game breaks down levels.
- Rendering floors and ceilings was challenging and required a special method different from the original game.
- SQLDoom can run at about 60 frames per second on a Ryzen 7 laptop, with some slowdown in busy scenes.
- Using a database helps keep game state consistent and could benefit multiplayer game servers.
Read the Full Article
This is a fact-based summary from The Actual News. Click below to read the complete story directly from the original source.
