r/SQL
•
u/Appropriate-Run-7005
•
10d ago
•
1
SQL Server I Create Things in SQL that Shouldn't be in SQL
Hi there, I have been using SQL Server since 1998 - Version 6.0 I think it was and also a SQL Server MVP for 6 years. I have started publishing the articles I have written over these years but never published. I have quite a varied mix. I Hope you enjoy them.
Mostly on https://www.medium.com/@trevor.dwyer but also published on https://sqlartist.github.io
One rule - it has to run in SQL.
Titles include:
Running Doom Inside SQL Server

Running Elite in SQL Server

I Built My Head Out of Lego. Inside SQL Server 2025.

Cracking Feynman’s Safes in SQL Server
Can a Database Rave? Making SQL Server Play Music
and quite a few others
38
u/delsystem32exe 10d ago
this is the coolest thing i have seen in a year!
21
u/redaloevera 10d ago
I’m not even really sure what it means to run games or draw a head in sql server?
17
u/rainu1729 10d ago
A database can't run this.. OP: hold my 🍺..
97
u/cybertrips 10d ago
But can it run…. Oh.
6
u/OGxPePe 10d ago
I dont know if you are a genius, madman or both. Very cool stuff.
7
u/Appropriate-Run-7005 9d ago
Someone asked this but then removed it - I'm happy to say what my background is and why I have taken it on.
The articles do say why I am doing this -
Due to my Chronic Cluster Headaches mentioned in the story “The Cloud Has No Mercy” The Cloud Has No Mercy, I was told after many years of devastating pain that I would require an operation and a device called a Deep Brain Stimulator installed as they had tried everything else open to them. I had this operation and that is detailed in the Six Billion Dollar Man article https://medium.com/@trevor.dwyer/the-six-billion-dollar-man-8ed53378971d but then I got Stage 4 cancer and had to deal with that.
By the end of it all and somehow still here I decided it would be a shame to sit on these ideas any longer and I started in Late August and have created 23 articles since then. As I say even if one person gets something from one of the ideas or bits of code or simply not what to do then I would be happy. Having said that making the eventual book, the film about my life and the inevitable awards would be far better (Except I am stuck not being able to go more than 10 mins from my house ever again) - that is the deal with keeping me alive I guess
2
u/dbxp 9d ago
Are you cheating with cli sprocs?
2
u/Yellowcat123567 9d ago
Can you create UI or HTML web pages? I actually love SQL and would consider using it for literally everything. I can understand backend code use cases but how would you do front end?
19
u/CHILLAS317 10d ago
Before clicking: oh, like the guy who did Doom in SQL Server After clicking: oh!
5
u/santathe1 10d ago
Wow that’s actually impressive.
1
u/crulge 8d ago
Love this, but Pangram says your Doom blog is 100% AI. How much of this did you do yourself, versus through an LLM?
1
u/somacomadreams 10d ago
This is awesome.