Spanner in the works: The goal is not 100% compatibility, Google says of PostgreSQL interface

Meanwhile, Yugabyte says PostgreSQL compatibility for its distributed database dates back to 2019

Google has clarified details of the interface between its popular distributed SQL database-management-cum-storage-service Spanner and the open-source RDBMS PostgreSQL.

According to a blog published this week, Spanner's PostgreSQL interface uses "the familiarity and portability of PostgreSQL" to make developers' lives easier.

"Teams can be assured that the schemas and queries they build against the Spanner PostgreSQL interface can be easily ported to another PostgreSQL environment, giving them flexibility and peace of mind," said Justin Makeig, product manager for Cloud Spanner.

The post explains that Spanner's PostgreSQL interface is designed to compile PostgreSQL queries to Spanner's existing distributed query processing and storage primitives. "It also supports the PostgreSQL wire protocol, the communication channel used to connect clients. To a developer building an application, this is virtually transparent. Provisioning and monitoring databases use Spanner and Google Cloud's existing tools, while interacting with data feels like PostgreSQL. The implementation touches every layer of the database to ensure a unified experience," Makeig said.

But for those who want a distributed database with a bit more than "familiarity and portability" with PostgreSQL, there are options.

Founded by former Facebook engineers, Yugabyte takes inspiration from Spanner in terms of the distributed database, but claims full compatibility with PostgreSQL since 2019. Unsurprisingly, it had something to say about Google's news.

Karthik Ranganathan, co-founder and CTO of Yugabyte, told The Register: "This effort by Google Spanner highlights the importance of the PostgreSQL API and feature set when it comes to building cloud-native applications. To be practically useful, databases need to go beyond wire compatibility and support commonly used PostgreSQL features such as stored procedures, triggers, and user-defined functions. YugabyteDB achieves this by reusing the query layer code of PostgreSQL rather than rewriting it from scratch."

Nonetheless, Sid Nag, Gartner veep of cloud and edge technologies, said Google's PostgreSQL interface would "benefit increased adoption of Spanner since developers and database administrators who are already familiar with and skilled in PostgresSQL will be able to use Spanner without having to learn the native Spanner interfaces, query mechanisms and APIs etc, thereby opening up the use of Spanner to a whole new world of application development."

This week Google's data technology team also said it was playing nice with other popular tools in the field.

The Chocolate Factory announced integration between Tableau – the data visualisation and analytics tool bought by Salesforce for $15.7bn in 2019 – and its own tool in the same market, Looker.

The integration means Tableau customers would be able to use Looker's semantic model to access data across the organisation, "enabling new levels of data governance while democratising access to data."

The development is also designed to pair Looker's enterprise semantic layer with Tableau's analytics platform.

Looker can be used both as an analytics and visualisation tool and as an enterprise data platform. Google's integration with Tableau is a sign it is decoupling the two technologies, said Nag.

"The idea is to open up Looker to new analytics-based technologies and interfaces such as Tableau. With this development most organisations will pick one or the other, however, some may need both Looker and Tableau – based on their varying application and workload needs and based on the developer preferences and biases. Google will help both constituents by virtue of this new capability." ®

Similar topics

Broader topics

Other stories you might like

  • Talos names eight deadly sins in widely used industrial software
    Entire swaths of gear relies on vulnerability-laden Open Automation Software (OAS)

    A researcher at Cisco's Talos threat intelligence team found eight vulnerabilities in the Open Automation Software (OAS) platform that, if exploited, could enable a bad actor to access a device and run code on a targeted system.

    The OAS platform is widely used by a range of industrial enterprises, essentially facilitating the transfer of data within an IT environment between hardware and software and playing a central role in organizations' industrial Internet of Things (IIoT) efforts. It touches a range of devices, including PLCs and OPCs and IoT devices, as well as custom applications and APIs, databases and edge systems.

    Companies like Volvo, General Dynamics, JBT Aerotech and wind-turbine maker AES are among the users of the OAS platform.

    Continue reading
  • Despite global uncertainty, $500m hit doesn't rattle Nvidia execs
    CEO acknowledges impact of war, pandemic but says fundamentals ‘are really good’

    Nvidia is expecting a $500 million hit to its global datacenter and consumer business in the second quarter due to COVID lockdowns in China and Russia's invasion of Ukraine. Despite those and other macroeconomic concerns, executives are still optimistic about future prospects.

    "The full impact and duration of the war in Ukraine and COVID lockdowns in China is difficult to predict. However, the impact of our technology and our market opportunities remain unchanged," said Jensen Huang, Nvidia's CEO and co-founder, during the company's first-quarter earnings call.

    Those two statements might sound a little contradictory, including to some investors, particularly following the stock selloff yesterday after concerns over Russia and China prompted Nvidia to issue lower-than-expected guidance for second-quarter revenue.

    Continue reading
  • Another AI supercomputer from HPE: Champollion lands in France
    That's the second in a week following similar system in Munich also aimed at researchers

    HPE is lifting the lid on a new AI supercomputer – the second this week – aimed at building and training larger machine learning models to underpin research.

    Based at HPE's Center of Excellence in Grenoble, France, the new supercomputer is to be named Champollion after the French scholar who made advances in deciphering Egyptian hieroglyphs in the 19th century. It was built in partnership with Nvidia using AMD-based Apollo computer nodes fitted with Nvidia's A100 GPUs.

    Champollion brings together HPC and purpose-built AI technologies to train machine learning models at scale and unlock results faster, HPE said. HPE already provides HPC and AI resources from its Grenoble facilities for customers, and the broader research community to access, and said it plans to provide access to Champollion for scientists and engineers globally to accelerate testing of their AI models and research.

    Continue reading

Biting the hand that feeds IT © 1998–2022