Discuss: Google Cloud Spanner adds a PostgreSQL interface

datanami.com

44 pointsrkarthik0076 comments

Announcement on Google Cloud blog:

https://cloud.google.com/blog/topics/developers-practitioner...

How carefully worded! It implements a "core subset" of data types and "key parts" of the SQL dialect. It does not sound like they've made it trivial to just silently swap your RDBMS with Spanner. Still, it's come a long way from the days when Spanner did not even have SQL DML.

I just linked the SQL dialect docs elsewhere in this thread: https://news.ycombinator.com/item?id=28845881

EDIT: of note, Spanner has its own first-party JDBC driver now too (fairly recent, IIUC): https://cloud.google.com/spanner/docs/open-source-jdbc

Thank you, this should be the main link.

It looks like Spanner already supported their own SQL interface. So are there significant differences between their Google SQL syntax and the PostgreSQL syntax?

Looks like the docs are live alongside the announcement –

"The PostgreSQL language in Cloud Spanner": https://cloud.google.com/spanner/docs/postgresql/overview

"PostgreSQL interface" under the Concepts section: https://cloud.google.com/spanner/docs/postgresql-interface

Reply on news.ycombinator.com