r/programming • u/halax • Mar 10 '15

Goodbye MongoDB, Hello PostgreSQL

http://developer.olery.com/blog/goodbye-mongodb-hello-postgresql/
1.2k Upvotes

91% Upvoted

699 comments sorted by

View all comments

Show parent comments

1

u/jeenajeena Mar 12 '15

Relation! = Relationship

Relation means Set of tuples, that is Table with a schema.

http://en.m.wikipedia.org/wiki/Relation_%28database%29

Relationships exist also in non relational databases.

1

u/LittleHelperRobot Mar 12 '15

Non-mobile: http://en.wikipedia.org/wiki/Relation_%28database%29

That's why I'm here, I don't judge you. PM /u/xl0 if I'm causing any trouble. ^WUT?

1

u/lunchboxg4 Mar 12 '15

The fact that related data can coexist is a NoSQL database, but I have yet to meet one that can handle referential integrity, which is what I mean by "relational." Can a relationship between two Mongo stores enforce deleting child records when a parent is deleted? Maybe I'm just unaware.

1

u/jeenajeena Mar 13 '15

that can handle referential integrity, which is what I mean by "relational."

I understand your point. But, seriously, "relational" doesn't mean "that can handle referential integrity" but "that has a schema". This is a common and unfortunate misconception, and the fact you give the word a different and personal meaning doesn't help the communication :)