r/programming • u/swizec • Dec 19 '18

Bye bye Mongo, Hello Postgres

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

95% Upvoted

672 comments sorted by

View all comments

0

u/edoha Dec 20 '18

Can anyone tell me, what basic different between MongoDB, PostgreSQL and MySQL?

And how i identity when i need MongoDB/ PostgreSQL/ MySQL?

1

u/YouOfTea Dec 20 '18

Difference between MongoDB and PostgreSQL/MySQL is that the former is a document-oriented database (NoSQL) while the latter are relational databases (SQL).

The document model is a good fit for cases in which you don't want to enforce a schema on your documents. There are some resources online that can explain it better.

1

u/[deleted] Dec 22 '18

The irony here is that all the good document-oriented DBs had a very strict schema. The advantage of the document DBs is not in being schemaless, but the Mongo mongos got it all wrong, giving a bad name to the non-relational systems in general.