A runtime-independent, asynchronous PostgreSQL client.

Pros

Usage

use async_postgres::connect;use std::error::Error;use async_std::task::spawn;asyncfnplay() ->Result<(),Box<dynError>>{let url ="host=localhost user=postgres";let(client, conn) =connect(url.parse()?).await?;spawn(conn);let row = client.query_one("SELECT * FROM user WHERE id=$1",&[&0]).await?;let value:&str = row.get(0);println!("value: {}", value);Ok(())}

use async_postgres::connect_tls;use native_tls::{Certificate,TlsConnector};use postgres_native_tls::MakeTlsConnector;use std::fs;use std::error::Error;use async_std::task::spawn;asyncfnplay() ->Result<(),Box<dynError>>{let cert = fs::read("database_cert.pem")?;let cert =Certificate::from_pem(&cert)?;let connector =TlsConnector::builder().add_root_certificate(cert).build()?;let connector =MakeTlsConnector::new(connector);let url ="host=localhost user=postgres sslmode=require";let(client, conn) =connect_tls(url.parse()?, connector).await?;spawn(conn);let row = client.query_one("SELECT * FROM user WHERE id=$1",&[&0]).await?;let value:&str = row.get(0);println!("value: {}", value);Ok(())}

Performance

Develop