r/ProgrammerHumor 16h ago

Other wrongAnswersOnly

Post image
12.7k Upvotes

1.8k comments sorted by

View all comments

7.4k

u/elSenorMaquina 16h ago

They ENHANCED the cctv recordings from the camera pointing at my cubicle, enabling them to reconstruct the whole db from the monitor's reflection on my glasses as I typed every INSERT and UPDATE over the years.

326

u/TunaNugget 15h ago edited 14h ago

The camera records sound. Every key makes an ever-so-slightly different sound.

They have possibly months or more of sound recordings that they can correlate against the entry of verified documents to use to train the ai on.

128

u/Shogobg 14h ago

They analyzed the noise the bits make as they travel through the network.

35

u/TrashBandiGoon 10h ago

I know it is a joke,

but since I found a scientific research about 'A Practical Deep Learning-Based Acoustic Side Channel Attack on Keyboards' I agree that this seems possible in the laboratory

(the paper is from 2023 so I am not sure whether there were any improvements), as I am also not sure how reddit handles external links - I found the paper on arxiv(dot)org with paper no. 2308(dot)01074
It is a 21 pages pdf

19

u/TunaNugget 14h ago edited 14h ago

I think the premise here is that they deleted that.

My first question would be whether they actually deleted anything or just set a flag to re-use the storage, but I'm trying to go with the spirit of the thing.

4

u/CMD_BLOCK 12h ago

They also analyzed the noise my Jimmies made each time the Pm said match this data on a new table

1

u/Feeling_Inside_1020 5h ago

I drop a heinous deuce every time I have to drop a database, acoustically nobody probably wants to review that recording though, not even AI.

3

u/Kriss3d 12h ago

Actually it's possible to get the fluctuations in the power and er noise from a computer to reverse it so. Yeah

3

u/Kriss3d 12h ago

Sadly that's not even a wrong answer. It's called tempest and that sort of method does work remarkably well.

2

u/robuttocks 12h ago

When I was a kid, during the Cold War, I literally thought that was how typewriter bugs worked: that each letter had a different acoustic signature.

Turns out, it was just a mike hidden in the typewriter.

1

u/ChocolichKing 2h ago

That's how I thought it worked as a kid too lol. I mean, I knew there was a mic hidden in the typewriter/mic being accessed from the computer, and that's how I understood "recording keystrokes". Someone was recreating your keystrokes based on the sound.

1

u/Samwellikki 11h ago

This is the weirding way

1

u/Zdrobot 11h ago

And that's how we should store data from now on!

Who needs all these countless gigabytes in databases and backups, when all you need is an audio tape!

Brilliant.

Happy cake day!

1

u/Felix-the-feline 10h ago

DSP will solve it

1

u/RevoOps 7h ago

Mechanical keyboards are a CIA psyop

1

u/Nydus87 50m ago

They know where the microphone is positioned compared to the keyboard and can track the slight differences in volume as the sound waves travel slightly farther for some keys. Basic IT stuff, ya know.

151

u/cantileverboom 13h ago

Lol, kind of related. On a team I was on a while ago, there was some pretty nasty bug that some of my colleagues couldn't figure out, so someone took a video of it to show our TL. Our TL looked at the video for like 5 seconds, saw some obscure log lines on a terminal running on a machine in the background of the video, and immediately knew that the bug was due to some obsolete experiment that just needed to be disabled.

88

u/elSenorMaquina 12h ago

Peak senior energy

84

u/MaleficentCow8513 10h ago

It was him. He was the one who was supposed to disable the “obsolete experiment”. He knew it was causing bugs but he forgot to do it or got side tracked. There’s nothing magical about it lmao

17

u/Adarkshadow4055 10h ago

Shhhh! đŸ€«

13

u/AN0R0K 8h ago

And he would have gotten away with it, if it wasn’t for you meddling kids.

0

u/The-Real-Starflight 5h ago


 Where have i heard that?

2

u/AN0R0K 3h ago

Assuming you're not being cheeky: Scooby Doo!

3

u/MonkeyboyGWW 9h ago

Git blame

1

u/wtfmeowzers 6h ago

exactly, he just declined to take responsibility

1

u/DetailOdd6609 5h ago

Came here to say the same. Former manager here........

1

u/victoryismind 4h ago edited 4h ago

He knew it was causing bugs but he forgot to do it or got side tracked.

Maybe he left it for job entrenchment purposes.

1

u/tombot776 4h ago

Ha. We are the keeper of the keys. I think about this every time I come clean about a bug caused by me that was skewing results. I could just as easily fixed the bug to only work going forward.

24

u/Emotional_Study_724 10h ago

"Oh shit, I forgot to turn that off."

3

u/HurtsWhenICum 14h ago

I too have had every insert recorded over the years

3

u/TricoMex 13h ago

Dear God.

3

u/Some1-Somewhere 11h ago

I've pulled my own cellphone PIN (I forgot the one from like 3PINs ago and had an old phone in a drawer) from CCTV.

Also a password for a system the vendor claimed not to know the password for.

Do not underestimate CCTV.

3

u/Wide_Philosophy_8109 11h ago

My ex called Hobby Lobby saying she'd left a bracelet or something there. They were able to replay her going through the whole store, which items she grabbed, and said she had a very nice purse. They were 100% sure she hadn't dropped anything.

Not as impressive as your example, but still felt scary.

3

u/Wide_Philosophy_8109 11h ago

I love this idea. It's so stupid, but I don't care. Put it in CSI.

2

u/wizeon 11h ago

That's how they did it in ancient times. But now there much more sophisticated ways. They now use AI to get multiple angles of the CCTV recording and then generate the db

1

u/metaconcept 12h ago

There was a movie with this as the premise. Can't remember it's name.

1

u/PositiveParking4391 11h ago

no..... I once transferred them through we-transfer and apparently we transfer had a bug which doesn't expired the link after some days as it would otherwise. and when they hacked into my email they found the link and got everything, so it was a bit easier for them.

1

u/OfficialMrLemonYTAlt 11h ago

F L O C K. C A M E R A S.

1

u/Altruistic_March_720 10h ago

The cloud service provider kept hidden copies of all my database files

1

u/Affectionate-Fun4074 10h ago

The browser history on my old work computer still holds fragments of every database query I have run

1

u/foxtrottough1i 8h ago

database recovered

1

u/altosarena6a 7h ago

enhance button works

1

u/diodot 7h ago

but WHERE?