Hacker News new | ask | show | jobs
Discuss: Google Cloud Spanner adds a PostgreSQL interface (datanami.com)
44 points by rkarthik007 1709 days ago
2 comments

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