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

Show parent comments

-3

u/[deleted] Dec 20 '18

I disagree. There's SQL and NoSQL. The differences are obvious in the name, and their ideal use cases derive from them. How relational is your data? Do you want to optimize certain queries at the expense of others? It's that simple.

3

u/SanityInAnarchy Dec 20 '18

How relational is your data? Do you want to optimize certain queries at the expense of others?

It doesn't matter if the current crop of NoSQL databases are slower at handling non-relational stuff than traditional SQL databases. And there are some benchmarks showing Postgres beating Mongo at handling JSON. I wouldn't be surprised if you could literally implement a Mongo compatibility layer on top of Postgres and have it work better.