Cosmos DB Adds PostgreSQL Support
At the recent Microsoft Ignite 2022 conference, Microsoft made a significant announcement that will change how you approach database design and implementation as a software engineer. Microsoft has become the first provider to offer both NoSQL and RDBMS capabilities in a single cloud service.
At the recent Microsoft Ignite 2022 conference, Microsoft made a significant announcement that will change how you approach database design and implementation as a software engineer. Microsoft has become the first provider to offer both NoSQL and RDBMS capabilities in a single cloud service.
As a software engineer, you put a lot of thought into your back-end database solutions. Some designs need the performance and flexibility of a NoSQL based service. Some designs need the query and analytics capabilities of a RDBMS based service. And some designs need both- the transactional speed of NoSQL feeding the business intelligence of an RDBMS. Each one of these has traditionally been provided as different service offerings. You may have used DynamoDB and Redshift service offerings in AWS for example. In Azure, you may have used Cosmos DB and Azure SQL service offerings.
At Microsoft Ignite 2022, Microsoft announced that Cosmos DB now also supports native PostgreSQL, an open-source and very popular relational database management system. This addition to the core Cosmos DB service adds the following significant capabilities:
- ACID compliance
- SQL query capabilities
- Large collection of open source PostgreSQL extensions
- A RDBMS built on the scalability of Cosmos DB
This announcement is significant from the software engineer and DevSecOps perspective. You can now invest your time learning the core Cosmos DB service offering and then applying those learnings to both NoSQL and RDBMS solution implementations using the same highly scalable Cosmos DB service.
Azure makes it simple to start small with Cosmos DB and then scale up as needed. And now with PostgreSQL support added, you can build RDBMS solutions that scale using multi-node clusters and even distributed tables.
As a software engineer, I highly recommend you read up on this great addition to Cosmos DB. This could be a real time-saver when building those core service skills, and it might even prove to be a career booster for you.