¶

fastpg is a fast async PostgreSQL client for Python, written in Rust. It turns rows straight into msgspec Structs, so you get typed objects back with no extra code.

uv add fastpg

import asyncio

import msgspec

import fastpg


class Person(msgspec.Struct):
    name: str
    age: int


async def main() -> None:
    dsn = "postgresql://fastpg:fastpg@127.0.0.1:55432/fastpg"
    async with await fastpg.create_pool(dsn) as pool:
        query = "SELECT name, age FROM people WHERE id = $1"
        person = await pool.select_one(query, 42, into=Person)
        print(person)  # Person(name='person-42', age=60)


asyncio.run(main())

New here? Start with Getting started.

What you get¶

• Typed rows. into=Person gives you Structs. See Structs.
• A pool you query directly. No acquire() for a single query. See Connection pool.
• Safe parameters. $1, :name or t-strings. See Queries.
• Arrays and grouping. list[X] fields, lists as parameters, and select_and_group for one-to-many rows. See Arrays and grouping.
• Fast bulk writes. copy_in, insert_many, execute_many. See Bulk writes.
• Transactions, TLS and clear errors. See Transactions, TLS and Errors.
• pydantic too. If your app uses pydantic, see pydantic models.

Speed¶

All workloads and how they're measured: Benchmarks.

fastpg is alpha software. See what it can't do yet in Limitations.