PostgreSQL Store

The PostgreSQL store uses grove ORM with the pgdriver backend and includes Go-based migrations.

Usage01

import (
    "github.com/xraph/grove"
    "github.com/xraph/grove/drivers/pgdriver"
    "github.com/xraph/warden/store/postgres"
)

db, err := grove.Open(pgdriver.New(
    pgdriver.WithDSN("postgres://user:pass@localhost:5432/warden"),
))
if err != nil {
    log.Fatal(err)
}

pgStore := postgres.New(db)
defer pgStore.Close()

// Run migrations (creates tables if they don't exist)
if err := pgStore.Migrate(ctx); err != nil {
    log.Fatal(err)
}

Migrations02

The store includes Go-based migrations that create:

All tables include:

• tenant_id column for multi-tenant isolation

• Appropriate indexes for query performance

• Unique constraints to prevent duplicates

JSONB Fields03

Complex fields are stored as JSONB:

• warden_policies.subjects — []string

• warden_policies.actions — []string

• warden_policies.resources — []string

• warden_policies.conditions — []Condition

• warden_policies.metadata — map[string]any

• warden_resource_types.relations — []RelationDef

• warden_resource_types.permissions — []PermissionDef

When to Use04

• Production deployments

• Multi-instance services (shared database)

• When you need ACID transactions and durability