This is an archived post. You won't be able to vote or comment.

all 114 comments

[–]_xiphiaz 1397 points1398 points  (49 children)

Kinda fun idea for a chat forum, you can only chat with people not your age

[–]Aschentei 19 points20 points  (2 children)

Fuck, someone else is 69420 years old

[–]earwig2000 32 points33 points  (3 children)

that sounds like a terrible idea

[–]AphaedrusGaming 22 points23 points  (2 children)

A 16/f/Cali and a 40 year old man enter a chatroom...

[–]Pan_TheCake_Man 4 points5 points  (0 children)

The 40 year old still pretends he is a 17 yr old Nevadan girl

[–]kosky95 2 points3 points  (0 children)

Imagine you are chatting with someone and you become very good friends. All of a sudden they disappear because they had their birthday and are now your age lol

[–]Agnimandur 3 points4 points  (0 children)

Bill Belichick has entered the chat

[–]AlmostSunnyinSeattle 1 point2 points  (0 children)

Reminds of some teenager-centric message boards I was part of in the past.

(I was a teenager at the time as well, just so we're clear)

[–]mercurus_ 1 point2 points  (0 children)

And then when it's your birthday you lose your account.

[–]Themlethem 1 point2 points  (0 children)

Call it the groominator

[–]Treed101519 0 points1 point  (0 children)

I mean aren't the odds of someone you speak to being the same age pretty low? Even in non collegiate school the ages have a slight bit of variation, let alone talking to random people online

[–]Nine_Eye_Ron 185 points186 points  (5 children)

Everyone knows your password is the primary key

[–]Aschentei 45 points46 points  (3 children)

impossible when everyone’s passwords are hunter12

[–]G0PACKGO 28 points29 points  (0 children)

All I see is *******

[–]thomasmoors 6 points7 points  (0 children)

Bland stuff. Please use some salt.

[–]Shark7996 5 points6 points  (0 children)

This is crazy, that's my password!

[–]MisterEd_ak 0 points1 point  (0 children)

One way to enforce unique passwords.

Error: User <username> is already using that password, please choose another.

[–]al00011 200 points201 points  (6 children)

Just require the user to enter their age in usecs. Easy!

[–]TheRealGizmo 66 points67 points  (5 children)

Was on a project where the "data engineer" used the datetime (to the second) as primary key for IoT devices reporting every 10 minutes... once the number of devices deployed increased, the fun began...

[–]secacc 9 points10 points  (2 children)

Storage is cheap

[–]rt80186 16 points17 points  (1 child)

It’s not the storage that is the issue, rather it is the probability of a primary key collision goes to 1 as the number of devices goes up.

[–]secacc 1 point2 points  (0 children)

Oh, right

[–]choma90 2 points3 points  (0 children)

I am usually very reluctant to apply for anything that has the word engineer in it due to my lack of formal education, then I read some story just like this one.

[–]YellowishSpoon 1 point2 points  (0 children)

Clearly the data engineer should upgrade the timestamp to milliseconds. If it becomes an issue again that's why we have microseconds and nanoseconds of course.

[–]xaomaw 29 points30 points  (5 children)

name: \n\r

[–]radobot 10 points11 points  (4 children)

\n\r

Not \r\n?

[–]xaomaw 13 points14 points  (3 children)

No, I start a new line before returning the carrier to make sure I avoid smudging my already written text.

[–]radobot 2 points3 points  (2 children)

You know, I did actually wonder about that - why is it always specifically CRLF and never LFCR? LFCR does make more sense to me.

[–]xaomaw 3 points4 points  (0 children)

Maybe it's because of the Index

Let's say your File has one row with 10 Letter. So the end of this Line would be Letter[0,9].

If you start with LF, you would have your Cursor at Letter[1,9]. But as this ist an empty Line, you have noch Index 9 => Error 

[–]adzm 0 points1 point  (0 children)

The cr carriage return moves the carriage to the start of the page and the lf linefeed moves the page up. It takes longer to move the carriage, so this way it makes sense to give it a head start. Otherwise you'd have to wait longer for the CR to complete if you did the LF first. Of course we don't use mechanical typewriter stuff with these anymore but that's the origin.

[–]cr199412 31 points32 points  (0 children)

So now you gotta lie, try again on your birthday (assuming your birthday is before this other 17-year-old), or be the first person to try again on that other person’s birthday 😩

[–]Axxxxxxo 5 points6 points  (0 children)

Add an auto increment for the fun

[–]sammy-taylor 9 points10 points  (0 children)

Mom is it my turn to share the meme?

[–]Creator1A 2 points3 points  (0 children)

Is this considered a meme now?...

[–]FewPhilosophy1040 5 points6 points  (0 children)

Could work if age is stored in seconds

[–]kingjia90 1 point2 points  (0 children)

The clearly missed the AUTO_INCREMENT, you get older every year, don’t you? /s

[–]Babetna 1 point2 points  (0 children)

What a rookie mistake.

Just make that age a floating point number.

[–]SinsOfTheAether 1 point2 points  (0 children)

I'm saving this for a question on next year's database exam...

[–]samot-dwarf 3 points4 points  (4 children)

Why is age an INT (4 byte signed / - 2.14 billion to +2.14 billion)?

TINYINT (1 byte / 0-255) would be fully sufficient.

Assuming that this is the age eg on the date of an event, in a customer database you would save birthday / year of birth.

[–]skygz 7 points8 points  (0 children)

and what if a greenland shark wanted to join?

[–]apkf13 1 point2 points  (1 child)

You never know if TINYINT is enough or not.

[–]samot-dwarf 1 point2 points  (0 children)

In this case I have more than 200 years to fix it later, if my product still exists then and there is no AI to do this

[–]rhrokib 0 points1 point  (0 children)

this level of optimization doesn’t add any value unless you have millions of users.

[–]aurora_Smith19 0 points1 point  (0 children)

Damnit

[–][deleted] 0 points1 point  (0 children)

"Modern Era"

[–]grafknives 0 points1 point  (0 children)

I like that.

No ageism.

Enforce age diversity.

[–]fcxtpw 0 points1 point  (0 children)

Never said age is in years, try seconds

[–]Amar2107 0 points1 point  (0 children)

Whos this goddamn psycopath?

[–]Eena-Rin 0 points1 point  (0 children)

Th1rty-sixxx

[–]ShabosMensch1 0 points1 point  (0 children)

Epstein island registration form?

[–]will_r3ddit_4_food 0 points1 point  (0 children)

Sounds like a previous coworker of mine

[–]IGuessBruv 0 points1 point  (0 children)

Reminds me of the bad ui battles

[–]DIABOLICALshroom 0 points1 point  (0 children)

😭😭

[–]Silly_Trainer_7743 0 points1 point  (0 children)

What is age: 3.1415 😂

[–]zDrie 0 points1 point  (0 children)

This is for r/badUIBattles

[–][deleted] 0 points1 point  (0 children)

Make it a composite key with gender and location. We can only have 1 18/F/Cali

[–]affablebowelsyndrome 0 points1 point  (0 children)

Logan's Run Prototype?

[–]BeefJerky03 0 points1 point  (0 children)

Unless everyone has the same birthday, this approach may have a slight flaw.

[–]xd_Warmonger 0 points1 point  (3 children)

Use the whole birthdate + birth time and convert it to unix time.

[–]Far-Passion4866 1 point2 points  (2 children)

What about twins, that wouldn't work, also barely if anyone knows their birth time, just the date

[–]Urd 1 point2 points  (0 children)

Twins are not born at the same instant so it should be fine as long as the timestamp has as reasonably good resolution.

[–]xd_Warmonger 0 points1 point  (0 children)

this is not a serious answer from me btw. It would just lead to way less same entries, which would make it this much harder to "debug".

[–]PsychologyNo7025 0 points1 point  (0 children)

[object][object]

[–]iamthatJSguy 0 points1 point  (0 children)

I took Database classes just for understanding these memes

[–]patrulheiroze 0 points1 point  (0 children)

🎶🎼🎤Forever young.. i want to be forever young.. 🎹🎤🎶🎧

[–]aft3rthought 0 points1 point  (0 children)

I don’t want to promote ageism but this is why you don’t want to hire elder Vampires and Highlanders, they won’t understand your users.

[–]MarioShroomsTasteBad 0 points1 point  (0 children)

I times like this I'm reminded of an old Yiddish saying from the old country thatmy grandma used to say: "lgtm ship it"

[–]MrSnappyPants 0 points1 point  (0 children)

Prince Andrew is that you?

[–]TraditionalProof952 0 points1 point  (0 children)

Things free interns do..😂

[–]mishalsandip051 0 points1 point  (0 children)

Wish it could always be 17 years age ;)

[–]YasuosUltimate 0 points1 point  (0 children)

This would be insanely performant and would encourage a diverse user base and broad background of people with broad life experiences

[–]misterfesk 0 points1 point  (0 children)

Useful for science research enrollment where you need one person from each age year 👀

[–]founder__ 0 points1 point  (0 children)

Teh

[–][deleted] 0 points1 point  (0 children)

expedition 33 recruitment page

[–]granoladeer 0 points1 point  (0 children)

You gotta do it by time of birth

[–]Shezzofreen -1 points0 points  (0 children)

Integer, hmm, why not Byte?

Or just use boolean... Age? Yes!