News for hackers. Stuff that matters.
Re:The Great Migration from MongoDB to PostgreSQL by 999900000999 on Friday March 29, 2024 @11:32AM (#39865302)
>As part of that stack, we chose MongoDB + Mongoose ORM because the combination presented least overhead and allowed us to ship quality features quickly. As Sir Tony Hoare states, “premature optimization is the root of all evil,” and there was certainly no need for further optimization at the time.

Looks like the tool did a great job while they were getting started. Mongo is very easy to hack something together with, later on it looks like they just needed to migrate to something more stable

Re:The Great Migration from MongoDB to PostgreSQL by swasheck on Friday March 29, 2024 @11:38AM (#39865370)
yeah ... in the early days of mongo it was pitched as a replacement for relational because a) it had faster writes without those pesky joins and constraints, and b) because it's too hard to model data, so chances are it's just unstructured. the onslaught of "relational is dead" and "joins are annoying" was tremendous
Re:The Great Migration from MongoDB to PostgreSQL by 999900000999 on Friday March 29, 2024 @02:59PM (#39867701)
Plus there's a good chance they didn't know exactly what they needed to build when starting out.
Re:The Great Migration from MongoDB to PostgreSQL by forgotmyinfo on Friday March 29, 2024 @11:45AM (#39865456)
Nonsense. Choosing the correct database isn't "premature optimization", it's the bare minimum of being a competent programmer. Why do we never have time to do it right, but we always have time to do it over?
Re:The Great Migration from MongoDB to PostgreSQL by 999900000999 on Friday March 29, 2024 @12:09PM (#39865720)
It's generally faster to get started with Mongo.

If you're talking about a startup, you might not even get to the let's do it over stage. You might have six months to just hack something out so you can raise more funding, and in that case Mongo is a great choice.

The needs of your business might also just evolve over time.

Re:The Great Migration from MongoDB to PostgreSQL by jimbokun on Friday March 29, 2024 @01:52PM (#39866968)
Postgres and MySQL are easy to hack something together with, too.
Re:The Great Migration from MongoDB to PostgreSQL by 999900000999 on Friday March 29, 2024 @02:17PM (#39867262)
That's assuming you're experienced with them, if you know next to nothing about databases, Mongo is a much better choice. In this case it looks like when they got started the team just didn't have all that much experience with databases.