Discussions

Hey everyone,

Hoping to get some advice from the community on a major architectural decision. My team is starting a new e-commerce platform from scratch, and we're debating the best database to use.

Our main requirements are scalability to handle a high volume of concurrent users and flexibility as our product data schema will likely evolve quickly. However, we also have critical transaction data (orders, payments) that requires strong consistency and integrity.

We're torn between a NoSQL solution like MongoDB for its horizontal scalability and schema flexibility, and a traditional relational database like PostgreSQL for its reliability, powerful query language, and mature ecosystem.

What are your thoughts on which database would be a better fit for this use case? Are there specific trade-offs we should be considering that might not be obvious? We're open to hybrid approaches as well. Any real-world experience or examples would be incredibly helpful!

Thanks for your input.

golf hit game