News for hackers. Stuff that matters.
Re:MongoDB is actively investigating a security incident by cpursley on Saturday December 16, 2023 @07:07PM (#38669071)
And what's a good use case over Postgres jsonb?
Re:MongoDB is actively investigating a security incident by pleoxy on Saturday December 16, 2023 @07:29PM (#38669206)
When one doesn't want SQL for one.

Nosql is a fun target to beat up on of late. But there are good, even infamous, reasons to avoid SQL. Particular if you want to accomplish flexible record queries from untrusted clients.

Re:MongoDB is actively investigating a security incident by cpursley on Saturday December 16, 2023 @07:45PM (#38669299)
I’ll ask again, what’s a good use case over Postgres jsonb.
Re:MongoDB is actively investigating a security incident by pleoxy on Saturday December 16, 2023 @08:54PM (#38669680)
All you do is poop all over the story about postgres. I'm convinced that no use cases will convince you of anything. I'm not really looking to involve myself in a database holy war.
Re:MongoDB is actively investigating a security incident by cpursley on Sunday December 17, 2023 @05:02AM (#38671746)
Is jsonb in Postgres not flexible enough? I dump external json in there all the time (like large API responses). The jsonb operators work well. And there's an escape hatch that lets you easily convert json to a table. And importantly, you get indexes with Postgres.
Re:MongoDB is actively investigating a security incident by pleoxy on Sunday December 17, 2023 @09:43AM (#38673168)
I apologize for being short with you in my previous response. I need to be better about assuming good faith.

Your response seems to betray a certain ignorance of mongo. Don't you realize that mongo has indexes?

For handling documents, this blog post covers the topic in some depth.

https://jimb-cc.medium.com/postgres-jsonb-meets-mongodb-part...

Might I suggest you actually use mongo on a project before engaging further on the topic. It clearly has had a lot more thought put into it in the context of json documents.

If postgres works great for your use cases, great, go be happy with the tool.

Re:MongoDB is actively investigating a security incident by cpursley on Sunday December 17, 2023 @11:03AM (#38673723)
Re:MongoDB is actively investigating a security incident by pleoxy on Sunday December 17, 2023 @04:29PM (#38676644)
Definitely a better solution than the brick wall he hit. Complicated beastie. I can see the appeal if you just love, eat, and breath SQL.

But a query language within a query language feels bolted onto something alien to do something pretty basic. Pass. If I'm teaching this to new engineers, pass also.

Re:MongoDB is actively investigating a security incident by Thaxll on Saturday December 16, 2023 @07:25PM (#38669182)
Postgress is single master which is a huge limitation.
Re:MongoDB is actively investigating a security incident by cpursley on Saturday December 16, 2023 @07:54PM (#38669352)
How so?
Re:MongoDB is actively investigating a security incident by Thaxll on Saturday December 16, 2023 @08:10PM (#38669453)
How do you scale a single master out of the box?
Re:MongoDB is actively investigating a security incident by cpursley on Sunday December 17, 2023 @04:57AM (#38671724)
What's nice about Postgres is there's a ton of Postgres compatible products that do scale for the 10% who actually need it. And it's still all just Postgres / SQL.
Re:MongoDB is actively investigating a security incident by Thaxll on Sunday December 17, 2023 @05:49PM (#38677213)
Again it's not out of the box and your so called "tons" vary in quality and features.