There is an ongoing joke that if a device can perform calculations and has a display it will be used to run Doom. The same way a programming language is considered successful if Doom has been ported to it. Lukas Vogel, has added one more language to the list of languages that were used to write a port of Doom entirely in SQL with CedarDB doing all the heavy lifting. His blog post (Building a DOOM-like multiplayer shooter in pure SQL) has a full writeup on the technical nuts and bolts of the implementation.
DOOMQL in action
Due to the limitations of the language and backend engine the implementation looks like an ASCII display instead of the the more familiar 3D art & sprites. That said this is an impressive achievement. I think this would be a good way to stress/load test a DB server. Atleast that is how I am going to pitch it, the next time I am involved in the setup and testing of a Database server.
Source :The Register: Just because you can render a Doom-like in SQL doesn’t mean you should
– Suramya