News for hackers. Stuff that matters.

A comment on Homebrew removes MongoDB from core formulas. Parent comment

Re:Homebrew removes MongoDB from core formulas by scarface74 on Monday September 02, 2019 @10:18PM (#20863227)
Why use Postgres just to store JSON? The entire tooling around Mongo is better for JSON Data.

Not to mention the LINQ driver....

And you can’t do updates on individual JSON fields in Postgres.

[ Parent | on HN ]
Re:Homebrew removes MongoDB from core formulas by mateuszf on Tuesday September 03, 2019 @01:44AM (#20863974)
Yes you can - this is an article crated in 2017 https://www.idalko.com/crud-operations-postgres-jsonb/
[ Parent | on HN ]
Re:Homebrew removes MongoDB from core formulas by scarface74 on Tuesday September 03, 2019 @05:08AM (#20864824)
From the article,

The problematic part with PostgresSQL JSONB is modifying a JSONB column content. In any case, we totally replace the old content by a new one. So, the update operations turn to the complex queries that can lose the content. You can avoid this by performing the full JSON reorganization before the persistent operation.

You still don’t have the richness of MongoQuery and the aggregation framework and the tooling around working with JSON data isn’t there. Let alone the native driver support.

[ Parent | on HN ]
Re:Homebrew removes MongoDB from core formulas by goatinaboat on Tuesday September 03, 2019 @03:31AM (#20864348)
Postgres is better than Mongo for all of Mongo’s use cases, and 100 others besides, why wouldn’t you use it?
[ Parent | on HN ]
Re:Homebrew removes MongoDB from core formulas by scarface74 on Tuesday September 03, 2019 @05:12AM (#20864841)
Including the Mongo aggregation framework, tooling, driver support, in the case I mentioned LINQ support, various reporting packages, etc?
[ Parent | on HN ]