Someone got Doom in an SQL database

7 days ago by cm0002 to c/programming

300 lines of SQL querying renders accurate bitmapped views of Hell at 35 fps.
umbraroze 41 points 7 days ago

“My pistol will perform a SELECT query on a bullet and then use it to perform an INSERT INTO query on your head and truncate your life, you denormalized villain!”

(from review of Gore: Ultimate Soldier by Taylor Bell, 2002)

path: 0 26175681, hotness: undefined, score: 41, children: 0
PattyMcB 34 points 7 days ago

"An SQL" makes me unreasonably angry, but that's pretty awesome

path: 0 26173933, hotness: undefined, score: 34, children: 18
gastroglizzy 30 points 7 days ago

Not everyone calls it "sequel" https://learnsql.com/blog/sql-or-sequel/

If you want to be really pedantic, you could argue that Server Query Language (SQL) and Server English QUEry Language (SEQUEL) refers to two different things.

path: 0 26173933 26174354, hotness: undefined, score: 30, children: 15
some_designer_dude 14 points 7 days ago

FYI, SQL = Structured Query Language, not Server Query Language.

path: 0 26173933 26174354 26183452, hotness: undefined, score: 14, children: 0
Feathercrown 8 points 7 days ago

It's always fun to get a glimpse into how other people pronounce things with their usage of A vs AN. My favorite example is people who say "an historic".

path: 0 26173933 26174354 26181647, hotness: undefined, score: 8, children: 3
Trail 6 points 7 days ago

If you go by the Greek origin of the word (ιστορία), that's more correct. Correcter, if you will.

path: 0 26173933 26174354 26181647 26186219, hotness: undefined, score: 6, children: 0
sukhmel 4 points 6 days ago

This I at least can comprehend, as H is silent in some languages

I sometimes see it with words I can't even start guessing, can't remember which, but I think last time it was something starting with M or N after ‘an’

path: 0 26173933 26174354 26181647 26191443, hotness: undefined, score: 4, children: 1
Feathercrown 5 points 6 days ago

"an mnemonic"

language processing brain center implodes

path: 0 26173933 26174354 26181647 26191443 26191926, hotness: undefined, score: 5, children: 0
BlameTheAntifa 7 points 7 days ago

Some people pronounce Graphics Interchange Format Jiff. It does not make it right or socially acceptable.

path: 0 26173933 26174354 26174766, hotness: undefined, score: 7, children: 8
palordrolap 12 points 7 days ago

Some of us say hard g GIF, but prefer "ess-cue-ell" for SQL.

The former is an acronym and the latter is an initialism, and for me, that's what makes the distinction. Anything else is secondary.

path: 0 26173933 26174354 26174766 26178137, hotness: undefined, score: 12, children: 3
log 2 points 7 days ago

You say es-cue-ell.
I say squeal.

We are not the same.

path: 0 26173933 26174354 26174766 26178137 26181479, hotness: undefined, score: 2, children: 1
PokerChips 2 points 7 days ago

Oddly, I usually say "ess-cue-ell" but read it as sequel while reading the acronym in your first sentence.

path: 0 26173933 26174354 26174766 26178137 26185099, hotness: undefined, score: 2, children: 0
Feathercrown 8 points 7 days ago

The year is 2839939. The last GIF vs JIF joke is made. The sun explodes, killing everyone, and ridding the universe of the joke forever.

path: 0 26173933 26174354 26174766 26181644, hotness: undefined, score: 8, children: 0
SnoopSqueak 4 points 7 days ago

Choosey developers choose gif (jiff). It was deliberately meant to evoke the peanut butter ad.

path: 0 26173933 26174354 26174766 26175766, hotness: undefined, score: 4, children: 0
fruitycoder 2 points 6 days ago

"Welcome to Jraphics park!" *Sweeping score plays as loops of pictures of dinosaurs fill the scene"

path: 0 26173933 26174354 26174766 26200271, hotness: undefined, score: 2, children: 0
HelloRoot 2 points 7 days ago path: 0 26173933 26174354 26174766 26176929, hotness: undefined, score: 2, children: 0
degen 5 points 7 days ago

We should just stop naming things tbh

path: 0 26173933 26174354 26178657, hotness: undefined, score: 5, children: 0
Freycruze 3 points 6 days ago

Hi

path: 0 26173933 26192325, hotness: undefined, score: 3, children: 0
FizzyOrange 2 points 6 days ago

It's really not obvious that SQL is supposed to be pronounced sequel. If they wanted that they should have gone with a more contrived acronym.

path: 0 26173933 26199490, hotness: undefined, score: 2, children: 0
panda_abyss 23 points 7 days ago

I used to like doing interviews where I had the person (collaboratively) code conways game of life in SQL.

You don’t need to recursively write it. But seeing they understand how to translate logic into table based entries, do basic DML via updates (or I had a no dml template that just used the query results), using window functions and aggregates, case when’s, etc. gave a very good overview of their understanding of sql across a lot of features.

I provided the skeleton and the rules, and I’d help them through it. The goal was that it was fun and not horribly stressful, I made it clear I’d provide any answers to questions or functions or syntax they needed (because IRL they’d just google, so I’ll save them the time).

I think most candidates had fun with it.

path: 0 26174365, hotness: undefined, score: 23, children: 5
cm0002 19 points 7 days ago

I made it clear I’d provide any answers to questions or functions or syntax they needed (because IRL they’d just google, so I’ll save them the time).

That right there is the difference between a shit interviewer and a golden interviewer. And that goes for a lot of technical roles, far too many just throw a "whiteboard" at you and just expect you to figure it out without any outside help, even though it goes against how even experts get things done in the real world :/

path: 0 26174365 26174653, hotness: undefined, score: 19, children: 2
panda_abyss 13 points 7 days ago

There’s nothing worse than killing all momentum and dialogue while you wait for someone stressed out to waste 5 minutes google something and find the right documentation page. It just sucks.

I also made it clear I’d hire people no matter how far they got as long as they communicated their plan and were able to solve problems. It’s not a real task, in real life you message your boss and say you need more time. I’m looking for “would I work with this person” and “what skills do they have, where can they improve, where would they fit on the team”.

path: 0 26174365 26174653 26174763, hotness: undefined, score: 13, children: 1
Semi_Hemi_Demigod 8 points 7 days ago

You could make good money teaching people how to do a proper interview.

path: 0 26174365 26174653 26174763 26175045, hotness: undefined, score: 8, children: 0
NewDawnOwl 3 points 7 days ago

That interview sounds interesting. I took a few hours to implement Conway's Game of Life on my microtonal grid project, but doing it over SQL seems challenging at first.

But then again, a table is basically a grid, so .... interesting.

If you're still hiring, I'd love to give it a try :D

path: 0 26174365 26179270, hotness: undefined, score: 3, children: 0
olafurp 2 points 6 days ago

I'd love to be in that interview. I already started thinking about double buffering setup with a sproc to calculate next frame. Maybe reset table B, cursor iterate A, add adjecent counts into B, update all of b, swap tables...

Sounds fun

path: 0 26174365 26198976, hotness: undefined, score: 2, children: 0
01189998819991197253 4 points 6 days ago

Why is it called SQL, if it's the first one?

I'll see myself out...

path: 0 26202954, hotness: undefined, score: 4, children: 0
notptr 3 points 7 days ago

Awww great my database is 2.5D.........

path: 0 26181557, hotness: undefined, score: 3, children: 0
programming
programming

@programming.dev

login for more options
28795
3717
3364

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Rules

  • Follow the programming.dev instance rules
  • Keep content related to programming in some way
  • If you're posting long videos try to add in some form of tldr for those who don't want to watch videos

Wormhole

Follow the wormhole through a path of communities !webdev@programming.dev


go to feed...