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.
[ Parent
| on HN ]
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.