The Latest

22 October 2021: At Google Cloud Next ’21, Google announced the general availability of a PostgreSQL interface to its hyperscale, global spanning Spanner relational database. In short, this means that organisations that have applications that are compatible with PostgreSQL can now migrate to a highly elastic database that is significantly less costly, more robust than running PostgreSQL instances on virtual machines.

Why it’s Important

Google’s highly scalable Cloud relational Spanner database provides high-velocity transactions, strong consistency, and horizontal partitioning across global deployments. Like other specialised, serverless Cloud databases, Spanner previously required legacy (on-premises) applications’ data access layers to be reworked. 

The addition of a PostgreSQL interface greatly reduces development teams’ workload for migrating applications to Spanner. This has several knock-on impacts when migrating applications to the Cloud, including: 

  • reducing training  / new skills development, and allowing existing skills to be fully leveraged
  • reducing the vector for new bugs to be introduced
  • simplifies testing

Overall, this significantly lowers the cost and risk of moving an app to the Cloud. 

As always, the devil is in the detail. Cloud Spanner Product Manager, Justin Makeig posted that the platform does not yet have universal compatibility for all PostgreSQL features, since the company’s goal was to focus on portability and familiarity. However, IBRS has determined that even with the current level of functionality, the PostgreSQL interface for Spanner presents good value for teams looking to migrate legacy applications to the Cloud.

Google is not the only hyperscale Cloud vendor that has enabled this type of operability. However, Cloud Spanner is more economical than competitive hyperscale Cloud database products at this time.

Who’s impacted

  • Development team leads
  • Cloud architecture teams

What’s Next?

Google announced that it is planning to expand its Spanner integration to additional database standards. Data portability and migration of legacy applications to hyperscale Cloud is now a focus for many ICT groups. The availability of open standard SQL interfaces to database PaaS (platform-as-a-Service)  is expected to be a trend for application and data migration, especially where the applications are complex.

Related IBRS Advisory

  1. VENDORiQ: Google introduces Database Migration Service
  2. Enterprise resource planning (ERP) Part 5: Will automation of S/4HANA data migration make modernisation