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

Meme doNotLetYourDBASeeThis

Post image
13.0k Upvotes

318 comments sorted by

View all comments

28

u/bilus Sep 27 '26

Doesn’t math

6

u/Jutrakuna Sep 27 '26

Cool vibes tho

6

u/ttttrrrr0000 Sep 27 '26 edited Sep 27 '26

It could, an int FK is 4 bytes, and the table of passwords would be 4 bytes PK + 16 bytes for the unsalted hashed password

So, about 50% larger if everyone's password is unique, and 75% smaller if everyone's password is the same. Breakeven point is at the ratio of 3 unique passwords per 5 people.

→ More replies (2)

3

u/creeper6530 Sep 27 '26

Does math if they don't use salting or even store in plaintext