Cloud Spanner: Node.js Client

Cloud Spanner is a fully managed, mission-critical, relational database service that offers transactional consistency at global scale, schemas, SQL (ANSI 2011 with extensions), and automatic, synchronous replication for high availability.

A comprehensive list of changes in each version may be found in the CHANGELOG.

Read more about the client libraries for Cloud APIs, including the older Google APIs Client Libraries, in Client Libraries Explained.

Table of contents:

Quickstart

Before you begin

Select or create a Cloud Platform project.
Enable billing for your project.
Enable the Cloud Spanner API.
Set up authentication with a service account so you can access the API from your local workstation.

Installing the client library

npm install @google-cloud/spanner

Using the client library

// Imports the Google Cloud client library
const {Spanner} = require('@google-cloud/spanner');

// Creates a client
const spanner = new Spanner({projectId});

// Gets a reference to a Cloud Spanner instance and database
const instance = spanner.instance(instanceId);
const database = instance.database(databaseId);

// The query to execute
const query = {
  sql: 'SELECT 1',
};

// Execute a simple SQL statement
const [rows] = await database.run(query);
console.log(`Query: ${rows.length} found.`);
rows.forEach(row => console.log(row));

Samples

Samples are in the samples/ directory. Each sample's README.md has instructions for running its sample.

Sample	Source Code	Try it
Backups-cancel	source code
Backups-create-with-encryption-key	source code
Backups-create	source code
Backups-delete	source code
Backups-get-database-operations	source code
Backups-get-operations	source code
Backups-get	source code
Backups-restore-with-encryption-key	source code
Backups-restore	source code
Backups-update	source code
Backups	source code
Batch	source code
CRUD	source code
Database-create-with-encryption-key	source code
Database-create-with-version-retention-period	source code
Datatypes	source code
DML	source code
Get-commit-stats	source code
Creates a new value-storing index	source code
Creates a new index	source code
Executes a read-only SQL query using an existing index.	source code
Reads data using an existing storing index.	source code
Read data using an existing index.	source code
Indexing	source code
Instance-with-processing-units	source code
Instance	source code
Numeric-add-column	source code
Numeric-query-parameter	source code