4 ms·
The article says that NoSQL has no relations. Is that the case? I would have assumed that, say, you'd make a blog system by making user entries with a list of b
by tgb 6y ago
The article says that NoSQL has no relations. Is that the case? I would have assumed that, say, you'd make a blog system by making user entries with a list of blog post IDs and then each blog post gets its own entry with its data. If not, are you querying and processing a user's entire blog post history everytime you make an update?
- dragonwriter 6y ago> The article says that NoSQL has no relations. Is that the case? No, not as stated in the article. It is absolutely false that “no matter what format they store data in, these databases don’t support relations between data.” (that's particularly laughable for graph databases.) This sounds like the author knows that “nonrelational” is another term for “NoSQL”, but, as is distressingly common in the field, doesn't know what “relational” means. (It means it doesn't follow the relational model, who is centrally about (though the model has other elements) storing and operating on data in the form of “relations”, a particular logical abstraction (tables, views, etc., are all concrete realizations of this abstraction.)
- mercer 6y agoThe distinction between 'SQL' and 'NoSQL' has made less and less sense over time. I can add a JSONB column to my Postgres database and use SQL to query that data, index it, etc. So is that NoSQL or SQL? And while I'm not familiar with MongoDB, I used RethinkDB for a while and while I suppose it would be considered 'NoSQL' it had quite a number of features that I'd associate with a relational DB.
- jeff-davis 6y agoA "relation" in this context roughly means a table that can be manipulated with relational operations (e.g. join). https://en.m.wikipedia.org/wiki/Relation_(database) https://en.m.wikipedia.org/wiki/Relation_(database) EDIT: the sibling comment is right. The article's author seems confused.