[HN Gopher] Discuss: Google Cloud Spanner adds a PostgreSQL inte...
___________________________________________________________________
Discuss: Google Cloud Spanner adds a PostgreSQL interface
Author : rkarthik007
Score : 35 points
Date : 2021-10-12 17:33 UTC (5 hours ago)
(HTM) web link (www.datanami.com)
(TXT) w3m dump (www.datanami.com)
| johnthuss wrote:
| 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 wrote:
| 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
| adamfeldman wrote:
| Announcement on Google Cloud blog:
|
| https://cloud.google.com/blog/topics/developers-practitioner...
| frakkingcylons wrote:
| Thank you, this should be the main link.
| jeffbee wrote:
| 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 wrote:
| 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
___________________________________________________________________
(page generated 2021-10-12 23:02 UTC)