async-postgres

A runtime-independent, asynchronous PostgreSQL client.

[![Stable Test](https://github.com/Hexilee/async-postgres/workflows/Stable%20Test/badge.svg)](https://github.com/Hexilee/async-postgres/actions) [![codecov](https://codecov.io/gh/Hexilee/async-postgres/branch/master/graph/badge.svg)](https://codecov.io/gh/Hexilee/async-postgres) [![Rust Docs](https://docs.rs/async-postgres/badge.svg)](https://docs.rs/async-postgres) [![Crate version](https://img.shields.io/crates/v/async-postgres.svg)](https://crates.io/crates/async-postgres) [![Download](https://img.shields.io/crates/d/async-postgres.svg)](https://crates.io/crates/async-postgres) [![MSRV-1.40](https://img.shields.io/badge/MSRV-1.40-blue.svg)](https://blog.rust-lang.org/2019/12/19/Rust-1.40.0.html) [![License: MIT](https://img.shields.io/badge/License-MIT-yellow.svg)](https://github.com/Hexilee/async-postgres/blob/master/LICENSE)


This crate is a wrapper of tokio-postgres.

Pros

Runtime-independent, can be used on any async runtime.

Usage

Almost the same with tokio-postgres.

```rust use asyncpostgres::connect; use std::error::Error; use asyncstd::task::spawn;

async fn play() -> Result<(), Box> { 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(()) } ```

```rust use asyncpostgres::connecttls; use nativetls::{Certificate, TlsConnector}; use postgresnativetls::MakeTlsConnector; use std::fs; use std::error::Error; use asyncstd::task::spawn;

async fn play() -> Result<(), Box> { let cert = fs::read("databasecert.pem")?; let cert = Certificate::frompem(&cert)?; let connector = TlsConnector::builder() .addrootcertificate(cert) .build()?; let connector = MakeTlsConnector::new(connector); let url = "host=localhost user=postgres sslmode=require"; let (client, conn) = connecttls(url.parse()?, connector).await?; spawn(conn); let row = client.queryone("SELECT * FROM user WHERE id=$1", &[&0]).await?; let value: &str = row.get(0); println!("value: {}", value); Ok(()) } ```

Performance

Almost the same with tokio-postgres, you can see a live benchmark here.

Develop

Running tests needs a postgres server and environment variables: - TCP_URL="postgresql:///<db>?host=<tcp host>&port=<port>&user=<user>&password=<passwd>" - UDS_URL="postgresql:///<db>?host=<postgres uds dir>&port=<port>&user=<user>&password=<passwd>"