Hacker News new | past | comments | ask | show | jobs | submit login
Discuss: Google Cloud Spanner adds a PostgreSQL interface (datanami.com)
44 points by rkarthik007 on Oct 12, 2021 | hide | past | favorite | 6 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




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: