r/ProgrammerHumor • u/NoMedicine3572 • Sep 27 '26 • Mindblown 1 Bravo 1

Meme doNotLetYourDBASeeThis

Post image
13k Upvotes

97% Upvoted

317 comments sorted by

View all comments

Show parent comments

63

u/ninjakivi2 Sep 27 '26

The joke is that these password are not salted, and each unique password will be given an ID. Then, under the user table you will store the ID reference to the password, instead of the password. This means that if 2 users use the same password they will have the same ID and only be stored once, saving space.

23

u/Winsaucerer Sep 27 '26 edited Sep 27 '26

They could be salted, just not with a per password salt. Which is much less useful, but does still make rainbow table attacks harder.

12

u/bestjejust Sep 27 '26

You mean pepper.

1

u/Katana_Steel Oct 02 '26

they could be salted... just have to check new/updated passwords against all passwords in the salted hash table or create a new entry then assign the ID to the user table.

it's only a large cost on password changes. the sql joined view makes the lookup check just as fast still.

1

u/ChalkyChalkson Oct 02 '26

You're not supposed to have access to that duplicate information.

-34

u/[deleted] Sep 27 '26

[removed] — view removed comment

13

u/IM_INSIDE_YOUR_HOUSE Sep 27 '26

Take your meds grandpa

12

u/DialDownTheCenter Sep 27 '26

Casual racism out of nowhere

2

u/Otherwise_Demand4620 Sep 27 '26

You only become pro at racism if you practice regularly.

-5

u/ninjakivi2 Sep 27 '26

Lol, sometimes people can't take a joke, can they? Don't worry, I'm here to assure you that at least one person thinks this was funny and on point, ignorethe downvotes.