google-cloud-spanner

Google Cloud Platform spanner library.

• About Cloud Spanner
• Spanner API Documentation
• Rust client Documentation

Installation

[dependencies]
google-cloud-spanner = <version>

Quick Start

Create Client and call transaction API same as Google Cloud Go.

use google_cloud_spanner::client::Client;
use google_cloud_spanner::client::Client;
use google_cloud_spanner::mutation::insert;
use google_cloud_spanner::statement::Statement;
use google_cloud_spanner::reader::AsyncIterator;
use google_cloud_spanner::value::CommitTimestamp;

#[tokio::main]
async fn main() -> Result<(), Error> {

    const DATABASE: &str = "projects/your_project/instances/your-instance/databases/your-database";
   
    // Create spanner client
    let mut client = match Client::new(DATABASE).await?;

    // Insert 
    let mutation = insert("Table", &["col1", "col2", "col3"], &[&1, &"strvalue", &CommitTimestamp::new()]);
    let commit_timestamp = client.apply(vec![mutation]).await?;
    
    // Read with query
    let mut stmt = Statement::new("SELECT col2 FROM Table WHERE col1 = @col1");
    stmt.add_param("col1",&1);
    let mut tx = client.single().await?;
    let mut iter = tx.query(stmt).await?;
    while let some(row) = iter.next().await? {
        let col2 = row.column_by_name::<String>("col2");
    }
}

Example

Here is the example with using Warp.

• https://github.com/yoshidan/google-cloud-rust-example/tree/main/spanner/rust

Performance

Result of the 24 hours Load Test.

• This Library : Performance report / CPU Usage
• Google Cloud Go : Performance report / CPU Usage

Test condition

• 2.0 vCPU GKE Autopilot Pod
• 1 Node spanner database server
• 100 Users
• Here is the application for Load Test.