Stack Overflow
Stack Overflow

Questions tagged [google-cloud-spanner]

Google Cloud Spanner is a relational, highly scalable, managed, database service. Cloud Spanner solves the need for a horizontally-scaling database with consistent global ACID transactions and SQL semantics

Google Cloud Spanner is the first and only relational database service that is both strongly consistent and horizontally scalable. Features include:

  • ACID transactions,
  • Relational schemas (and schema changes without downtime),
  • SQL queries, high performance,
  • Automatic scaling for horizontal scalability to hundreds or thousands of servers
  • Synchronous data replication, and node redundancy
  • Up to 99.999% (five 9s) of availability
  • Based upon the published Spanner research paper

Stack Overflow is Google's official community support channel for development questions.

Please include the appropriate client library language tag (, , , or ) with your question. You can also include the platform tag (, , or ).

475 questions
96
votes
3 answers

What's the difference between BigQuery and BigTable?

Is there any reason why someone would use BigTable instead of BigQuery? Both seem to support Read and Write operations with the latter offering also advanced 'Query' operations. I need to develop an affiliate network (thus I need to track clicks and…
The user with no hat
  • 7,550
  • 12
  • 44
  • 71
34
votes
1 answer

Why is Google's TrueTime API hard to duplicate?

I'm not sure why the press in general says that Google's TrueTime API is hard to replicate (Wired, Slashdot, etc). I can understand how it would be a tough thing to get the low error intervals that Google is achieving, but I don't see how the API…
Jon Bringhurst
  • 1,320
  • 1
  • 10
  • 21
21
votes
4 answers

Local development with cloud-spanner

Is there any way to do local development with cloud spanner? I've taken a look through the docs and the CLI tool and there doesn't seem to be anything there. Alternatively, can someone suggest a SQL database that behaves similarly for reads (not…
Daniel Compton
  • 11,420
  • 4
  • 33
  • 55
13
votes
4 answers

External Backups/Snapshots for Google Cloud Spanner

Is it possible to snapshot a Google Cloud Spanner Database/table(s)? For compliance reasons we have to have daily snapshots of the current database that can be rolled back to in the event of a disaster: is this possible in Spanner? Is there…
user3707
  • 1,400
  • 2
  • 13
  • 19
11
votes
3 answers

What's the difference between Google Cloud Spanner and Cloud SQL?

I am novice in GCP stack so I am so confused about amount GCP technologies for storing data: https://cloud.google.com/products/storage Although google cloud spanner is not mentioned in the article above I know that it is exist and iti is used for…
gstackoverflow
  • 31,683
  • 83
  • 267
  • 574
10
votes
1 answer

Avoiding hash-join with IN clause and sub-query in Spanner

I have the following query optimization problem in Spanner, and hoping there's a trick I'm missing that will help me bend the query planner to my will. Here's the simplified schema: create table T0 ( key0 int64 not null, value int64, other…
Joel Webber
  • 222
  • 1
  • 7
8
votes
1 answer

What is the TrueTime API in Google's Spanner?

I tried to read the document multiple times but failed to understand it. Can someone explain it in layman's terms?
Sundar
  • 305
  • 2
  • 9
7
votes
4 answers

Differences between Strict Serializable and External Consistency

I follow this great blog. In this blog, the author has drawn a complete picture of all types of isolation and consistency and the relationship between them. But based on the Google's blog, there is another type of consistency named External…
Trần Kim Dự
  • 4,962
  • 6
  • 39
  • 81
7
votes
2 answers

Google Cloud Spanner database pricing when idle

After reading the pricing of the new google relational database Spanner, it states that the cost is based on storage and use. They charge $0.9 by hour per node. The question is: if I create the database for development, and only use it 6 hours a…
Rene Marty
  • 521
  • 4
  • 13
6
votes
2 answers

Cloud SQL Horizontal Scaling

Is cloud spanner the only solution for horizontal scaling of mysql instances on the google cloud? Is there a way to scale in cloud sql?
fritz
  • 121
  • 1
  • 9
6
votes
1 answer

Does Google Cloud Spanner support default column values?

Having the capability to compute a UTC timestamp as the default value for a column is a handy feature of most popular database solutions. Does Google Cloud Spanner support this? If not, is this a possible roadmap item?
Frank Ayars
  • 63
  • 5
6
votes
1 answer

Cloud Spanner — Equivalent Syntax for `SHOW TABLES`?

It's not clear how to run a query (or conduct an API call) to list all tables. Is this possible with Spanner?
abhillman
  • 3,342
  • 1
  • 16
  • 20
5
votes
2 answers

Understanding spanner explanation

I've a table of 860M rows in Google Cloud Spanner and I'm trying to understand how explanation works. The table has a string column geoid and there is an index at this column. When I run the following query it takes only 36ms: SELECT count(*) FROM…
alasarr
  • 1,535
  • 3
  • 16
  • 30
5
votes
2 answers

Difference between Google Cloud Firestore vs Google Cloud Spanner?

There seems to be an increasing overlapping and proliferation of cloud database technologies. In order to make sense of it a comparative approach might help. What are the exact differences between Google Cloud Firestore vs Google Cloud Spanner ?
Leo Gallucci
  • 15,165
  • 11
  • 66
  • 103
5
votes
1 answer

"Spanner operation failed" creating NULL_FILTERED indexes

I am unable to create indexes on Cloud Spanner tables, receiving the error, "Spanner operation failed". Even after increasing the cluster size to from 6 to 16 nodes, I am unable to create two indexes on a ~12 million row table. What I did: Created…
dsquier
  • 258
  • 1
  • 8
1
2 3
…
31 32