News for hackers. Stuff that matters.

A comment on The Great Migration from MongoDB to PostgreSQL.

Re:The Great Migration from MongoDB to PostgreSQL by arusahni on Friday March 29, 2024 @08:10AM (#39863063)
This seems to gloss over the actual rewrite. How did you ensure queries were equivalent? How did you configure the product to be able to read from and write to both databases? Did migrating reveal any bugs? Were you largely able to port your queries 1:1?
[ Parent | on HN ]
Re:The Great Migration from MongoDB to PostgreSQL by Cyberdog on Friday March 29, 2024 @11:25AM (#39865202)
Hopefully they had comprehensive test coverage. That would have helped greatly in that regard.
[ Parent | on HN ]
Re:The Great Migration from MongoDB to PostgreSQL by Semionilo on Friday March 29, 2024 @01:25PM (#39866659)
You can write logging for both drivers dumping results.

Then checking which query doesn't return the same result set.

[ Parent | on HN ]