What is Azure Database for PostgreSQL?
Azure Database for PostgreSQL is a managed database solution that provides highly available, massively scalable PostgreSQL in the cloud. The solution is made up of two tightly integrated layers: PostgreSQL, and specialized Azure services. You’re provided with all the features of the community edition of PostgreSQL, with the security, reliability, and performance you expect from Azure.
The Azure layer
PostgreSQL in Azure has two services, Azure Database for PostgreSQL and Azure Cosmos DB for PostgreSQL.
Azure Database for PostgreSQL is available in two deployment modes, with each deployment mode allowing different levels of customization and scale.
Flexible server is suitable for production workloads that require zone resilient HA, predictable performance, maximum control, custom maintenance window, cost optimization controls and simplified developer experience. Ideal for workloads that don't need full compute capacity continuously.
Single Server deployments are suitable for most applications that don’t require high levels of customization or low latency performance across multiple regions. Single server deployments can be scaled down to only cost a few dollars per month. Workloads could include servers used for development and enterprise applications.
Data protection and security benefits
Data is automatically encrypted and backed up. Options such as Advanced Threat Protection make it simple to address potential threats without the need to be a security expert or manage advanced security monitoring systems.
The example of a contactless payment app having a simple and reliable way to back up your database means you can focus on developing your app. Also, Advanced Threat Protection means it's easier for you to mitigate threats if they arise during a trial, without having to rely on expert security personnel.
Lower administrative complexity and cost
For many businesses, the decision to transition to a cloud service is as much about offloading the complexity of administration as it is about cost. Azure helps to lower administrative costs in three key ways.
- Azure automates maintenance and updates for the underlying hardware, operating system, and the database engine (minor versions).
- Azure provides automated management and analytics for monitoring of large-scale deployments.
- Together these capabilities can allow for significant cost savings, especially when many databases need to be supported.
Using PostgreSQL on Azure for your Woodgrove Bank app would help you to structure your mobile app to accommodate its future growth. Once your app has proven its success, you can focus on building new features, and less on day-to-day operations.