Goodbye MongoDB, Hello PostgreSQL (2015)

Re:Goodbye MongoDB, Hello PostgreSQL (2015) by timewarrior on Thursday March 11, 2021 @11:36AM (#26425898)

Thanks for raising this good point. I didn't get a chance to elaborate on this in my original post because it was getting too long and it was end of a long day.

The cost of adding a column is zero, in terms of schema migration. So that helps with developer velocity. We used an ORM (mongoose), so that we can have added constraints including default values. But Mongo did help us avoid the friction of adding columns.

[ Parent | on HN ]

Re:Goodbye MongoDB, Hello PostgreSQL (2015) by Jean-Philipe on Friday March 12, 2021 @11:02AM (#26437165)

We also used mongoose, which is awesome. In retrospect, I actually wish we had kept mongodb as a read-only database and used postgres as the source of truth. Our data was mostly read-only, with some rather complex relations behind the scenes.

For quick prototypes, I still prefer mongodb.

[ Parent | on HN ]