5 unstable releases

0.3.0 Sep 27, 2022
0.2.0 Nov 10, 2021
0.1.1 Oct 9, 2021
0.1.1-rc.1 Oct 6, 2021
0.1.0 Sep 29, 2021

#19 in #spanner

47 downloads per month

MIT license

2.5K SLoC


An asynchronous Rust client for Cloud Spanner.

Build Status Crates.io Documentation Crates.io


The client uses gRPC to interface with Cloud Spanner. As such, this crate uses tonic and related crates (i.e.: prost, tower and tokio).

The client also uses bb8 to maintain a pool of Cloud Spanner sessions (conceptually similar to a connection pool in other databases).

The implementation is heavily inspired by the excellent postgres and related crates.


Spanner is a complex database and this client does not implement all available features. The current focus is on getting idiomatic SQL support for both reads and writes.

It's not recommended to use this in production for any serious workload.


Database Client

  • SQL read-only, single use, time-bounded transactions
  • SQL read-write transactions with retries
  • Type classes to convert Rust values to/from Cloud Spanner values
  • Timestamp and Date type support (chrono feature?)
  • Json type support (serde json feature)
  • Streaming result sets
  • Derive ToSpanner and FromSpanner for structs

Admin Client

  • DDL statements


use spanner_rs::{Client, Error, ReadContext, TransactionContext};

async fn main() -> Result<(), Error> {
    let mut client = Client::configure()

    // assuming the following table:
    //   person(id INT64, name STRING(MAX), data BYTES(MAX))
        .run(|tx| {
                "INSERT INTO person(id, name, data) VALUES(@id, @name, NULL)",
                &[("id", &42), ("name", &"ferris")],

    let result_set = client
        .execute_query("SELECT * FROM person", &[])

    for row in result_set.iter() {
        let id: u32 = row.get("id")?;
        let name: &str = row.get("name")?;
        let data: Option<&[u8]> = row.get("data")?;

        println!("found person: {} {} {:?}", id, name, data);



~1.5M SLoC