Newsplaining

Someone got Doom in an SQL database

SO SOMEBODY FINALLY LOOKED INTO IT AND ACTUALLY GOT ORIGINAL DOOM RUNNING INSIDE A RELATIONAL DATABASE TODAY, AND THE THING IS IT IS NOT JUST A GIMMICK BECAUSE A DEVELOPER NAMED VOGEL WROTE THIRTEEN HUNDRED LINES OF SQL OVER EIGHTY-NINE COMMON TABLE EXPRESSIONS IN CEDARDB, WHICH IS WILD BECAUSE IT RENDERS FULL COLOR SIX HUNDRED FORTY BY FOUR HUNDRED EIGHTY BITMAPS AT UP TO SIXTY FRAMES A SECOND ON A RYZEN LAPTOP! A LITTLE PYTHON CLIENT JUST DRAWS THE SCREEN AND TAKES INPUT, BUT THE WHOLE GAME LOGIC AND LEVEL GEOMETRY ARE STORED IN DATABASE TABLES WHERE A BASIC ORDER BY STATEMENT SOLVES THE WALL RENDERING, AND THE CEILINGS USE HACKY PANELS, AND VOGEL POINTS OUT THIS MEANS ZERO MULTIPLAYER DISPUTES OVER WHETHER ROCKETS HIT BECAUSE SNAPSHOTS DO NOT PERMIT PARTIALLY APPLIED UPDATES, WHICH MEANS THE CODE IS ON GITHUB RIGHT NOW. OK SOMEBODY ELSE TALK, MY THROAT HURTS.

A developer created SQLDoom, running the classic shooter’s game logic and rendering inside a CedarDB SQL database at up to 60 frames per second.

Read the whole thing
📰 Read the real story at Ars Technica Someone got Doom in an SQL database

Named in this and it is not fair or not accurate? Write to us — we correct or remove within a few days.