Discuss: Google Cloud Spanner adds a PostgreSQL interface

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

44 points by rkarthik007 4 years ago | 6 comments

Announcement on Google Cloud blog:

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

jeffbee 4 years ago | |

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.

adamfeldman 4 years ago | | |

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

frakkingcylons 4 years ago | |

Thank you, this should be the main link.

johnthuss 4 years ago |

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

adamfeldman 4 years ago | |

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