I've been relying on MongoDB for my web applications and it's generally worked well for me. However, I'm currently developing a billing application that has more demanding database needs. I'm considering whether PostgreSQL would be a better choice given its strengths in handling complex transactions, ensuring strong data consistency, and enabling reliable reporting—areas where I feel MongoDB may fall short. I'd love to hear from anyone who has experience with similar applications: is PostgreSQL the right way to go? What advantages have you found in using it over MongoDB?
7 Answers
I've mostly used relational databases like MariaDB and MySQL in my work, but every time I’ve dabbled with MongoDB, I’ve questioned the advantages. For financial applications, you really want the consistency of a relational database—Postgres is a solid choice.
For sure! SQL databases are designed for complex transactions and strong data consistency. Postgres shines in those areas, especially when you need accurate reporting and reliability.
Always go with a relational database unless there's a compelling reason to choose NoSQL. Given your needs, Postgres will serve you well!
I made the jump to Postgres six months ago from MongoDB and haven’t regretted it. It’s been much easier to manage complex data needs with a relational database.
Honestly, I think NoSQL like MongoDB is often overhyped. It's great for quick prototyping, but for applications requiring consistency and structure, relational databases are the way to go. Just make the switch to Postgres already!
Haha, will do! Thanks for the advice!
It really feels like the right time to move on from Mongo. PostgreSQL is more stable for the type of application you’re working on!
Absolutely! In most cases, PostgreSQL will be your go-to for any project that requires robust database features. While MongoDB has its merits, especially for specific use cases, relational databases like PostgreSQL offer much more for complex tasks, which seems like what you need with your billing app.
Totally agree! Mongo can be a bit too loose with data structure.
Thanks! I'm seriously considering making the switch.
Sounds good, I'm on it!