[rust] tokio, bb8, tokio_postgres DB 연결 예시 코드

tokio 와 bb8을 이용한 postgres db 연결 기본 예시 코드

 

[main.rs]

use bb8;
use bb8::Pool;
use bb8_postgres::PostgresConnectionManager;
use tokio_postgres::NoTls;

#[tokio::main]
async fn main() {
    println!("Hello, world!");

    let manager =
        PostgresConnectionManager::new_from_stringlike("postgresql://{계정}:{암호}@localhost:5432/{db명}", NoTls).unwrap();
    let pool = Pool::builder().build(manager).await.unwrap();
    let conn = pool.get().await.unwrap();

    let row = conn.query_one("select 1 + 1", &[]).await.unwrap();
    let v : i32 = row.try_get(0).unwrap();

    println!("value: {}", v);
}

 

[Cargo.toml]

[package]
name = "패키지명"
version = "0.1.0"
edition = "2021"

[dependencies]
bb8 = "0.8.6"
bb8-postgres = "0.8.1"
tokio = { version = "1.41.1", features = ["full"] }
tokio-postgres = "0.7.12"