News for hackers. Stuff that matters.

A comment on Goodbye MongoDB, Hello PostgreSQL (2015). Parent comment

Re:Goodbye MongoDB, Hello PostgreSQL (2015) by Doxin on Thursday March 11, 2021 @02:25AM (#26421275)
These days MongoDB is mostly a subset of what SQL servers do. If all you need is a document store you can simply make a table with a JSONB column and get that. If you later discover you do need relations you can do that with e.g. Postgres but not with MongoDB.

Historically MongoDB has been known for dropping or mangling data in some unfortunate ways, I'm not entirely sure what the story there is these days but personally I wouldn't trust it ever again. Data integrity is too important.

[ Parent | on HN ]
Re:Goodbye MongoDB, Hello PostgreSQL (2015) by YouthfulMarxism on Thursday March 11, 2021 @02:49AM (#26421426)
A single point for Mongo over Postgre JsonB is WiredTiger is very good at compression. In times of Mongo:4.0 vs Postgre:10.5 it was like 20Gb vs 50Gb. Though could depend on documents structure. Not sure about current state. Querries were also somewhat faster in Mongo.
[ Parent | on HN ]
Re:Goodbye MongoDB, Hello PostgreSQL (2015) by Doxin on Thursday March 11, 2021 @03:55AM (#26421820)
> A single point for Mongo over Postgre JsonB is WiredTiger is very good at compression

Granted, the compression story in postgres isn't currently amazing.

> Querries were also somewhat faster in Mongo.

If you really want fast queries it's not super hard to tune postgres to be fast and drop data if it crashes. It's a bit trickier to tune it to be quite that fast if you want to keep all your data, but for a single table of json documents it should be doable if you're okay with not having transactions.

[ Parent | on HN ]