News for hackers. Stuff that matters.
Re:Introducing Cloud Spanner, a Global Database Service by koolba on Tuesday February 14, 2017 @12:25PM (#13645239)
What's the SQL and wire compatibility level? MySQL?

EDIT: Found quite a bit of my answers in your linked article:

> Cloud Spanner uses a SQL dialect which matches the ANSI SQL:2011 standard with some extensions for Spanner-specific features. This is a SQL standard simpler than that used in non-distributed databases such as vanilla MySQL, but still supports the relational model (e.g. JOINs). It includes data-definition language statements like CREATE TABLE. Spanner supports 7 data types: bool, int64, float64, string, bytes, date, timestamp[20].

> Cloud Spanner doesn't, however, support data manipulation language (DML) statements. DML includes SQL queries like INSERT and UPDATE. Instead, Spanner's interface definition includes RPCs for mutating rows given their primary key[21]. This is a bit annoying. You would expect a fully-featured SQL database to include DML statements. Even if you don't use DML in your application you'll almost certainly want them for one-off queries you run in a query console.

> Though Cloud Spanner supports a smaller set of SQL than many other relational databases, its dialect is well-documented and fits our use case well. Our requirements for a MySQL replacement are that it supports secondary indices and common SQL aggregations, such as the GROUP BY clause. We've eliminated most of the joins we do, so we haven't tested Cloud Spanner's join performance.

This seems like it'd prevent any kind of easy switch over to Spanner.

Re:Introducing Cloud Spanner, a Global Database Service by deesix on Tuesday February 14, 2017 @12:47PM (#13645437)
Just to be clear, the JOINS were removed for the vertical sharding prior to looking at Cloud Spanner. Cloud Spanner fully supports complex JOINS of many times (e.g. INNER, OUTER)

Details - https://cloud.google.com/spanner/docs/query-syntax#join-type...

Disclaimer: I work on Cloud Spanner

Re:Introducing Cloud Spanner, a Global Database Service by toadthewet on Wednesday February 15, 2017 @12:59AM (#13650064)
How did you go from 10s of ms for an update for 2012 Spanner, to sub-ms update (best case) for Cloud Spanner according to Quizlet? Did TrueTime get an order of magnitude better? Or is Quizlet measuring the wrong thing?
Re:Introducing Cloud Spanner, a Global Database Service by koolba on Tuesday February 14, 2017 @12:49PM (#13645457)
Sorry for the confusion but I meant the DML portion.
Re:Introducing Cloud Spanner, a Global Database Service by MichaelGG on Tuesday February 14, 2017 @01:30PM (#13645839)
It sounded like you can only modify by primary key? Can you make a transaction that contains a query and a bunch of updates by PK ?

And yeah it makes it sound like writing an OEM adapter will be much more difficult.

Re:Introducing Cloud Spanner, a Global Database Service by obstinate on Tuesday February 14, 2017 @02:21PM (#13646297)
From reading the docs, the answer seems to clearly be yes, but I'm open to being corrected.
Re:Introducing Cloud Spanner, a Global Database Service by havermeyer on Tuesday February 14, 2017 @12:33PM (#13645306)
It has the same basis as standard SQL in BigQuery: https://cloud.google.com/bigquery/docs/reference/standard-sq...
Re:Introducing Cloud Spanner, a Global Database Service by saycheese on Tuesday February 14, 2017 @12:46PM (#13645429)
Seems more like they want all the data that ever existed for the database.