Re:The Great Migration from MongoDB to PostgreSQL
by joneholland on Friday March 29, 2024 @12:05PM
(#39865683)
Applications that are essentially form wizards are a great fit for a document database.
Think application forms etc.
Re:The Great Migration from MongoDB to PostgreSQL
by wlll on Friday March 29, 2024 @12:39PM
(#39866066)
Is there a benefit of Mongo for that over just Postgres with JSONB columns? You're still storing JSON in Postgres but you'd get the relational aspects too for things like users having many forms, billing and account relationships etc.
Re:The Great Migration from MongoDB to PostgreSQL
by joneholland on Friday March 29, 2024 @12:56PM
(#39866285)
Easier horizontal scaling and organizational inertia would be the main reasons to use mongo over a jsonb column. I wouldn’t introduce it to a psql shop if they are already great at running psql.
Re:The Great Migration from MongoDB to PostgreSQL
by unclebucknasty on Friday March 29, 2024 @01:07PM
(#39866413)
No benefits that I can think of at the database layer. Postgres's addition of JSONB columns represents the best of both worlds. Funny to think that all of that noise about nosql replacing rdbms was essentially nullified by the addition of one column type.
Some people do like the MongoDB API, however.
Even for prototyping there are many other good choices since RDBMS like Postgres have implemented JSON support. Mongodb looks like a solution in search of a problem.