pgrx is a Rust framework for writing PostgreSQL extensions with idiomatic safety, automatic schema generation, and a managed cargo-based dev toolchain supporting Postgres 13-18.
Key Takeaways
cargo-pgrx handles the full dev loop: scaffold, init multiple PG versions, run interactively in psql, unit-test across versions, and package for distribution.
Rust panics translate to Postgres ERRORs that abort the transaction, not the process; memory management follows Rust drop semantics even across elog(ERROR).
#[pg_extern], #[pg_trigger], #[derive(PostgresType)], and #[derive(PostgresEnum)] let you expose Rust functions and types to Postgres with minimal boilerplate.
SQL schema is generated automatically from Rust types; the full Postgres-to-Rust type mapping covers ranges, JSON/JSONB, UUIDs, arrays, and numerics.
Threading is explicitly unsupported: threads must never call Postgres internals, and async interaction with Postgres remains unexplored territory.