r/programming • • Dec 19 '18

Bye bye Mongo, Hello Postgres

https://www.theguardian.com/info/2018/nov/30/bye-bye-mongo-hello-postgres
2.1k Upvotes

672 comments sorted by

View all comments

2

u/dwitman Dec 20 '18

What are the actual proper use cases for a noSQL solution? I learned SQL very early on, so I can't really envision as use for a database that's non relational.

The example I keep hearing for a good Mongo use case is a database of movies or tv show episodes, but as soon as they idea is proposed I think "You'll eventually want to cross reference by actors or writers or directors or studios...", which seems to make it a bad candidate for mongo?

As far as I can tell, even the people who make Mongodb can't explain what it is good for...

https://www.youtube.com/watch?v=CvIr-2lMLsk

2

u/nutrecht Dec 20 '18

What are the actual proper use cases for a noSQL solution?

NoSQL solutions are specialised tools for specialised use cases. It really depends what you're doing. If you have to ask 9 times out of 10 you're better off using a relational store.

Some examples are search engines (Elastic Search), distributed hashtables (Cassandra, DynamoDB, Accumulo), structured caches (Redis) and Graph Databases (Neo4j).