pglite-oxide 0.5.0

pglite-oxide brings PGlite/Postgres to Rust with a small API. Open a database directly with Pglite, or hand PgliteServer to SQLx and any standard Postgres client. The packaged runtime is PostgreSQL 17.5. No local Postgres install, no Docker, no runtime build toolchain.

Add Postgres In One Minute ⚡

Already using SQLx or another Postgres client? Add the crate and point your client at an embedded database URL:

cargo add pglite-oxide

use pglite_oxide::PgliteServer;
use sqlx::{Connection, Row};

#[tokio::main]
async fn main() -> Result<(), Box<dyn std::error::Error>> {
    let server = PgliteServer::temporary_tcp()?;
    // For a persistent TCP server:
    // let server = PgliteServer::builder().path("./.pglite").start()?;
    let mut conn = sqlx::PgConnection::connect(&server.database_url()).await?;

    let row = sqlx::query("SELECT $1::int4 + 1 AS answer")
        .bind(41_i32)
        .fetch_one(&mut conn)
        .await?;
    assert_eq!(row.try_get::<i32, _>("answer")?, 42);

    conn.close().await?;
    server.shutdown()?;
    Ok(())
}

That's it. Real PostgreSQL, no service setup.

Why pglite-oxide ✨

Postgres should be as easy to add to a Rust project as SQLite.

• ⚡ No service tax: no Docker, no local Postgres, no testcontainers.
• 🔌 Use your real stack: SQLx, tokio-postgres, CLIs, and other clients connect through a normal local URL.
• 🌉 Proxy included: expose an embedded database to non-Rust tools with pglite-proxy.
• 🧪 Clean tests: temporary databases are isolated, fast, and removed on drop.
• 💾 Persistent apps: keep local app data across restarts when you want it.
• 🧩 Extensions included: pgvector, pg_trgm, hstore, citext, and more.
• 📦 Portable dumps: use bundled pg_dump for logical backups and upgrade paths.
• 🚀 Near-native feel: close to native Postgres, fully embedded.

Near-Native Performance 🚀

Current local snapshot on Apple M1 Pro, 16 GB RAM, and macOS 26.4.1. Full numbers and reproduction steps live in the performance guide. Lower is better.

pglite-oxide stays close to native Postgres while running entirely embedded and consistently performs better than vanilla PGlite.

Extensions 🧩

Bundled extensions are supported, including pgvector, pg_trgm, hstore, citext, ltree, and more. See the extensions guide for the full catalog and usage details.

use pglite_oxide::{extensions, PgliteServer};
use sqlx::Connection;

#[tokio::main]
async fn main() -> Result<(), Box<dyn std::error::Error>> {
    let server = PgliteServer::builder()
        .path("./.pglite")
        .extension(extensions::VECTOR)
        .start()?;
    let mut conn = sqlx::PgConnection::connect(&server.database_url()).await?;

    sqlx::query("CREATE TABLE IF NOT EXISTS items (embedding vector(3))")
        .execute(&mut conn)
        .await?;
    sqlx::query("INSERT INTO items VALUES ('[1,2,3]')")
        .execute(&mut conn)
        .await?;

    conn.close().await?;
    server.shutdown()?;
    Ok(())
}

Docs

• Usage guide
• Extensions
• Performance guide
• Dump and upgrade guide
• Testing guide
• Tauri usage
• Runtime guide