When to use Azure Database for PostgreSQL
It's vital to consider different business needs before making a decision on a database implementation. Azure Database for PostgreSQL has the functionality, ease-of-use, and scalability for most business cases. With built-in database administrative functionality that is like DBA, the service is suitable for cloud architects and developers because it lowers the need for managing the underlying operating system and database.
Flexible server options for small to medium-sized applications are available, starting at a few dollars per month.
Small-to-medium applications and proof of concepts
Flexible server deployments of Azure Database for PostgreSQL are well suited for smaller applications and proof of concepts, due to their low cost and ease of deployment. The built-in features such as security and analytics allow developers to focus on application development instead of configuration and maintenance.
Geospatial and logistics applications
PostgreSQL has built-in support for geospatial data, which is ideal for logistics applications. Flexible server is ideal for most workloads.
Protecting sensitive data
By default, Azure Database for PostgreSQL has two layers of encryption, a customizable firewall, and all the security of the Azure cloud. Azure provides extra security that would normally require security experts or managing advanced security monitoring systems.
Azure Database for PostgreSQL provides business continuity features that include geo-redundant backups with the ability to initiate geo-restore, and deploying read replicas in a different region.
Mobile in-app databases
Azure Database for PostgreSQL is a cloud-based solution, and isn't suitable for hosting inside a mobile or desktop app. If you require mobile in-app functionality, you may want to consider an alternative solution, such as using the file system or SQLite.