DEV Community

Discussion on: PostgreSQL vs MongoDB

Collapse
 
codingmindfully profile image
Daragh Byrne

Honestly I've never had to do too much with MongoDB. So I can't comment too much on perf, programability etc.

I do know that I've made SQL databases do outrageous things under massively parallel write loads. Billion row tables, before cloud was a thing etc. Tweaking Inserts so they'd take place on different pages for example. It was fun. Execution plans are fun. Thinking about the right kind of indexes is fun. ACID is legitimate a lot of the time. Seeing a query speed up by a factor of 100+ is fun.

Extensible schemas on top of systems that do that, e.g. via GraphQL or similar, is also fun. So there's value in both concepts, and implementations.