Live data from Hacker News

Introducing Cloud Spanner, a Global Database Service

cloudplatform.googleblog.com

341–350 of 456 posts

Re: Introducing Cloud Spanner, a Global Database Service

#341
post #263

Is JSON data type support in the works? Seems to be a very commonly requested feature these days.

Yes, it's something we have on the roadmap. We will adjust priority based on the level of demand so thanks for your vote ;-) (disclaimer: I work on Cloud Spanner)

Dumb question: Since strings are supported, couldn't you just store some JSON as a string? Or are you talking about supporting queries that involve parsing the JSON on the "server"?

Re: Introducing Cloud Spanner, a Global Database Service

#344
post #263

Earlier quoted context omitted.

Yes, it's something we have on the roadmap. We will adjust priority based on the level of demand so thanks for your vote ;-) (disclaimer: I work on Cloud Spanner)

Dumb question: Since strings are supported, couldn't you just store some JSON as a string? Or are you talking about supporting queries that involve parsing the JSON on the "server"?

Yeah, parent probably meant queryable JSON types, a la Postgres[1].

1: https://www.postgresql.org/docs/9.4/static/datatype-json.htm...

Re: Introducing Cloud Spanner, a Global Database Service

#345
post #263

Earlier quoted context omitted.

Yes, it's something we have on the roadmap. We will adjust priority based on the level of demand so thanks for your vote ;-) (disclaimer: I work on Cloud Spanner)

Dumb question: Since strings are supported, couldn't you just store some JSON as a string? Or are you talking about supporting queries that involve parsing the JSON on the "server"?

Not dumb, I was being inexact. I was talking about Spanner understanding the semantics of JSON, similar to Postgre's JSONB or MYSQL's JSON.

Re: Introducing Cloud Spanner, a Global Database Service

#346

This release shows the different philosophies of Google vs Amazon in an interesting way. Google prefers building advanced systems that let you do things "the old way" but making them horizontally scalable. Amazon prefers to acknowledge that network partitions exist and try to get you to do things "the new way" that deals with that failure case in the software instead of trying to hide it. I'm not saying either system…

This isn't entirely accurate. BigTable was Google's earlier cloud database, and it's certainly non-traditional, and you have to build your application without traditional consistency guarantees, the way you describe. Spanner doesn't exactly hide the details, but it lets you make transactions that span multiple shards. You still eat the cost of the transaction, you're just free from having to implement it at the appli…

Same for GAE, or now GKE (basically microservices before microservices were a thing) vs. EC2. GAE was pushing a fairly non-traditional architectural model while others were just trying to provide cloud-based VMs.

Discolsure: Also a Google employee, also reconstructing.

Re: Introducing Cloud Spanner, a Global Database Service

#347
post #322

Some interesting stuff in https://cloud.google.com/spanner/docs/whitepapers/SpannerAnd... about the social aspects of high availability. 1. Defining high availability in terms of how a system is used: "In turn, the real litmus test is whether or not users (that want their own service to be highly available) write the code to handle outage exceptions: if they haven’t written that code, then they are assuming high avai…

> perceived safety ... driving I became a way better winter driver when I started intentionally fishtailing in snow and ice (in low risk situations).

There's also research showing that removing safety features, e.g. white lines between opposing lanes, increases safety.

http://www.bbc.com/news/uk-35480736

Re: Introducing Cloud Spanner, a Global Database Service

#350

So does Cloud Spanner replace the existing Google Cloud SQL offering [1]? What are the pros/cons of each? [1] https://cloud.google.com/sql/

It much closer to the Datastore https://cloud.google.com/datastore/ which also has co-located parent-child tables and GQL instead of SQL, and automatic horizontal scalability
Post reply on HN