pygwire 0.0.2

Low-level PostgreSQL wire protocol (3.0 & 3.2) codec for Python

🐘 pygwire 🐍

A low-level PostgreSQL wire protocol codec for Python

[!WARNING] Early stage project. Pygwire is under active development. The API is not yet stable and breaking changes should be expected between releases.

---

Pygwire is a sans-I/O PostgreSQL wire protocol (v3.0 and v3.2) codec. All codec and state machine logic is I/O-independent, making it portable across asyncio, trio, synchronous sockets, or any other transport.

✨ Features

• Sans-I/O design. No I/O dependencies. Bring your own transport.
• Zero-copy parsing. Uses memoryview for buffer slicing.
• Complete protocol coverage. All PostgreSQL v3.0 and v3.2 wire protocol messages.
• Protocol state machines. Validate message sequences for both client and server roles.
• Zero dependencies. No runtime dependencies.
• Fully typed. Ships with py.typed marker for PEP 561 support.

📦 Installation

pip install pygwire

Or with uv:

uv add pygwire

🚀 Quick Start

📖 Read the full documentation →

from pygwire import FrontendConnection
from pygwire.messages import StartupMessage, Query

conn = FrontendConnection()
sock.send(conn.send(StartupMessage(params={"user": "postgres", "database": "mydb"})))

# Authentication, queries, and more - see the docs!

🏗️ Architecture

Pygwire is organized into four layers, from low-level to high-level:

Layer	Module	Purpose
Messages	pygwire.messages	Encode and decode all PostgreSQL protocol messages
Codec	pygwire.codec	Incremental stream decoder with zero-copy framing
State Machine	pygwire.state_machine	Protocol phase tracking and message validation
Connection	pygwire.connection	Coordinated decoder + state machine (sans-I/O)

Use the lower layers independently for maximum control, or use Connection for a higher-level API that coordinates them together.

[!NOTE] Pygwire follows PostgreSQL's naming convention: backend = server, frontend = client.

📋 Requirements

• Python 3.11+
• No runtime dependencies

📚 Documentation

📖 Full documentation, tutorials, and API reference →

Additional Resources

• PostgreSQL Wire Protocol (official)
• PostgreSQL Message Formats

🤝 Contributing

See CONTRIBUTING.md for development setup and guidelines.