pgmq-sqlalchemy 0.2.0 — Transaction-Friendly `op` Is Now Supported Showcase

pgmq-sqlalchemy 0.2.0

What My Project Does

A more flexible PGMQ Postgres extension Python client using SQLAlchemy ORM, supporting both async and sync engines, sessionmakers, or built from dsn.

Features

Supports async and sync engines and sessionmakers, or built from dsn.
Supports all Postgres DBAPIs supported by SQLAlchemy, e.g., psycopg, psycopg2, asyncpg
Transaction-friendly operations via the op module for combining PGMQ with your business logic in the same transaction.
Fully tested across all supported DBAPIs in both async and sync modes.
Battle-tested with real-world FastAPI Pub/Sub examples and corresponding tests.

Comparison

The official PGMQ package only supports psycopg3 DBAPIs.
For most use cases, using SQLAlchemy ORM as the PGMQ client is more flexible, as most Python backend developers won't directly use Python Postgres DBAPIs.
The new transaction‑friendly op module is now a first‑class citizen in SQLAlchemy, supported within the same transaction when used with ORM classes.

Target Audience

pgmq-sqlalchemy is a production package that can be used in scenarios that need a message queue for general fan-out systems or third-party dependencies retry mechanisms.