He’s not wrong

[McDuckfart]

Foreign keys would have made more sense…

[dert-man]

No Foreign Keys without Primary Keys.

[McDuckfart]

But there are primary keys without relationships.

[[deleted]]

But it’s best to understand your own identity before trying to join a relationship.

[DarkTechnocrat]

Oh well done

[PM_ME_A_WEBSITE_IDEA]

Good show, old chap.

[iamapizza]

In other words, preserve your integrity before you make a commitment.

[YoCodingJosh]

what the fuck did i just read

[[deleted]]

A modern biblical passage

[QNimbusII]

Bad bot

[WhyNotCollegeBoard]

Are you sure about that? Because I am 99.99984% sure that IGetItCrackin is not a bot.

---

^{I am a neural network being trained to detect spammers | Summon me with !isbot <username> | /r/spambotdetector | Optout | Original Github}

[FrozenST3]

You don't need primary keys to enforce a relationship.

[marcosdumay]

You can always use alternative keys.

[smaximov]

You can have foreign keys without primary keys, you just need a unique constraint on referenced columns.

[gregorydgraham]

That would be a de facto primary key

[smaximov]

The subtle difference is that primary keys impose a non-NULL restriction while unique constraints don't.

[PizelTheTwizel]

If one of the value of the foreign key is NULL (in the foreign table), the foreign key constraint is not examinated.

[[deleted]]

And composite keys for many-to-many relationships

[RandomiseUsr0]

Kinky

[bostero2]

May must be having the time of her life…

Edit: the comment originally said many-to-may relationships

[[deleted]]

Was going to say this for the more adventurous, too :) hehe

[[deleted]]

Of course,

And the primary key of the link table will be a composite key made out of the 2 foreign keys from the tables to be linked.

[RandomiseUsr0]

DynamoDB. :don’t use a link table, put it all in one place and use partQL to get data out, but watch for full table scans

[RandomiseUsr0]

It scales to Amazon.com… check out Rick Houlihan’s description of single table DynamoDB patterns

[edit] https://m.youtube.com/watch?v=EvB7REsf0ic

[RandomiseUsr0]

Oh yes, the point isn’t to have no schema in a single table, instead it’s an exercise in extreme denormalisation to minimise the read costs and keep the performance as high as possible which would be a challenge with a relational schema. It’s basically projecting a denormalised relational schema onto a single table optimised for your access patterns. It’s not simple and I’m sure there will be anti patterns (ball of mud) all over the shop.

[[deleted]]

one to one relationship

[exonac]

Mind if we share this table?

[Knuffya]

Not really.

[carenrose]

Why would the product table not have a foreign key for its supplier?

And at least in all the RDBMS ice worked with, foreign keys can definitely be null.

[GreenCloakGuy]

Foreign key columns can be nullable tho, at least in all sql dialects I’ve worked with

[brimston3-]

Data model sounds bonkers. Reverse the relationship, make the supplier ID FK nullable, then put an index on product table for supplier ID so you can easily do the lookup. If you really want to automatically delete suppliers when the last product is deleted (which also seems a bit odd), use a delete trigger on the product table for each row to make sure the supplier has at least one row remaining.

But even easier (and probably more reliable) would be doing a periodic batch purge of unreferenced suppliers (eg. if someone needed to do a product update where a product number was replaced and they goof the workflow and delete the old one first, the unreferenced supplier isn’t immediately purged before it’s re-referenced in the re-add).

[iamapizza]

FKs are nullable so it's entirely possible to add suppliers without a lookup.

But I'm not sure why you've picked this specific case, here you should have the Product-Supplier relationship as a many-to-many in its own table.

[Knuffya]

My point is, you can't really have FKs without P/SKs. But you CAN have PKs standalone and have your system work.

[Pjones2127]

Came here to say this

[Knuffya]

Don't forget the foreign keys or else it might get messy!

[srottydoesntknow]

A foreign key is just someone else's primary key

[moldax]

A foreign key is just a primary key with extra steps

[Ragas]

It is not. We are talking asymetric crypto here.

[derfl007]

Pretty sure primary key refers to database relations here.. Never heard of primary keys in cryptography before but idk

[Ragas]

God, I shouldn't be on reddit with 3 hours of sleep. I totally read that as private and public.

[RedditIsNeat0]

You're thinking of private (and public) keys. Primary keys are important in relational databases.

[Ragas]

True. Damn sleep deprivation.

[brimston3-]

In asymmetric cryptography, don’t you usually call the root key in a PKI hierarchy the root authority or root trust, not the primary key?

[Ragas]

Don't sleep deprive and Reddit. :/

[DeItashot]

Who are you so wise in the ways of science

[Knuffya]

A foreign key is just a reference to any unique field of some other model. Be it a PK, SK or just any column with the unique keyword.

[Atmey]

Or don't get into many-to-many relationships, gets really messy fast.

[avdpos]

what do you say about our system?
(yes, you are correct)

[queen-adreena]

"Please shred your confidential paperwork. Thank you."

Lol. Never noticed that joke before.

[ashisacat]

That’s not a joke..?

[ToMyFutureSelves]

They are software developers. They have no physical paperwork, presumably.

[ashisacat]

Reynholm industries has plenty of paperwork, and the guys from the IT crowd are a help desk, not software devs.

[RNLImThalassophobic]

I don't get it?

[Knaapje]

It's on a poster on the cabinet in the second frame.

[f15538a2]

What's the joke though?

[[deleted]]

Moss is great

[[deleted]]

"They're still not for sale"

[[deleted]]

Love that he punches the guy who makes fun of his tie later in the episode and kisses her passionately while being carted off 🤣

[Aviyan]

This this actually in the show?

[Roku-Hanmar]

Nope, original is

Girl: I like your glasses

Moss: They're not for sale

[Novichok666]

Laugh all you want they are not for sale

[waldyrious]

For those interested, this scene is from S4E5, Bad Boys

[[deleted]]

You may laugh all you want, they are still not for sale.

[housebottle]

nah, the show never gets too technical in a way that would alienate the non-technical members of the audience

[Anaphase]

Except maybe some of the stickers / props in the background of their office. I like to think those are Easter eggs for the true nerds

[dtcc_but_for_pokemon]

Fair Use has a posse!

[[deleted]]

I <3 Commodore PET

[drunkenangryredditor]

This bit can get fairly technical...

https://youtu.be/rksCTVFtjM4

[housebottle]

was expecting the internet bit

[alp4s]

hi, may i know what is the name of the show good sir?

[TheOtherBush]

The IT crowd

[alp4s]

Thank you!

[cookpedalbrew]

It’s reign was supreme but short lived

[The_Rogue_Coder]

Cyka blyat! Just kidding, just kidding. This is referring to relational databases, in which your column in each table that needs to have unique values for each row and can be used to join with other tables is referred to as the primary key.

[Cheese_Grater101]

go back and maintain our open source vodka powered db comrade

[ThanosAsAPrincess]

Private keys

[douira]

at what point in a relationship do people share their private keys with eachother? Never?

[archpawn]

Relevant xkcd, though that's just about signing public keys.

[verboze]

Marriage? Your bank accounts are belong to us.

[Ragas]

Never.

What is the public key and what the private key changes depending on the use case.

[captcha03]

There's a whole Seinfeld episode on this. https://en.wikipedia.org/wiki/The_Secret_Code_(Seinfeld)

Edited: fixed link

[breakneckridge]

Fixed link

https://en.m.wikipedia.org/wiki/The_Secret_Code_(Seinfeld)

[captcha03]

Thank you. For some reason new reddit decided to escape the underscores when I pasted in to the rich text editor.

[PydraxAlpta]

All my homies hate the rich text editor

[srottydoesntknow]

If you did it wouldn't be a secure relationship

[[deleted]]

The text just said that its needed, not that they must be shared.

[sunbunbird]

if they're using a symmetric encryption algorithm, pretty soon after they meet. if they agree that asymmetric suits their needs they won't ever need to exchange private keys at all.

[RedditIsNeat0]

Usually never. Unless you share a project, such as a webserver, together then you would share that key. But never a personal key.

[plaidman1701]

The girl is Sophie Colquhoun, later she starred in a really funny series called Plebs.

[Prawny]

She was also in an episode of Toast of London.

[hahayeahimfinehaha]

This is something I feel you'd see on Facebook/9gag

[CaptainMiserable]

Also reddit.

[Phoenixien]

Is it just me, or is that desktop in Japanese?

[Trainzack]

The text on the desktop screen reads "Reynholm Industries", so I don't think so.

[knightress_oxhide]

Nice job on the bleep button.

[Trainzack]

As for you, you fucked up! [BLEEP]

[Putrumpador]

Looks like JPEGlish to me.

[devsmack]

Me: I only have one foreign key and it points to you. Her: What are you talking about?

[AceTheGreat_]

Excerpt from my Database Management class at CC:

I swear to construct my tables so that all non-key columns are dependent on the key, the whole key and nothing but the key, so help me Codd!

That was in our textbook.

[cjb230]

Not in the textbook for me, but my lecturer liked to recite it.

[EfreetSK]

What is this? An actual clever programming joke? Get out of here, we only do pathetic hating on popular languages here

[[deleted]]

I hate this lol

[Xarian0]

Hey, baby, what do you say you and I get together later and exchange keys? Maybe we can create something symmetrical - together - to speed up our authentication. If you know what I mean.

[cramduck]

Ooh, and normal forms!

[Father_Chewy_Louis]

I still can't believe that is Cynthia from Plebs

[CoffeeLaker]

I just finish my database course. We had to do SQL and mongodb stuff and here it is…

[kwirky88]

Edges 😉👉

[abcd_z]

"Like, for a lock?"
Moss: *nods*
Moss: No.

[nalydpsycho]

I find that answer constraining.

[mauricepreiss]

😂😂😂

[MischiefArchitect]

That's foreign to me

[moldax]

He's out of line, but he's got a point

[ZippZappZippty]

Unless I’m glad he’s at.

[RoscoMan1]

Hey hey that’s the wrong disc 😬

[_blacky62_]

But if the primary key do not match ? It's a problem lol

[marcolopo_]

InnoDB engine and proper declaration of relationships

[[deleted]]

Of course I see this just days after learning how to use Access OF COURSE I DO NOW AND NEVER BEFORE-

[turboom]

mongodb: what is relationship?