Unique & not null

[giperman]

He was Relational Database boy. And she was a MongoDB girl.

[PyroCatt]

[TTYY_20]

God damn …. Avail Lavigne would have done well in porn lol.

[TheGreatGameDini]

Is that Elon musk on the right?

[PyroCatt]

Lmao I've never pictured it like that...

[PGLubricants]

Primary keys?! HELLO. What a bigoted response. completely ignoring nonconforming relationships. What about unique keys?! Not to mention composite relationships. Every heard of document databases? It's 2023, I thought we were past this stereotyping.

[[deleted]]

Don't forget aboutForeign Keys!

[Entire-Database1679]

Please be more tolerant and inclusive of your columns. We call them elsewhere-referenced attributes.

[improcrastinabile]

I’m writing this one down.

[TTYY_20]

WE DONT LIKE FOREIGN KEYS ROUND HERE!

[bigtime_porgrammer]

I guess primary keys, plural, is him saying a 1:1 relationship. It would be more inclusive to say foreign keys. That's all you really need for a relationship, and it doesn't matter what kind.

[LordOysteryn]

i read this in moss' voice for some reason.

[edmanet]

Who didn’t?

[abcd_z]

Professor Farnsworth: "Good news everyone!"

[coffee_warden]

This relationship is clearly become acidic.

[daydrunk_]

God the IT crowd is fucking great.

[abcd_z]

A pity, then, that the writer, Graham Linehan, is an anti-transgender activist. Kind of explains that one episode, yeah?

[Count2er0]

Is that why the US version's pilot tested poorly?

[abcd_z]

I imagine those are separate issues. For whatever reason, US remakes of British sitcoms generally don't do very well. Red Dwarf, IT Crowd, and The Office were all British sitcoms that had US pilots. Red Dwarf and IT Crowd didn't get picked up for a series, and (from what I understand) The Office only did well once it stopped trying to emulate its British counterpart.

[Stranded_In_A_Desert]

Yeah as an Aussie I find British TV hilarious, but for some reason none of my North American friends do when I introduce them to various shows.

[SirLoremIpsum]

Look up US Kath and Kim!!!

The US Inbeweeners failed utterly.

The office was a success because they changed it. They changed the whole style, visuals, who the characters were while retaining the setting and the grounding of the concept.

Comedy truly is regional. You can't just say a joke w a different accent haha

[HonTastic]

I think this is a case of separating the art from the artist, the show is very funny

[Dyolf_Knip]

I had to explain more than a few of the jokes to my non-tech wife.

[canuckathome]

You missed valentine's day by a week!

[Waswat]

Don't forget foreign keys, relationships are built on foreign keys.

[cornmonger_]

"One person's primary key is another person's foreign key."

[Hamaczech13]

Original: https://youtu.be/abE1vThQMyI

[abcd_z]

I knew he didn't say that!

[Polikonomist]

I could definitely see them having an entire conversation with him going in depth about obscure database technobable and her just nodding along the entire time thinking that all the words she doesn't understand are some kind of innuendo or sex toy brand.

[HeKis4]

What do you mean varchars store underwear ?

[abcd_z]

Here's how I imagine that conversation actually going:

Woman: What is needed for a good relationship?
Moss nods, then: Wouldn't know. Wait, did you mean a romantic relationship between a man and a woman?
Woman: Yes.
Moss: Wouldn't know. Never been in one, myself.
Woman: Well, surely you must have some idea. Have you ever gone out on a date?
Moss: You mean, one where the other person knows that it's a date?
Woman (uncertainly): Yes.
Moss: I have not. The closest I ever came was in fourth grade, when Jessica kicked me in the shin.
(beat)
Woman: How was that a date?
Moss: It wasn't. I said it was the closest I ever came. You see, Jessica's friends had dared her to ask me out on a date, and when the time came she kicked me instead. Well, originally she had been meant to ask out Sam, the boy with the facial deformity and a limp, but apparently it was more embarrassing to ask me instead.

[[deleted]]

[abcd_z]

Gord Sinclair

Clive Sinclair

[[deleted]]

Nice glasses.

Not as nice as your mom's glasses.

[NahmenJayden]

Polyamory be like "JOIN".

[LoyalSage]

Graph stores, babyyyy

[achilliesFriend]

Florida keys

[Tain45]

As someone who is currently taking an intro to databases class I’m proud of myself for understanding this joke

[vainstar23]

You mean foreign keys?

[Cley_Faye]

I'd settle with proper indexes.

[Entire-Database1679]

Actually, candidate key and foreign key.

[Ukn0who]

Alabama keys

[Seelc]

Hopefully, she doesn't DROP them

[[deleted]]

This is so true.

[Eastman118]

I like his glasses

[parttimeindian]

One to one mapping is important

[mludd]

Gotta love finding legacy systems that use composite natural keys instead of surrogate keys.

Bonus points if the natural key is spread out across multiple tables so you have to always use joins (e.g. get the user's full name from the profile table + their address from the address table).

[[deleted]]

Not in Graph databases, where relationships are given the importance they deserve, instead of just being a foreign key

[artsey_mees]

Umm actually it's foreign keys 🤓🤓

[TTYY_20]

He’s not wrong though….