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

Other stories you might like

  • Prisons transcribe private phone calls with inmates using speech-to-text AI

    Plus: A drug designed by machine learning algorithms to treat liver disease reaches human clinical trials and more

    In brief Prisons around the US are installing AI speech-to-text models to automatically transcribe conversations with inmates during their phone calls.

    A series of contracts and emails from eight different states revealed how Verus, an AI application developed by LEO Technologies and based on a speech-to-text system offered by Amazon, was used to eavesdrop on prisoners’ phone calls.

    In a sales pitch, LEO’s CEO James Sexton told officials working for a jail in Cook County, Illinois, that one of its customers in Calhoun County, Alabama, uses the software to protect prisons from getting sued, according to an investigation by the Thomson Reuters Foundation.

    Continue reading
  • Battlefield 2042: Please don't be the death knell of the franchise, please don't be the death knell of the franchise

    Another terrible launch, but DICE is already working on improvements

    The RPG Greetings, traveller, and welcome back to The Register Plays Games, our monthly gaming column. Since the last edition on New World, we hit level cap and the "endgame". Around this time, item duping exploits became rife and every attempt Amazon Games made to fix it just broke something else. The post-level 60 "watermark" system for gear drops is also infuriating and tedious, but not something we were able to address in the column. So bear these things in mind if you were ever tempted. On that note, it's time to look at another newly released shit show – Battlefield 2042.

    I wanted to love Battlefield 2042, I really did. After the bum note of the first-person shooter (FPS) franchise's return to Second World War theatres with Battlefield V (2018), I stupidly assumed the next entry from EA-owned Swedish developer DICE would be a return to form. I was wrong.

    The multiplayer military FPS market is dominated by two forces: Activision's Call of Duty (COD) series and EA's Battlefield. Fans of each franchise are loyal to the point of zealotry with little crossover between player bases. Here's where I stand: COD jumped the shark with Modern Warfare 2 in 2009. It's flip-flopped from WW2 to present-day combat and back again, tried sci-fi, and even the Battle Royale trend with the free-to-play Call of Duty: Warzone (2020), which has been thoroughly ruined by hackers and developer inaction.

    Continue reading
  • American diplomats' iPhones reportedly compromised by NSO Group intrusion software

    Reuters claims nine State Department employees outside the US had their devices hacked

    The Apple iPhones of at least nine US State Department officials were compromised by an unidentified entity using NSO Group's Pegasus spyware, according to a report published Friday by Reuters.

    NSO Group in an email to The Register said it has blocked an unnamed customers' access to its system upon receiving an inquiry about the incident but has yet to confirm whether its software was involved.

    "Once the inquiry was received, and before any investigation under our compliance policy, we have decided to immediately terminate relevant customers’ access to the system, due to the severity of the allegations," an NSO spokesperson told The Register in an email. "To this point, we haven’t received any information nor the phone numbers, nor any indication that NSO’s tools were used in this case."

    Continue reading

Biting the hand that feeds IT © 1998–2021