Should I Switch from MongoDB to PostgreSQL for My Billing App?
Asked by
CleverPineapple77
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?
Answers
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.
Reply to this answer
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!
Reply to this answer
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!
OverlyOptimistic35: Haha, will do! Thanks for the advice!
Reply to this answer
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.
Reply to this answer
Always go with a relational database unless there's a compelling reason to choose NoSQL. Given your needs, Postgres will serve you well!
Reply to this answer
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.
GratefulUser23: Sounds good, I'm on it!
Reply to this answer
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.
Reply to this answer
Add your answer
Answers are reviewed before publication.
CuriousDev01: Thanks! I'm seriously considering making the switch.
SQLWizKid: Totally agree! Mongo can be a bit too loose with data structure.