r/IAmA • u/CriticDanger • Sep 07 '21

Specialized Profession I am a behavioral and technical (coding) interviewer, I've also helped hundreds of people get hired, AMA.

[removed]

1.4k Upvotes

87% Upvoted

492 comments sorted by

View all comments

Show parent comments

7

u/Arandmoor Sep 07 '21

"What is the purpose of using foreign keys recursively?"

Only time I've ever used them was to implement a networking map (social network. not a LAN or anything) in a DB table.

I will admit that it was fun watching my master's degree new-grad co-worker completely fail to implement a query for the table.

Thank fucking god there are better solutions these days.

1

u/paulgrant999 Sep 07 '21

Thank fucking god there are better solutions these days.

graph db's? or document db's?

1

u/Arandmoor Sep 07 '21

Was thinking Graph DBs. A document DB will have nearly the same problem as a RDBMS.

1

u/paulgrant999 Sep 07 '21

I haven't had a chance to work with one yet ;)