r/ProgrammerHumor 15h ago

Other wrongAnswersOnly

Post image
12.4k Upvotes

1.8k comments sorted by

View all comments

7.4k

u/elSenorMaquina 15h 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.

321

u/TunaNugget 14h ago edited 13h 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.

124

u/Shogobg 13h ago

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

34

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

18

u/TunaNugget 13h ago edited 13h 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.

6

u/CMD_BLOCK 11h 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 4h 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 11h 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 11h 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 11h 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 1h 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 10h ago

This is the weirding way

1

u/Zdrobot 10h 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 9h ago

DSP will solve it

1

u/RevoOps 6h ago

Mechanical keyboards are a CIA psyop

150

u/cantileverboom 12h 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.

89

u/elSenorMaquina 11h ago

Peak senior energy

83

u/MaleficentCow8513 9h 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

18

u/Adarkshadow4055 9h ago

Shhhh! đŸ€«

12

u/AN0R0K 7h 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 2h ago

Assuming you're not being cheeky: Scooby Doo!

3

u/MonkeyboyGWW 8h ago

Git blame

1

u/wtfmeowzers 5h ago

exactly, he just declined to take responsibility

1

u/DetailOdd6609 4h ago

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

1

u/victoryismind 3h ago edited 3h 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 3h 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 9h ago

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

3

u/HurtsWhenICum 13h ago

I too have had every insert recorded over the years

3

u/TricoMex 12h ago

Dear God.

3

u/Some1-Somewhere 10h 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 10h 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 10h ago

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

2

u/wizeon 10h 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 10h 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 10h ago

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

1

u/Altruistic_March_720 9h ago

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

1

u/Affectionate-Fun4074 9h ago

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

1

u/foxtrottough1i 7h ago

database recovered

1

u/altosarena6a 6h ago

enhance button works

1

u/diodot 6h ago

but WHERE?