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.

```rust use googlecloudspanner::client::Client; use googlecloudspanner::client::Client; use googlecloudspanner::mutation::insert; use googlecloudspanner::statement::Statement; use googlecloudspanner::reader::AsyncIterator; use googlecloudspanner::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.

| Metrics | This library | Google Cloud Go | | -------- | ----------------| ----------------- | | RPS | 438.4 | 443.4 | | Used vCPU | 0.37 ~ 0.42 | 0.65 ~ 0.70 |

• 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.