The Great Migration from MongoDB to PostgreSQL

Re:The Great Migration from MongoDB to PostgreSQL by callalex on Saturday March 30, 2024 @12:34AM (#39871860)

What?? That’s an insane way to describe what I’m talking about. Data/transaction isolation is very complex and extremely specific to every use case, which is why database engines worth anything let you describe to them what your needs are. Hence why when one client writes to Y they specify what they think X should be if relevant and get notified to try again if the assumptions are wrong. An advantage of specifying your data and transaction model up front is that it will surface these subtle issues to you before they destructively lose important information in an unrecoverable manner.

https://en.wikipedia.org/wiki/Isolation_(database_systems)

[ Parent | on HN ]

Re:The Great Migration from MongoDB to PostgreSQL by winrid on Saturday March 30, 2024 @04:11AM (#39872861)

Also this statement:

> which is why database engines worth anything let you describe to them what your needs are

Contradicts your argument.

Mongo has atomic updates to update specific fields, or you can do replaceOne() etc to replace the whole document.

While PG only gives you "replace" with JSON.

So I guess postgres isn't worth anything. :)

[ Parent | on HN ]

Re:The Great Migration from MongoDB to PostgreSQL by winrid on Saturday March 30, 2024 @04:08AM (#39872847)

So updating one column on a table is destructive and can lose important information now? :D

How do you increment a value in a column while other people write to the database? You don't grab the whole damn row and rewrite it...

[ Parent | on HN ]