

If a SQL database fits your needs, then Postgres is a great choice. If you are looking for a distributed database for modern transactional and analytical applications that are working with rapidly changing, multi-structured data, then MongoDB is the way to go. If your concerns are compatibility, serving up thousands of queries from hundreds of tables, taking advantage of existing SQL skills, and pushing SQL to the limit, PostgreSQL will do an awesome job.īoth Databases Are Awesome, But What Is Your Need?Īs an astute reader should already be able to tell, the real question is not MongoDB vs Postgres, but the best document database versus the best relational database. Everything you would ever want from a relational database is present in PostgreSQL, which relies on a scale-up architecture. PostgreSQL is a rock solid, open source, enterprise-grade SQL database that has been expanding its capabilities for 30 years. If your concerns are time to market, developer productivity, supporting DevOps and agile methodologies, and building stuff that scales without operational gymnastics, MongoDB is the way to go. MongoDB handles transactional, operational, and analytical workloads at scale. It is built on a distributed, scale-out architecture and has become a comprehensive cloud-based platform for managing and delivering data to applications. MongoDB is the leading document database. MongoDB vs PostgreSQL: A Comparison in Briefįor those of you who want the news right up front, here it is in 135 words.
