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 eloff on Monday September 02, 2019 @08:56PM (#20862880)
I worked on a project with similar requirements. I just serialized the data with protobufs, encrypted it, and stashed it in S3. It was sensitive data so this also had the advantage of being easy to secure and audit.

No point using a relational db for that kind of thing.

[ Parent | on HN ]
Re:Homebrew removes MongoDB from core formulas by scarface74 on Monday September 02, 2019 @09:11PM (#20862940)
And then when you need to do reports on the data and query it?
[ Parent | on HN ]
Re:Homebrew removes MongoDB from core formulas by jaequery on Monday September 02, 2019 @09:52PM (#20863105)
Why not just use Postgres, set a field as jsonb, done?
[ Parent | on HN ]
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 ]
Re:Homebrew removes MongoDB from core formulas by eloff on Tuesday September 03, 2019 @12:52PM (#20868503)
Due to the sensitive nature of the data and the need to keep it encrypted, breaking it down by columns into a schema we could query was a non goal.
[ Parent | on HN ]