APIs & reference

• Overview of APIs and client libraries

  The client libraries, the RPC API, and the REST API provide programmatic access to Spanner.

• Spanner client libraries

  Get started with Spanner in your language of choice.

• JDBC drivers

  Overview of the JDBC drivers available for use with Spanner.

• Connect JDBC to a GoogleSQL-dialect database

  How to use the Spanner JDBC driver to update a database schema, add and update rows using DML statements in autocommit mode and as part of a batch transaction, and run a SQL query.

• Spanner JDBC driver FAQ

  FAQ for Spanner's open-source JDBC driver written by Google.

• Connect JDBC to a PostgreSQL-dialect database

  How to use the PostgreSQL JDBC driver with a PostgreSQL-dialect database.

• Connect JDBC to a PostgreSQL-dialect database

  How to use the PostgreSQL JDBC driver with a PostgreSQL-dialect database.

• RPC reference

  Spanner's RPC API reference.

• REST reference

  Spanner's REST API reference.

• GoogleSQL lexical structure and syntax

  GoogleSQL reference for identifiers, literals, keywords, operators, and special characters.

• GoogleSQL data definition language (DDL)

  DDL reference for creating, altering, or dropping tables and indexes in a GoogleSQL database.

• GoogleSQL data manipulation language syntax

  Reference for GoogleSQL's data manipulation language.

• GoogleSQL query syntax

  GoogleSQL reference for executing SELECT statements.

• GoogleSQL functions and operators

  GoogleSQL expressions, including functions and operators.

• PostgreSQL lexical structure and syntax

  Reference for identifiers, literals, keywords, operators, and special characters in PostgreSQL databases.

• PostgreSQL data definition language

  Reference for data definition language (DDL) statements in PostgreSQL databases.

• PostgreSQL data manipulation language

  Reference for data manipulation language (DML) statements in PostgreSQL databases.

• PostgreSQL queries

  Reference for the SELECT statement in PostgreSQL databases.

• PostgreSQL subqueries

  Reference for subqueries in PostgreSQL databases.

• PostgreSQL data types

  Reference for supported data types in PostgreSQL databases.

• PostgreSQL functions

  Reference for supported functions in PostgreSQL databases.

• Information schema

  Reference for the built-in schema that's common to every Spanner database.

• Query optimizer version history

  The built-in table that stores optimizer version information.

• Query execution operators

  Operators used in Spanner query execution plans.

• Google Cloud CLI

  Common gcloud commands for interacting with Spanner from the command line.

• psql command-line tool

  Reference for psql command support in the PostgreSQL interface for Spanner.