#google-cloud #spanner #gcp

google-cloud-spanner

Google Cloud Platform spanner client library

39 releases (breaking)

0.27.0 May 7, 2024
0.25.0 Dec 28, 2023
0.24.0 Oct 15, 2023
0.23.0 Jul 21, 2023
0.2.0 Nov 28, 2021

#1 in #spanner

Download history 5971/week @ 2024-02-26 7418/week @ 2024-03-04 5046/week @ 2024-03-11 3287/week @ 2024-03-18 928/week @ 2024-03-25 1252/week @ 2024-04-01 1203/week @ 2024-04-08 2642/week @ 2024-04-15 1534/week @ 2024-04-22 1311/week @ 2024-04-29 1542/week @ 2024-05-06 3550/week @ 2024-05-13 1576/week @ 2024-05-20 1074/week @ 2024-05-27 1869/week @ 2024-06-03 1292/week @ 2024-06-10

5,835 downloads per month
Used in 2 crates

MIT license

2.5MB
32K SLoC

google-cloud-spanner

Google Cloud Platform spanner library.

crates.io

Installation

[dependencies]
google-cloud-spanner = "version"

Quickstart

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

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

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

     const DATABASE: &str = "projects/local-project/instances/test-instance/databases/local-database";

     // Create spanner client
     let config = ClientConfig::default().with_auth().await.unwrap();
     let mut client = Client::new(DATABASE, config).await.unwrap();

     // Insert
     let mutation = insert("Guild", &["GuildId", "OwnerUserID", "UpdatedAt"], &[&"guildId", &"ownerId", &CommitTimestamp::new()]);
     let commit_timestamp = client.apply(vec![mutation]).await?;

     // Read with query
     let mut stmt = Statement::new("SELECT GuildId FROM Guild WHERE OwnerUserID = @OwnerUserID");
     stmt.add_param("OwnerUserID",&"ownerId");
     let mut tx = client.single().await?;
     let mut iter = tx.query(stmt).await?;
     while let Some(row) = iter.next().await? {
         let guild_id = row.column_by_name::<String>("GuildId");
     }

     // Remove all the sessions.
     client.close().await;
     Ok(())
 }

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

Test condition

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

Dependencies

~16–30MB
~563K SLoC