4 ms·
Discuss: Google Cloud Spanner adds a PostgreSQL interface
- adamfeldman 5y agoAnnouncement on Google Cloud blog: https://cloud.google.com/blog/topics/developers-practitioners/postgresql-interface-adds-familiarity-and-portability-cloud-spanner https://cloud.google.com/blog/topics/developers-practitioner...
- jeffbee 5y agoHow 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 5y agoI just linked the SQL dialect docs elsewhere in this thread: https://news.ycombinator.com/item?id=28845881 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 https://cloud.google.com/spanner/docs/open-source-jdbc
- frakkingcylons 5y agoThank you, this should be the main link.
- johnthuss 5y agoIt looks like Spanner already supported their own SQL interface. So are there significant differences between their Google SQL syntax and the PostgreSQL syntax?
- adamfeldman 5y agoLooks like the docs are live alongside the announcement – "The PostgreSQL language in Cloud Spanner": https://cloud.google.com/spanner/docs/postgresql/overview https://cloud.google.com/spanner/docs/postgresql/overview "PostgreSQL interface" under the Concepts section: https://cloud.google.com/spanner/docs/postgresql-interface https://cloud.google.com/spanner/docs/postgresql-interface