actiongate-postgres

Shared PostgreSQL store adapter for ActionGate, BudgetGate, RuleGate, and AuditGate.

Uses psycopg (psycopg3) with connection pooling. One pool shared across all gate stores.

Install

pip install actiongate-postgres

# Install with specific gate support:
pip install actiongate-postgres[actiongate]
pip install actiongate-postgres[all]  # all four gates

Quickstart

import psycopg
from actiongate import Engine, Gate, Policy
from actiongate_postgres import ConnectionManager, ActionGatePostgresStore, create_tables

# Create shared pool
mgr = ConnectionManager("postgresql://localhost/mydb")

# Create tables (idempotent)
with mgr.pool.connection() as conn:
    create_tables(conn)

# Wire store to engine
store = ActionGatePostgresStore(mgr)
engine = Engine(store=store)

engine.register(Gate("api", "send_email", "user-42"), Policy(max_calls=5, window=60))
result = engine.check(Gate("api", "send_email", "user-42"))
print(result)  # Decision(status=ALLOW, ...)

mgr.close()

Async

from actiongate_postgres import AsyncConnectionManager, AsyncActionGatePostgresStore

async with AsyncConnectionManager("postgresql://localhost/mydb") as mgr:
    store = AsyncActionGatePostgresStore(mgr)
    # use with async engine...

Multiple Gates, One Pool

from actiongate_postgres import (
    ConnectionManager,
    ActionGatePostgresStore,
    BudgetGatePostgresStore,
    AuditGatePostgresStore,
    create_tables,
)

mgr = ConnectionManager("postgresql://localhost/mydb")

with mgr.pool.connection() as conn:
    create_tables(conn)

ag_store = ActionGatePostgresStore(mgr)
bg_store = BudgetGatePostgresStore(mgr)
audit_store = AuditGatePostgresStore(mgr)

Testing

# Start PostgreSQL
docker compose up -d

# Run tests
DATABASE_URL="postgresql://actiongate:actiongate@localhost/actiongate_test" pytest tests/ -v

License

Apache-2.0