Introduction

zero-postgres is a high-performance PostgreSQL client library for Rust. It provides both synchronous and asynchronous APIs with a focus on speed and minimal allocations.

[dependencies]
zero-postgres = "*"

Quick Start

use zero_postgres::sync::Conn;

let mut conn = Conn::new("postgres://user:password@localhost/dbname")?;

// Simple query
let rows: Vec<(i32, String)> = conn.query_collect("SELECT id, name FROM users")?;

// Parameterized query
let rows: Vec<(i32, String)> = conn.exec_collect("SELECT * FROM users WHERE id = $1", (42i32,))?;

// Transaction
conn.transaction(|conn, tx| {
    conn.exec_drop("INSERT INTO users (name) VALUES ($1)", ("Alice",))?;
    conn.exec_drop("INSERT INTO users (name) VALUES ($1)", ("Bob",))?;
    tx.commit(conn)
})?;

Features

• High Performance: Minimal allocations and copies
• Sync and Async: Both synchronous and async (tokio) APIs
• Pipelining: Batch multiple queries in a single round trip
• Type-safe: Rust’s type system for compile-time safety

Feature Flags

• sync (default) - Synchronous API
• tokio (default) - Asynchronous API using tokio
• sync-tls - TLS support for Synchronous API (experimental)
• tokio-tls - TLS support for Asynchronous API (experimental)

Benchmark

Inserting 10,000 rows using prepared statements (average of 10 iterations):