Discussions

Hi everyone,
I'm building a scalable web application and need help deciding between PostgreSQL and MongoDB for the database. The app will handle user-generated content, real-time analytics, and potentially high write throughput. Here are my specific requirements:

Need to support complex queries for analytics dashboards.

Expecting rapid growth in data volume (100k+ records daily).

Team is familiar with SQL but open to NoSQL if it’s a better fit.

Prioritizing ease of scaling and maintenance.

Which database would you recommend for this use case, and why? Are there any specific trade-offs or tools (e.g., ORMs, sharding solutions) you’ve used with either that made a big difference? Thanks for any insights!

ragdoll hit