til-about-cloudspanner

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #ai #typescript #llm #go #golang #android #machine-learning #rust #deep-learning #linux

til-about-cloudspanner

★ 19 Open GitHub ↗

Learn about Cloud Spanner with sample source code around best practices

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Things-I-learned about Cloud Spanner Video & Content Series

This repository contains source code accompanying the TIL about Cloud Spanner
Video and Content Series.

## Published Content

1. [First Steps](01-first-steps/README.md) with Cloud Spanner ([blog post](https://goo.gl/XRyjEU), [video](https://goo.gl/ZKNs3X))
1. [Choosing the right Primary Keys](02-choosing-right-primary-keys/README.md) ([blog post](https://goo.gl/XQtVzX), [video](https://goo.gl/VQHE21))
1. [Maximizing data load throughput](03-maximizing-data-load-throughput/README.md) ([blog post](https://goo.gl/bFdaq1), [video](https://goo.gl/Dwpv7E))

## Requirements to run the samples

- [Google Cloud Project](https://console.cloud.google.com)
- Google Cloud Spanner Instance (refer to the [Cloud Spanner](https://cloud.google.com/spanner/docs/quickstart-console) docs on how to create a Cloud Spanner Instance)
- Bucket in Google Cloud Storage (refer to the [GCS docs](https://cloud.google.com/storage/docs/quickstart-console) on how to create a bucket)
- Google Cloud Container Registry (refer to the [Container Registry docs](https://cloud.google.com/container-registry/docs/quickstart) how to enable the registry)

### Create a GCE instance and install all required packages

```bash
gcloud compute instances create cloud-spanner-til-01 --zone europe-west1-c --machine-type n1-highcpu-16 --scopes "https://www.googleapis.com/auth/cloud-platform" --image-project ubuntu-os-cloud --image-family ubuntu-1710
gcloud compute scp scripts/setup.sh cloud-spanner-til-01:setup.sh --zone europe-west1-c
gcloud compute ssh cloud-spanner-til-01 --zone europe-west1-c --command "sudo sh setup.sh"
```

## Developing and Testing locally

If you develop on your local machine it's recommended to use a service account.
To generate one that has the permissions to connect to Google Cloud Spanner and
write to Google Cloud Storage run the following commands:

```bash
export CSTIL_PROJECT=`gcloud config list --format 'value(core.project)'`
gcloud iam service-accounts create cloud-spanner-til --display-name "Cloud Spanner TIL Service Account - generated"
gcloud iam service-accounts keys create service-account.json --iam-account cloud-spanner-til@$CSTIL_PROJECT.iam.gserviceaccount.com
gcloud projects add-iam-policy-binding cloud-spanner-til --member serviceAccount:cloud-spanner-til@$CSTIL_PROJECT.iam.gserviceaccount.com --role roles/spanner.admin
gcloud projects add-iam-policy-binding cloud-spanner-til --member serviceAccount:cloud-spanner-til@$CSTIL_PROJECT.iam.gserviceaccount.com --role roles/storage.objectAdmin
```

## Contributing

Contributions to this repository are always welcome and highly encouraged.

See [CONTRIBUTING](CONTRIBUTING.md) for more information on how to get started.

## License

Apache 2.0 - See [LICENSE](LICENSE) for more information.

*This is not an official Google product*

til-about-cloudspanner

Today's picks

Was this content helpful?

Recent Feedback

til-about-cloudspanner

Today's picks

Was this content helpful?

Recent Feedback

Download README