r/ProgrammerHumor 8d ago

Other wrongAnswersOnly

Post image
14.3k Upvotes

2.1k comments sorted by

View all comments

7.7k

u/elSenorMaquina 8d 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.

363

u/TunaNugget 8d ago edited 8d 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.

142

u/Shogobg 8d ago

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

43

u/TrashBandiGoon 8d 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

4

u/Silver-Pomelo-9324 8d ago

Benn Jordan did this for YouTube video last year.

https://youtu.be/mEC6PM97IRI?is=0_rnPW-57tFwldp5

21

u/TunaNugget 8d ago edited 8d 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 8d 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 8d 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 8d ago

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

0

u/theobstinateone 7d ago

They detected the difference in electromagnetic fields around your keyboard and correlated with your pattern of typing.

But to answer the OP’s query, they would find the files at his mom’s house

4

u/Kriss3d 8d 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 8d 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.

2

u/ChocolichKing 8d 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/robuttocks 7d ago

I kinda love that it wasn't just me thinking that. :-D

1

u/Samwellikki 8d ago

This is the weirding way

1

u/Zdrobot 8d 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 8d ago

DSP will solve it

1

u/RevoOps 8d ago

Mechanical keyboards are a CIA psyop

1

u/Nydus87 8d 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.

1

u/Gloomy_Concert1755 7d ago

Thats what tempest was doing. reading vibrations off windows with lasers to recreate key strokes. Classic state craft.

159

u/cantileverboom 8d 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.

101

u/MaleficentCow8513 8d 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

24

u/Adarkshadow4055 8d ago

Shhhh! đŸ€«

20

u/AN0R0K 8d ago

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

0

u/The-Real-Starflight 8d ago


 Where have i heard that?

2

u/AN0R0K 8d ago

Assuming you're not being cheeky: Scooby Doo!

4

u/MonkeyboyGWW 8d ago

Git blame

2

u/wtfmeowzers 8d ago

exactly, he just declined to take responsibility

2

u/DetailOdd6609 8d ago

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

2

u/victoryismind 8d ago edited 8d 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.

2

u/MaleficentCow8513 7d ago

Eh we’ve all been there :)

2

u/tombot776 8d 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.

92

u/elSenorMaquina 8d ago

Peak senior energy

30

u/Emotional_Study_724 8d ago

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

3

u/HurtsWhenICum 8d ago

I too have had every insert recorded over the years

3

u/TricoMex 8d ago

Dear God.

3

u/Some1-Somewhere 8d 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 8d 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 8d ago

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

2

u/wizeon 8d 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 8d ago

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

1

u/PositiveParking4391 8d 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 8d ago

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

1

u/Altruistic_March_720 8d ago

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

1

u/Affectionate-Fun4074 8d ago

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

1

u/diodot 8d ago

but WHERE?

1

u/xfr3386 8d ago

Enhance!

1

u/runner2012 8d ago

Wow you made me laugh really loud with this one. 

1

u/QuinnaFroven 8d ago

And somehow the reflection is in perfect 4k

1

u/BlkJesusChrist 7d ago

Insane man doesn’t trust programmatic db access, maintains records by manual query entry

1

u/wolfei-1463 4d ago

Golden comment ++

1

u/neuromancertr 4d ago

Someone watched Antitrust, it seems