Microsoft Azure Cosmos DB is Microsoft's Big Data analysis platform. It is a NoSQL database service and is a replacement for the earlier DocumentDB NoSQL database.
N/A
PostgreSQL
Score 8.3 out of 10
N/A
PostgreSQL (alternately Postgres) is a free and open source object-relational database system boasting over 30 years of active development, reliability, feature robustness, and performance. It supports SQL and is designed to support various workloads flexibly.
N/A
Pricing
Azure Cosmos DB
PostgreSQL
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Azure Cosmos DB
PostgreSQL
Free Trial
No
No
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
—
More Pricing Information
Community Pulse
Azure Cosmos DB
PostgreSQL
Features
Azure Cosmos DB
PostgreSQL
NoSQL Databases
Comparison of NoSQL Databases features of Product A and Product B
NoSQL platforms are very useful when it comes to security, speed, accuracy, high accessibility with high read and write power. Everything is managed under the cloud and we have the various capabilities of Azure and support for Microsoft products with us. Flexibility in price and variety of features, as well as real-time results, are some of the popular [features] of this platform.
PostgreSQL is ideal for handling databases that contain large volumes of information due to its efficiency, speed and above all because of the good management it makes of our resources, it also behaves very well in distributed environments of high demand, if you want a database of stable data and excellent performance PostgreSQL is one of the best.
Turn-key geo-redundancy with multi-master writes is unprecedented and unparalleled in the industry!
Guaranteed low latency makes Cosmos DB an excellent fit for most of our performance-intensive situations.
The tunable consistency model simplifies so many challenges in distributed systems engineering that otherwise require advanced knowledge of computer science topics. I continue to be impressed at how Cosmos DB has abstracted away so much complexity.
The performance of PostgreSQL has been enhanced through the years, but always is better to have as much performance as we can.
The replication services could be done directly within the database, and more easily.
The Object Orientation of the Database could be extended, and albeit it manages inheritance of tables, and accepts XML and JSON as primary types, it would be wonderful if one could attach methods more easily to tables (to make them more like classes), and instances (rows for example).
It's efficient, easy to scale, and works. We do have to do a bit of administration, but less now than when we started with this a couple of years ago. Microsoft continues to improve its self-management capability.
Like I said, Cosmos is the way to go. From all of the services that Azure has, Cosmos is very robust in terms of usability. It's ever-evolving and integrates with other applications seamlessly. The interface is pretty easy to understand. I implemented various solutions for my company and Cosmos was one of them.
Postgresql is the best tool out there for relational data so I have to give it a high rating when it comes to analytics, data availability and consistency, so on and so forth. SQL is also a relatively consistent language so when it comes to building new tables and loading data in from the OLTP database, there are enough tools where we can perform ETL on a scalable basis.
The data queries are relatively quick for a small to medium sized table. With complex joins, and a wide and deep table however, the performance of the query has room for improvement.
The support team is very responsive and we are generally satisfied with Microsoft support, in my opinion support team of a product and service is just as valuable as its quality and performance. Telephone answering, 24-hour hotline, email support and ticketing are excellent.
AWS, Heroku, and Digital Ocean all provide Postgres-as-a-service, where you pretty much never need to administrate it yourself but they do it for you. The Postgres community also has developed awesome and reasonably priced extensions, such as Citus DB and CockroachDB in case you need additional support for running it. If you need documentation, Postgres's docs are super thorough and their official forms are active.
The online training is request based. Had there been recorded videos available online for potential users to benefit from, I could have rated it higher. The online documentation however is very helpful. The online documentation PDF is downloadable and allows users to pace their own learning. With examples and code snippets, the documentation is great starting point.
In this case, Postgres is preferred because it handles large data sets and requires fewer hardware resources than its competitor, MySQL. Compared to PostgreSQL, Microsoft products are excellent, but the installation process for MS SQL is lengthy. PostgreSQL has an advantage over its competitors in that it can adapt or configure third-party programs, applications, or settings.
Easy to administer so our DevOps team has only ever used minimal time to setup, tune, and maintain.
Easy to interface with so our Engineering team has only ever used minimal time to query or modify the database. Getting the data is straightforward, what we do with it is the bigger concern.
