Google Extends Cloud Spanner Database With PostgreSQL

With the general release of Big Query Omni and a new PostgreSQL interface for Google Cloud Spanner, Google is expanding the databases and data service capabilities on its cloud platform with a series of presentations at the tech giant’s Google Next ’21 virtual event on Tuesday.

Google came out for the first time BigQuery Omni previewed a year ago. BigQuery Omni service provides multi-cloud capability for BigQuery data analysis platform.

Also during the virtual conference, Google unveiled a preview of a Spark service on Google Cloud that will provide users with serverless capability to quickly query data.

Open source PostgreSQL interface for the Cloud key the database platform is in preview.

Google continues to push the data agenda, and it’s multi-cloud. With this, it recognizes that enterprise data is fragmented between public clouds.

Holger MuellerAnalyst, Constellation Research

“Google continues to push the data agenda, and it’s multi-cloud,” said Holger Mueller, analyst at Constellation Research. “With this, he recognizes that enterprise data is fragmented between public clouds. “

Bring PostgreSQL to Google Cloud Spanner

Mueller noted that in addition to recognizing that data is a multi-cloud reality, Google wants to meet developers where they are, which is why it added a PostgreSQL interface to Cloud Spanner.

In a small group session at Google Next, Andi Gutmans explained that Cloud Spanner is a fully managed relational database that offers the familiarity and developer experience of a relational database, as well as the scalability of a NoSQL database. Gutmans is general manager and vice president of databases at Google Cloud.

“As wonderful and unique as Spanner was, it was not the most accessible database for developers,” said Gutmans.

He noted that with the new PostgreSQL interface for Cloud Spanner, developers can use their existing PostgreSQL skills and tools with Cloud Spanner.

“Starting today, you can build Cloud Spanner databases that use the PostgreSQL dialect and connect with its open wire protocol,” Gutmans said.

Andi Gutmans, General Manager and Vice President of Google Cloud Databases
Andi Gutmans, General Manager and Vice President of Databases at Google Cloud

Several options now for PostgreSQL databases

Cloud Spanner is not the first Google Cloud database to support PostgreSQL. Cloud SQL for PostgreSQL was launched in 2018 as a managed service.

Gutmans explained that Google now offers two fully managed services for maximum compatibility with PostgreSQL.

“For the simplest lift-and-shift migrations, you have Cloud SQL for PostgreSQL,” said Gutmans. “For your most demanding workloads, where you need unlimited scalability and five new uptime, we offer Cloud Spanner with its new PostgreSQL interface that allows you to leverage your skills and investment in the PostgreSQL system. “

Maria H. Underwood