New API for Azure Cosmos DB

Its PostgreSQL! So lets see what features this API has.

· Fully managed service

· Automatic high availability

· Backups

· Built-in pgBouncer

· Read-replicas

· Easy monitoring

· Private endpoints

· Encryption

· Powered by the Citus open-source extension to PostgreSQL, which always supports the latest PostgreSQL major version.

· Azure Cosmos DB for PostgreSQL includes features beyond standard PostgreSQL.

1. Parallelizing query execution across shards
2. Managing sharded data between multiple servers
3. Compressing data with columnar storage
4. Automating timeseries partitioning

• Cluster currently supports vCore based billing model.
• The cluster name determines the DNS name your applications.
• Your cluster’s default dbname and username are citus and can’t be changed 😐
• There are use-case where Azure Cosmos DB for PostgreSQL shines: multi-tenant SaaS, real-time operational analytics, and high throughput OLTP.

· You can query it by Python, Java, Ruby, Node.js and C#.

I was wondering whether we can use different APIs for the same Cosmos DB, and the answer is “NO”!

References

Azure Cosmos DB for PostgreSQL documentation

Frequently asked questions on different APIs in Azure Cosmos DB