p3orm 0.1.0

Python PyPika Postgres ORM

porm

Minimal PostgreSQL Python ORM, backed by asyncpg, Pydantic, and PyPika.

Philosophy

90% of the time we talk to a database is with a CRUD operation. porm provides helpers

The remaining 10% is a bit more complicated. porm doesn't attempt to hide SQL queries behind any magic, instead it empowers you to write direct, explicit, and legible SQL queries with PyPika.

Object created or fetched by porm are dead, they're just (currently) Pydantic models. If you want to manipulate the database, you do so explicitly.

Roadmap

• Annotation type definition
• Relationships
• Tests
• Look into attrs over pydantic (does this actually need type validation)