News for hackers. Stuff that matters.
Re:I would like a job writing Haskell by HideousKojima on Tuesday February 08, 2022 @01:01PM (#30261957)
Postgres literally beats MongoDB at JSON in benchmarks. Y'know, the thing that's supposed to be Mongo's bread and butter?
Re:I would like a job writing Haskell by toqy on Tuesday February 08, 2022 @03:31PM (#30264203)
Mongodb was a lot easier to manipulate json in for a while vs postgres, but once postgres got json path support it evened out a bit imo.

Say you have some json and nested in it somewhere is an array of objects, and you want to just map over that and update those objects. I was writing a migration to do that in Postgres <11 once and it was not fun to try and figure out how to do it.

I haven't worked with Mongo in years though, so no clue how it has evolved since like 2015.

Re:I would like a job writing Haskell by jd_mongodb on Tuesday February 08, 2022 @01:54PM (#30262754)
Which benchmark is that?
Re:I would like a job writing Haskell by HideousKojima on Tuesday February 08, 2022 @05:34PM (#30265819)
Re:I would like a job writing Haskell by ghartnett on Wednesday February 09, 2022 @06:12AM (#30271363)
Unfortunately that benchmark was very inaccurate. They tuned the postgres configuration and didn't tune MongoDB. They also used an unsupported, experimental driver without connection pooling on MongoDB.

For example: they measured Query B execution time on postgres: 41m3s, mongodb: 1h13m3s. When MongoDB measured Query B with a supported driver, the execution time was only 3m30s more than 10x faster than postgres!

You'll find details here: https://www.mongodb.com/blog/post/benchmarking-do-it-right-o...

Re:I would like a job writing Haskell by gqewogpdqa on Wednesday February 09, 2022 @01:39PM (#30276495)
Thanks for that info. Statistics, misunderstandings, lies, benchmarks, database benchmarks...