Earlier this year at Microsoft Build, we announced the public preview of Azure Database for PostgreSQL. Since then, we have been engaging deeply with the PostgreSQL community and are proud to be involved with PostgresOpen 2017 as a sponsor.
During my keynote at PostgresOpen 2017, I’ll share more about how at Microsoft we are committed to meeting customers where they are, enabling them to achieve more with the technologies and tools of their choice. Azure Database for PostgreSQL, built using the community edition of PostgreSQL database, offers built-in high availability, security and scaling on-the-fly with minimal downtime. Developers can seamlessly migrate their existing apps without any changes, and continue using existing tools. The simple pricing model enables developers to focus on developing apps.
Since introducing the preview a few months ago, we have been working closely with customers to understand their requirements and we continue to add features and updates as we move towards general availability. In addition to ensuring customer requirements are reflected in the product development, we continue to work closely with the PostgreSQL community, engage on pgsql-hackers mailing list, and work with the community on patches. PostgreSQL is a great product, with industry leading innovations in extensibility, and we hope to work with the community to make PostgreSQL even better for our customers.
“Spinning up the PostgreSQL database through the Azure portal was very easy. Then we just exported the database from the existing system and imported it into Azure Database for PostgreSQL. It only took two or three hours, and we really didn't run into any problems.”
- Eric Spear, Chief Executive Officer, Higher Ed Profiles
In addition to Azure Database for PostgreSQL, we also introduced Azure Database for MySQL. Developers using PostgreSQL and MySQL to build and deploy applications for web, mobile, content management system (CMS), customer relationship management (CRM), business, or analytical applications can now choose their favorite database engines delivered as a managed service on Azure. They seamlessly integrate with the most common open source programming languages such as PHP, Python, Node.js, and application development frameworks such as Wordpress, Magento, Drupal, Django, and Ruby on Rails. Whether you want to build a website using MySQL database, or want to quickly build and deploy a geospatial web or mobile app with PostgreSQL, you can now quickly get setup using the managed service capabilities offered by Azure. In addition, app developers can continue to use the familiar community tools to manage their MySQL or PostgreSQL databases. The Azure Database for MySQL and PostgreSQL improves application developer productivity by bringing the following common differentiated benefits of the relational database platform services to all applications:
- The ability to provision a database server in minutes with built-in high availability that does not require any configuration, VMs, or setup.
- Predictable performance with provisioned resources and governance.
- The option to scale Compute Units up/down in response to actual or anticipated workload changes without application downtime.
- Built-in security to protect sensitive data by encrypting user data and backups, as well as data in-motion using SSL encryption.
- Automatic backups with storage for recovery to any point up to 35 days.
- Consistent management experience with Azure Portal, Command Line Interface (CLI), or REST APIs.
Explore more with 5-minute quickstarts and step-by-step tutorials for Azure Database for PostgreSQL and Azure Database for MySQL. If you are ready to go, you can start using the $200 free credit when you create a free account with Azure.
We would love to receive your feedback. Feel free to leave comments below. You can also engage with us directly through User Voice (PostgreSQL and MySQL) if you have suggestions on how we can further improve the service.