|Azure CosmosDB for PostgreSQL Reaches General Availability|
|Written by Nikos Vaggalis|
|Wednesday, 02 November 2022|
Azure CosmosDB is Microsoft's mutli-model distributed database for supporting workloads at scale. Now it has extended beyond NoSQL by adding support for PostgreSQL. Azure thus becomes the first cloud provider to offer its own single database service that supports both relational and NoSQL workloads. So how do you use it with Postgres?
When Azure Cosmos DB was launched in 2017 we reported that it was based on a service started in 2010 for internal use within Microsoft for large scale applications and that had been made available more widely as DocumentDB, Microsoft's NoSQL database. Initially it supported for MongoDB but APIs for Apache Gremlin and Apache Cassandra were soon added and now the line-up is joined by PostgreSQL and you choose the API of choice upon creating a cluster. So while Cosmos DB for NoSQL does not have relational constraints, when needing to work with relational workloads you can choose the Postgres backend; a fully managed distributed SQL offering built upon the core benefits of Postgres like JSONB datatype extensions, PostGIS, rich indexing and so on.
On top of that, it uses the open source Citus extension to make Postgres ready for the distributed scale, using distributed tables across multiple nodes. You can start small by building your apps on a single node, the same way you would with Postgres and
Azure Cosmos DB for PostgreSQL supports the new PostgreSQL version 15, available in the portal for the managed service—in all Azure regions. This means that you benefit from all this version's new features as described in PostgreSQL 15 Released - What's New:
You can also upgrade your existing cluster to Postgres 15 from any of the other supported major Postgres versions.
The DaaS is more than Postgres with distributed capabilities due to Citus. Other benefits include backup and restore, high availability, monitoring and alerting, Azure security, integration with other Azure services, plus:
Note that even in the distributed workload front, Azure Cosmos DB makes enabling distributed tables easy:
Previously, if you wanted to use the Citus extension to create a distributed table, you’d first have to pick a sharding key. You’d then have to run a command that would block write operations. With Citus 11.1, creating a distributed table and many previously write blocking operations, become fully online. Once you create a distributed table, Citus takes care of the rest.
If you want to give Azure Cosmos DB for PostgreSQL a try, you can start with a free trial and the Quickstart guide "Create an Azure Cosmos DB for PostgreSQL cluster in the Azure portal".
or email your comment to: firstname.lastname@example.org
|Last Updated ( Wednesday, 02 November 2022 )|