Discuss: Google Cloud Spanner adds a PostgreSQL interface

#1

Post by rkarthik007 » Tue, Oct 12, 2021, 5:33 PM UTC

Discuss: Google Cloud Spanner adds a PostgreSQL interface
datanami.com

Re: Discuss: Google Cloud Spanner adds a PostgreSQL interface

#2

Post by adamfeldman » Tue, Oct 12, 2021, 8:49 PM UTC

Announcement on Google Cloud blog:

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

Re: Discuss: Google Cloud Spanner adds a PostgreSQL interface

#3

Post by jeffbee » Tue, Oct 12, 2021, 9:02 PM UTC

adamfeldman wrote: post #2

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.

Re: Discuss: Google Cloud Spanner adds a PostgreSQL interface

#4

Post by frakkingcylons » Tue, Oct 12, 2021, 9:35 PM UTC

adamfeldman wrote: post #2

Announcement on Google Cloud blog: https://cloud.google.com/blog/topics/developers-practitioner...

Thank you, this should be the main link.

Re: Discuss: Google Cloud Spanner adds a PostgreSQL interface

#5

Post by johnthuss » Tue, Oct 12, 2021, 9:39 PM UTC

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

Re: Discuss: Google Cloud Spanner adds a PostgreSQL interface

#6

Post by adamfeldman » Tue, Oct 12, 2021, 10:29 PM UTC

johnthuss wrote: post #5

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

Re: Discuss: Google Cloud Spanner adds a PostgreSQL interface

#7

Post by adamfeldman » Tue, Oct 12, 2021, 10:30 PM UTC

jeffbee wrote: post #3

adamfeldman wrote: post #2

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